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:

The Two Big Mistakes Made In Business Central Number Series, IMHO

In My Humble Opinion... by Steve Endow I'm noticing that Business Central number series (No. Series) configuration is apparently not rec...