currency precision
Summary:
There is a rounding issue when posting an FA transaction (in local currency) from the Primary Ledger (in USD) to the Secondary Ledger (in local currency). Since the currency precision of USD is 2 digits, when an FA transaction in local currency is converted to USD in the primary ledger and then reconverted to local currency in the secondary ledger, the resulting amount in the secondary ledger may differ slightly from the original invoice currency by a few cents.
For instance, if the proceeds of sale are SGD 70,225.00, the equivalent in USD is 54,003.025. This gets rounded to USD 54,003.03 in the primary ledger, and then reconverted to SGD 70,225.01 in the secondary ledger, causing a 1-cent discrepancy. Ideally, the AR miscellaneous receipt should match the original SGD 70,225. What solutions are available to prevent rounding issues in the FA module?