TechKnowledge Content
Issue:
How do I add the Sales User Defined Field 2 to the SOP Document Inquiry Report by Range?
Resolution:
To add the Sales User Defeined Field 2 to the SOP Document Inquiry Report by Range follow the steps below:
In Report Writer (Tools | Customize | Report Writer), insert the SOP Document Inquiry Report by Range into the modified report side (unless it is already there).
Creating Table Relationships:
- Choose Tables at the top of the window (next to the Report button).
- Highlight SOP_Inquiry_HDR_Temp.
- Choose Open.
- Choose Relationships.
- Choose New.
- Choose the ellipse button (...) beside Secondary Table.
- Highlight Sales User-Defined Work History.
- Choose SOPUsrDefWorkHist_ID as the Secondary Table Key.
- Line up Sop Type and Sop Number.
- Choose OK.
- Choose X on the Table Relationship window.
- Choose OK on the Table Definition window.
- Chose X on the Tables Window.
Adding Tables to the Report
- Highlight the SOP Document Inquiry by Range Report and chose Open on the Report Writer window.
- Choose Tables on the report definition window.
- Double click on Sales Document Inquiry Temp.
- Double click on Sales User Defined Work History.
- Choose Close on the Report Table Relationship window.
Report Layout
- Choose Layout.
- From the Toolbox dropdown the tables and choose Sales User-Defined Work History.
- Find the field User Defined Table 2 and pull it into the body (B) section of the report.
- Save the report by choosing the X on the top right side of the layout.
Exiting Report Writer
- Chose File - Great Plains Dynamics.
- Give access to the report (Setup | System | Security).
This article was TechKnowledge Document ID: 23236