Steps to Modify the MC POP Received/Not Invoiced by Vendor Report to Include Sales Order Number Linked to Each PO

Question:

I would like to add the SOP Number to my POP Received/Not Invoice Report so that I can verify which Orders have been received. How can I do this?

Answer:

Go into Report Writer .

Choose the Tables icon from the top menu bar.

In the Tables window, highlight popReceivedNotInvoicedTemp and choose the Open button.

In the Table Definition window choose the Relationships button.

Then choose the New button.

New :

Click on the Ellipses button to the left of the Secondary Table line. (The button with three periods)

Select the SOP_POPLink and click OK .

For the Secondary Table Key select: SOP_POPLinkIdxPO

Match the appropriate fields:

Primary Table: Secondary Table:

PO Number PO Number

Ord Ord

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.

Opening the Report:

Click on the Reports icon from the top menu bar.

From the Original Reports side, highlight the MC POP Received/Not Invoiced by Vendor and choose insert.

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

In the Report Definition window choose the Tables button.

In the Report Table Relationships window, highlight the Purchasing Received Not Invoiced Temp and choose the New button.

Highlight the SOP_POPLink* and choose the OK button.

Select the Close button.



Choose the Layout button.

Bringing fields onto the report:

In the Toolbox choose SOP_POPLink from the drop down list.

In the scrolling window find SOP Number and drag it into the H4 section on the report.



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.

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



This article was TechKnowledge Document ID: 22987