Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Where is the multi-cur...

Where is the multi-currency information for AR transactions stored?

(0) Share

Report

Posted on by Community Member Microsoft Employee

I want to create a document that outlines what is still owing in the originating currency. For example in a US database if I have a CDN invoice for $100.00 and an applied credit for $25.00 I want to show the $75.00 still owing in CDN funds. I looked at the RM20101 table but it only has the functional currency amount which surprised me. I also looked at all the other 20XXX table but the information was not there either. Next I looked at the AR Multi-currency statement but the tables used were temp tables. If I take the US amount and the exchange rate changed between invoice and credit memo changes I will show the amount owing as different from $75.00! Since the originating amount is not stored in the RM20101 neither is the exchange rate used.

Any help that can be provide would be appreciated.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Where is the multi-currency information for AR transactions stored?

For anyone interested it is in the MC020102 table.