You’re offline. This is a read only version of the page.
We have a number of batches with an error status that require editing but I'm not sure how to edit them.
The issues are appearing when US invoices are being paid and the payment is applied. I know it has to do with Foreign Exchange. The issue is that the company uses multiple A/R accounts and the system is not able to select a default when posting the F/X Gain and Loss.
When I try to edit the batch I get a message saying "This distribution was created for a rounding difference or gain or loss amount. It can't be modified."
How do I get these batches to post to the GL?
Thanks!
*This post is locked for comments
Our customer is having a similar issue. They billed the customer in MC and received payment in MC, but when they applied there was a GL entry created (batch RMAPYXXX) where there was a -.01 debit and a -.01 credit. This will not post because they are negative. Also you cannot edit this transaction. You receive the message "This distribution was created for a rounding difference or gain or loss amount. It can't be modified".
What are they to do in this case? They have all accounts assigned to both currencies and have default gain/loss accounts defaulted as well.
Any guidance is greatly appreciated!
Thanks,
Althea
As you are now talking about credit and debit memos, that means most likely that you are in the Receivables Transaction entry window.
Select your transaction
click on the Distribution button
At the top of the window, click on Default. That should restore the entries you need if you have all the accounts pre-setup.
Hi,
We had the accounts set up for the Exchange Gain/Loss but what was missing was an offset account for Credit and Debit memos. We have set those up today to avoid this issue in the future.
We received no warnings in the Apply Sales Documents window at the time of entry. The errors were discovered when trying to post to batches to the GL. We were able to fix most of them by adding the accounts and posting.
We have now encountered a further error where the amount has been removed from one line and the entry is unbalanced, GP will not let us adjust this amount so we are unable to post the entries.
I am just starting with this company and trying to get this year off right. I have made some changes to GP but this error is new to me.
Hi Global Flow
I have clients that use multiple currencies and don't have this issue. I setup global default accounts for Exchange Gain/loss
Go to Microsoft Dynamics GP > tools > Setup > Posting > Posting Accounts
Select Financial for the series and enter the accounts. Make sure you enter an account for Rouding Write off and Rounding difference.
I am not sure if you are in the Cash Receipts entry window and applying the payment to the invoice or if you are in the Apply Sales Documents window when you receive the warning message.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (