Extracting MC Customer Balance in originating currency

(0) Share

Report

Posted on by Jackie McNab

210

Hi,

Does anyone know if there is a file that has the MC customer balance in originating currency? i need to extract the data and all the tables that carry the balance has it in functional currency.

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Andrea Melroe 3,437 on at

Like (1)

Report

RE: Extracting MC Customer Balance in originating currency

Hi Jackie,

You can see the originating balances in summary on the RM Currency Summary Aging report. This report will print 'after' the Detailed Aged Trail Balance - Options report. You just want to be sure not to exclude multicurrency information when you print it:

Now, this does not break the totals out by customer. However, if you wanted to see a specific customer's balance you can do that by restricting the report to that specific customer.

Beyond that, the ORCTRXAM field in the MC020102 table stores the 'Current Transaction Amount' (balance owed) for Receivables transactions in GP.

I hope this helps!