RMAPY Editing

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

twelvestrikes 3,657 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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.

Was this reply helpful? Yes No
twelvestrikes 3,657 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Althea ADS 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No