Monday, March 4, 2024

How many digits can a Business Central Amount field actually support?

 by Steve Endow


(If anyone has a technical explanation for the discrepancy between the Docs and the BC behavior, let me know!)


On Sunday night, as I am prone to do, I was testing something obscure in Business Central Online.

I was checking to see how many digits were supported in a "currency" field, aka an Amount field.  Different numeric fields will have different limitations, but I was specifically interested in the limits of currency amounts.

For instance, if I needed to create a transaction in Venezuelan Bolivars, could Business Central handle a large number of Bolivars?  And could it also handle a large number of Bolivars with "cents"?

500,000 US Dollars is approximately 1.8 trillion Bolivars, give or take


So I entered a really big number in Business Central and saw this error:

Type Decimal

So I learned that the data type is Decimal.  I can never remember the maximum data type values, so I searched for "Business Central decimal data type", which led me to this page: