60
Hello,
Has anyone been experiencing issues with FX rounding in GP when applying payments to an invoice that is in local currency? We currently see that while the invoice has been fully applied/paid, it is being applied either $0.01 more or less. This results in a penny left on our aging. Our currency rate for conversion is only to 2 decimal places and think that it has to do with this, maybe carry it out to 5 decimal places?
Your thoughts?
Thx.
*This post is locked for comments
Hi,
Were you able to find a fix to this? I'm having the exact same issue where we have to write-off the remaining amount. I read in another forum to create an account specifically for these rounding differences, but I wanted to see if there was another process that could completely skip this process. Thanks.
Hi Ian,
We enter invoices in local currency and then apply the payment in USD and write-off any differences to FX difference. The issue that we are seeing is that for some invoices, when we enter the cash to the account and then create a credit memo to write-off the difference, the system automatically creates a penny when the cash is applied to the account and then again when the credit memo is created for the write-off. Hence, we are left with 2 pennies. The system is automatically posting the penny to the GL but it leaves the aging with the 2 pennies. The rounding difference is in USD, functional currency. In order to clear the 2 pennies, we would then have to write-off the 2 pennies which is a lot of work for us to track which account is triggering this.
Are you seeing it as well and how are you currently handling cash application for invoices that are in local currency (UK, AUD, etc.) and credit memos.
Thanks.
Can you explain your multicurrency process. If this is in fact rounding, then the rounding amount should be handled automatically. Is the rounding difference in functional or originating currency?
Best regards,
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
