Error: Unable to load data list. Arithmetic overflow error converting money to data type numeric - when loading discounts list in Altru

The discount list isn't loading. When loading the discounts list in Altru the following error may occur: 
Unable to load data list. Arithmetic overflow error converting money to data type numeric.
When the database contains a by quantity discount with a calculation type of specific price and a price that is at least a million dollars ($1,000,000.00), the discounts list may fail to load. 

Alternative Solution: 
  1. Reduce the price of the offending record.
  • Search in Application Features for Discount Page and then open the record to update.

Steps to Duplicate

  1. Log in to Altru
  2. Click Tickets > Ticket and merchandise discounts to view the Discounts List.
  3. Add a By quantity discount.  Fill in a name, and set the calculation type to Specific price.  
  4. Add a row in the grid for Quantity of at least = 3, Price per ticket = $1,000,000.00.
  5. Click Save.
  6. Return to the Discounts list (you may have to reload the page)
  7. Receive the following error: Unable to load data list. Arithmetic overflow error converting money to data type numeric.

Environment

 Altru Arts & Cultural

Was this article helpful?