Suggested by Luca Culurgioni – Rejected
After the release 10.0.32 the rounding process in the conversion of the amounts of the Credit/Debit to the Accounting currency/Reporting currency sometimes (when some combination of amounts and exchange rates are used) generates unbalanced transactions.
I experienced this problem during the Process allocation request where the system generates automatically some unbalanced transactions, this also happens using the general journals.
In my example the accounting currency of the company was EUR and the allocation journal lines were in USD (Exchange rate 0.920302).
I had a line with a debit amount of 5,000.00 and three lines in the credit amount of 2,519.50, 2,033.50 and 447.00.
In USD the journal is balanced but in the Currency section and the Reporting Currency section, the amounts in EUR for Debit and Credit are respectively 4,601.51 and 4,601.50 with a Balance of 0.01.
If I try to post the journal the system doesn't block me and generates a voucher with a unbalanced transaction.
This example is easily replicable also in a general journal entry using the same amounts and exchange rate.
This problem causes a lot of issues during the posting of allocation journals generating a considerable number of unbalanced vouchers.
I raised a question to Microsoft that recognized the problem but didn't plan a fix for it.
Status Details
I believe there is a misunderstanding with this entry. The product doesn't allow an accounting entry to knowingly post an accounting entry where the debits DO NOT = credits, as is required by any accounting system. If you enter the above information into a general journal as described, prior to posting, the voucher does show a penny difference of 0.01 in the accounting currency. But when posting the voucher, the penny difference is accounted for by adding a Penny diffference account to ensure that the total debits = total credits for the accounting and reporting currency.
I believe the request is instead around the current design of the allocation process. Currently the allocation process will allocate amounts in the TRANSACTION currency, which means there could be penny rounding amounts remaining in the balance of the accounting and reporting currency. We have had some requests to change that functionality but haven't as of now.
Based on the description of this request, I'm going to decline the Idea. If additional detail can be added around the allocation request, please add the details or log a new Idea with clarified details.
Kristi Slininger, Finance product manager lead