Multicurrency Gains and Losses and the RM HATB

(0) Share

Report

Posted on by Community Member

Hello:

For the Receivables Historical Aged Trial Balance for one customer, an "open" invoice along with its "open" payment and "open" credit memo are appearing. This is true, even though the payment and credit memo completely "pay off" the invoice.

Now, there is a Multicurrency realized gain and loss among these transactions. This would account for the one penny difference between the invoice amount and the combined amounts of the payment and credit memo. (The combined amounts of the payment and credit memo are one penny greater than the total amount of the invoice.)

Is it this Multicurrency realized gain and loss that is causing the invoice and these two documents to appear on the trial balance?

If so, is there a way of fixing this?

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Please disregard. I resolved this issue by updating the APPTOAMT field in the RM20201 table for one of the amounts to have the correct amount upon multiplying the exchange rate times the ORAPTOAM.

Was this reply helpful? Yes No