Having an issue with the Rounding Account's amount getting stored in the wrong currency column (amount moved from Functional Currency into Originating Currency column) after a Posting an Invoice. The resulting Journal Entry distributions end up out of balance, as well as the Posted Sales Distributions.
NOTE: Manufacturing module part of Install.
Steps taken:
1. Created Invoice via the Sales Transaction Entry window.
2. Currency ID being used is Z-UK with Exchange Rate of 1.2353210.
3. Functional Currency is US$.
4. Entered six different Items, some with Markdown amounts, using Originating Currency (Z-UK) which results in a Functional Currency Rounding value of .01 (which is Valid).
5. Viewed the Sales Distribution window and can see the valid Rounding Account with an amount of $.01 in the Debit column and ,00 in the Originating Debit column (WHICH IS CORRECT).
6. Functional Currency Debit/Credit totals match.
7. Originating Currency Debit/Credit totals match.
8. Invoice gets Posted.
9. View the Rounding account inside the Sales Distribution Inquiry Zoom window and see that the Originating Debit amount now shows ,01 and the Functional Currency Debit amount shows .00 (should be the other way around).
10. Both Functional Totals and Originating Totals are now off by .01 and ,01.
What appears to be happening is that when posting the Rounding Account's amount is being moved from the Functional Currency column into the Originating Currency, putting both currency totals out of balance and preventing the associated Journal Entry from being posted (until we manually adjust the Rounding account's amount).
Any ideas of what might be causing this and how to prevent it? Obviously, we can create a SQL Script to correct the records in the SOP10102 and GL10001 tables, but would like to avoid this if possible.
TIA!
Michael J. Nola