TechKnowledge Content


How can I add the check number to my General Ledger Detailed Trial Balance?


You can modify the Trial Balance Detail in Report Writer to pull the check number onto it.

NOTE:This will work for checks entered through Manual Payments (Transactions – Purchasing – Manual Payments) and checks entered through Select Checks (Transactions – Purchasing – Select Checks), but will
NOTwork for checks that are entered on the fly (Transactions – Purchasing – Transaction Entry).

1. Go into Report Writer (Tools – Customize – Report Writer)

2. Select the Reports button in the toolbar.

3. Find the Trial Balance Detail in the Original Reports section. Highlight it and click the Insert button.

4. Then on the Modified Reports side, highlight the same report and choose the Open button.

5. In the Report Definition window choose the Layout button.

6. In the
Toolboxchoose Year-to-Date Transaction Open from the drop down list.

7. In the scrolling window find Originating Document Number and drag it into the B section on the report.

8. In the report layout,
double click on the fieldthat was just put on the report.

9. In the Report Field Options window, be sure the
Display Typeis set to Visible.

10. Set the
Field Typeto Data.

11. Choose the

12. Choose the X from the top right corner of the Report Layout window.

13. Save your changes.

14. Click OK in the Report Definition window.

15. From the top menu bar, choose File - Great Plains Dynamics.

16. Give users access to the modified report in the Security Setup window (Setup - System - Security) within Dynamics.

This article was TechKnowledge Document ID:19657

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!