Purchase Order Number on the Sales Open Order Report


TechKnowledge Content


SUMMARY

How to add the PO number, from the SOP to POP link, onto the Sales Open Order Report?

MORE INFORMATION

Follow the steps to follow to add the PO number to the SOP Open Order Report:
 
1. Go into Report Writer ( Tools - Customize - Report Writer ).
2. Click on the Reports button.
3. Find and select the SOP_HDR_WORK table and choose Open .
4. Click on the Relationships button and then select New .
5. Next to the Secondary Table field click the elips (...) button.
6. Find and select the SOP_POPLink table and click Ok .
7. For the Secondary Table Key, select the SOP_POPLinkidxSO.
8. item two
9. Match up SOP Type and SOP Number for the Primary and Secondary Table Relationships and leave Line Item Sequence and Component Sequence blank then click Ok .
10. Close the Table Relationship window, select Ok on the Table Definition window and close the Tables window.
11. Click on the Reports button from the top menu bar.
12. Find the SOP Activity Order Detail Report in the Original Reports column and insert it into the Modified Reports column.
13. Select the SOP Activity Order Detail Report from the Modified Reports column and choose Open .
14. From the Report Definition Window, select the Tables button.
15. Highlight the Sales Transaction Amounts Work table and choose New .
16. In the Related Tables window, select the SOP_POPLink and then Ok .
17. Close the Report Table Relationships window.
18. Click on the Layout button to open the Report Layout .
19. Select the SOP_POPLink from the toolbox dropdown list.
20. iPull the PO Number field onto the report into the H2 section.
21. Close the Layout and the Report Definition window and Save your changes.
22. Go to File - Great Plains Dynamics/eEnterprise .
23. Grant security to the modified report in Security Setup ( Setup - System - Security) .


This article was TechKnowledge Document ID: 25287

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.