Adding the Payables Transaction Description to GL Detailed Trial Balance

Question:

How can I add the Payables Transaction Description to Detailed Trial Balance in General Ledger?

Answer:

To add the Payables Transaction Description (Description field in the Payables Transaction Entry screen) to Detailed Trial Balance in General Ledger follow these steps.

NOTE: The following steps are for the Detailed Trial Balance report in General Ledger. Assumptions for this report are as follows: The report is to be printed for an open year in General Ledger. Also, the Trial Balance Report option is set to Subtotal By: No Subtotals. This will only pull the information for invoices that are in history. You can either pull the open or the historic information but not both.

1. Go into Report Writer (Tools-Customized-Report Writer).

2. Choose the Tables icon from the top menu bar. In the Tables window, highlight the GL_YTD_TRX_Open and choose the Open button.

3. In the Table Definition window choose the Relationships button. Then choose the New button.

4. Click on the Ellipse button. (The button with three periods). Select the PM Paid Transaction History file and click OK.

5. For the Secondary Table Key select: Key 6
Match the appropriate fields:
Primary Table: ...............................Secondary Table:
Originating Control Number ...............Voucher Number
Choose OK. Close the Table Relationship window by clicking on the X in the upper right corner of the window.

6. Click OK .

7. Click on the Reports icon from the top menu bar.

8. From the Original Reports side, highlight the Trial Balance Detail and choose Insert .
Then, on the Modified Reports side, highlight the same report and choose the Open button.

9. In the Report Definition window choose the Tables button.

Tables:
1. In the Report Table Relationships window, highlight the Year-To-Date Transaction Open and choose the New button.
2. Highlight the PM Paid Transaction History and choose the OK button.


Restrictions:
1. In the Report Restrictions window choose New.
2. Name the restriction: Pm Trx History
3. In the fields section:
Click on the drop down list for Report Table and choose the PM Paid Transaction History.
Click on the drop down list for Table Fields and choose 1099 Amount.
Choose the Add Field button.

4. In the operators section:
Choose the = button.

5. In the fields section:
Click on the drop down list for Report Table and choose the PM Paid Transaction History.
Click on the drop down list for Table Fields and choose 1099 Amount.
Choose the Add Field button.

The Restriction Expression should read: PM_Paid_Transaction_HIST.1099 Amount= PM_Paid_Transaction_HIST.1099 Amount

Layout:
1. Choose the Layout button.
2. Bringing fields onto the report:
In the Toolbox, choose PM Paid Transaction Hist from the drop down list.
In the scrolling window, find Transaction Description and drag it into the B section on the report.

Leaving Report Writer:
1. Choose the X from the top right corner of the Report Layout window and save your changes.
2. Click OK in the Report Definition window. From the top menu bar, choose File - Great Plains Dynamics.
3. Give users access to the modified report in the Security Setup window (Setup - System - Security) within Dynamics.







This article was TechKnowledge Document ID: 25376