With the introduction of "Post foreign currency realized gains/losses for ledger settlements", we've been having issues with reporting currency amounts. Transactions are settled and exchange rate gains/losses are calculated, but every now and then there is a rounding issue - the resulting balance of the settlement is not 0, but with a penny difference instead. While performing the settlement, there is no warning about it so the user isn't even aware there is a problem. The issue only becomes known when trying to run year-end close because the system won't allow the year to be closed if any settlements are out of balance in the reporting currency.
We would like for F&O to allow the automatic posting of penny difference in this case based on the penny difference parameter in GL parameters, or at the very least a notification of some kind so that users can do timely corrections.
Comments
I am not sure, I understand the improvement asked for - so, I will try to clarify:If the "Post foreign currency realized gains/losses for ledger settlement" is enabled in the GL parameters, D365FO will post a currency gain/loss transaction when settling two ledger transactions that have balancing (debit/credit) accounting currency, but where reporting currency does not balance (this can happen due to exchange rate differences between the accounting currency and the reporting currency on the days of the two ledger transactions being settled) - for example (accounting currency is USD and reporting currency in EUR):Debit 1st May 2025 USD 1000.00 EUR 885.21Credit 7th May 2025 USD 1000.00 EUR 886.33In the above example, a currency gain will be posted, when these two transactions are settled with each other. This currency gain is posted against the Main account of the transactions being settled and offset to the account set up in Accounts for currency revaluation (under General ledger -> Ledger setup -> Ledger)D365FO will not use the penny difference configuration in the General ledger parameters, as this is not a penny difference, it is a currency gain/loss, and therefore it uses the Accounts for currency revaluation.It is correct that if the above mentioned "Post foreign currency realized gains/losses for ledger settlement" is not enabled, and the two transactions from the example above are settled with each other, then you will most likely receive an error when performing the Year-end close, as you describe. Therefore, unless you want to manage the currency gain/loss in reporting currency manually (=post them using the Reporting currency adjustment journals, and include these adjustments in ledger settlements), the recommendation is to enable "Post foreign currency realized gains/losses for ledger settlement"
Category: General Ledger