Hi Acrylon,

There is a field on the Sales Order Details record table called 'Unit Decimals' - near the end of the list - that stores the number of decimals of the unit price. Note that this is not used for the Extended Order Price or Extended Invoice Price fields, because these values are stored with the current number of decimals, which is probably 2 for you.

What you would have to do is create a formula that re-calculates the original order price by calculating the qty originally ordered times the unit price, and 'convert' the unit price using the Unit Decimals field. Essentially, all unit prices have to be divided by 100 for those that use 4 decimals, which is 10 ^ 2 (10 to the power of 2), or 10 ^ (4-2). More generally, the formula would be something like:
{Unit Price} * 10 ^ (2-{Unit Decimals})
which will multiply the unit price by 0.01 for those that use 4 decimals, and by 1.0 for those that use 2 decimals.

I don't agree with your statement that Adagio has issues with assuming 2 decimal places, but rather the program stores most currency values in the number of decimal places as the currency, which for most everybody in North America will be 2 decimals.