2 ms·
Close, but wrong, You should store it highest precision, but calculate on a configurable rounding scheme. Some accounting systems always round line items to 2
by malux85 10y ago
Close, but wrong,
You should store it highest precision, but calculate on a configurable rounding scheme.
Some accounting systems always round line items to 2 decimal places, some always round with 3.
Some round tax to 3 DP because it's a regulatory requirement.
You would think it doesn't matter much, but in many places it does -- especially businesses that sell many, small priced items, and have invoices that are thousands of lines long .. 2dp/3dp rounding (and rounding on discount % calculations too) can mean that invoices are 10's or hundreds of dollars out.
Store high precision, calculations are configurable.