Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) A/R DETAILED TRIAL BAL...

A/R DETAILED TRIAL BALANCE

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Folks,

Does anyone out there have knowledge as to how one would add a Customer PO # to the invoices showing up on the Aged Trial Balance w/Options in GP2010 in Report Writer?

It's kind of crazy, but the option seems to be "right there" in the RM DOCUMENT TEMP drop down of the tool box called, cleverly enough, "Customer Purchase Order Number"....but when pulling the field into the report absolutely nothing shows up?

Report Writer is not my strength, so if someone out there could give me specific instructions on how I could add the table that contains the OPEN INVOICE's customer purchase order # it would be greatly appreciated.

take care

Mitchell Dickson

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

soma 24,406 on at

Like (0)

Report

RE: A/R DETAILED TRIAL BALANCE

Follow below steps to add the customer PO number to the RM Aged Trail Balance report.

1. Open the Report Definition window and click the Tables button.

2. In Report Tables Relationship window, select the RM Document Temporary File and click the new button.

3. Then Select the RM Open File and click OK button.

4. Now the Report Tables Relationship window should be as below.

5. Finally, open the report layout and add the Customer PO number from the RM Open file to the report.

Hope this helps!!!