Adding Notes from Inventory on General Ledger Trial Balance


TechKnowledge Content


Issue:

How can I pull my Notes from Inventory transactions onto the GL Trial Balance?

Note: These transactions are being entered directly into Inventory by going to Transactions, Inventory, Transaction Entry, or Transfer Entry.

Resolution:

Follow the steps to modify the Trial Balance Detail report to show the Inventory Notes in Report Writer.

Go into Report Writer.

1. Opening the Report:
Click on the Reports icon from the top menu bar.
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.

2. LINKING:
Choose the Tables icon from the top menu bar.
In the Tables window, highlight GL_YTD_TRX_OPEN and choose the Open button.
In the Table Definition window choose the Relationships button.
Then choose the New button.

New :
Click on the Ellipsis button to the left of the Secondary Table line. (The button with three periods)
Select the Inventory Transaction History and click OK .
For the Secondary Table Key select: Key 1
Match the appropriate fields:
Primary Table: Secondary Table:

Originating TRX Source TRX Source
Originating Type IV Document Type
Originating Document Number Document Number
Choose OK .

In the Tables window, highlight IV_TRX_Hist_HDR and choose the Open button.
In the Table Definition window choose the Relationships button.
Then choose the New button.

New :
Click on the Ellipsis button to the left of the Secondary Table line. (The button with three periods)
Select the Record Notes Master and click OK .
For the Secondary Table Key select: Key 1
Match the appropriate fields:
Primary Table: Secondary Table:

Note Index Note Index

Choose OK .
Close the Table Relationships window by clicking on the X in the upper right corner of that window.
Click OK .
Close the Tables window by clicking on the X in the upper right corner of that window.

3. Tables:
In the Report Table Relationships window, highlight the Year To Date Transaction Open and choose the New button.
Highlight the Inventory Transaction History and choose the OK button.
Highlight the Inventory Transaction History and choose the New button.
Highlight the Record Notes Master and choose the OK button.
Select the Close button.

4. Layout:
Choose the Layout button.

Bringing fields onto the report:
In the Toolbox choose Record Notes Master from the drop down list.
In the scrolling window find Text Field and drag it into the B section on the report.
You may need to move the Body down a line to place the text field on the report.

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

This article was TechKnowledge Document ID: 18017

DISCLAIMER


MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, THE RELIABILITY OR THE ACCURACY OF THE INFORMATION THAT IS CONTAINED IN THE DOCUMENTS AND THE RELATED GRAPHICS PUBLISHED ON THIS WEB SITE (THE “MATERIALS”) FOR ANY PURPOSE. 

THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE. TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON-INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS. 

-------------------------------------------------------------------