How to add multiple sales orders to the POP Purchase Order Blank Form report in Microsoft Dynamics GP

INTRODUCTION

This article describes how to use Report Writer to add multiple sales orders to the POP Purchase Order Blank Form report in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.

MORE INFORMATION

When you modify the POP Purchase Order Blank Form report, you must delete the purchasing manufacturer information so that you can link the additional tables to the report. To add multiple sales orders to the POP Purchase Order Blank Form report, follow these steps.

Back up the Reports.dic file, and then open Report Writer

If you have any modified Microsoft Dynamics GP reports, back up the Reports.dic file. To locate the Reports.dic file, follow these steps:

a.	Follow the appropriate step: • In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup , point to System , and then click Edit Launch File . • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Setup on the Tools menu, point to System , and then click Edit Launch File .
b.	If you are prompted, type the system password.
c.	Follow the appropriate step: • In Microsoft Dynamics GP 10.0 and in Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP in the Edit Launch File window. • In Microsoft Business Solutions - Great Plains 8.0, click Great Plains in the Edit Launch File window.
d.	Note the path that appears in the Reports box.
e.	To close the Edit Launch File window, click OK .

Follow the appropriate step:

• In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Customize , and then click Report Writer . • In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions - Great Plains 8.0, point to Customize on the Tools menu, and then click Report Writer .

Follow the appropriate step:

• In Microsoft Dynamics GP 10.0 and in Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP in the Product list, and then click OK . • In Microsoft Business Solutions - Great Plains 8.0, click Great Plains in the Product list, and then click OK.

Create table relationships

1.	Click Tables , and then click Tables .
2.	Click popPOLineRollupTemp , click Open , click Relationships , and then click New .
3.	Click the ellipsis button (...) next to the Secondary Table field, click Purchase Order Line , and then click OK .
4.	In the Secondary Table Key field, click POP_POLineIdxID .
5.	In the Primary Table list, click PO Number to match the PO Number field in the Secondary Table column.
6.	In the Primary Table list, click Ord to match the Ord field in the Secondary Table column.
7.	In the Primary Table list, click Break Field 1 to match the Break Field 1 field in the Secondary Table column, and then click OK .
8.	Close the Table Relationship window, and then click OK in the Table Definition window.
9.	In the Tables window, click POP_POLine , click Open , click Relationships , and then click New .
10.	Click the ellipsis button (...) next to the Secondary Table field, click SOP_POPLink , and then click OK .
11.	In the Secondary Table Key field, click SOP_POPLinkIdxPO .
12.	In the Primary Table list, click PO Number to match the PO Number field in the Secondary Table column.
13.	In the Primary Table list, click Ord to match the Ord field in the Secondary Table column, and then click OK .
14.	Close the Table Relationship window, click OK in the Table Definition window, and then close the Tables window.

Open the report

1.	Click Reports .
2.	In the Original Reports pane, click POP Purchase Order Blank Form , and then click Insert .
3.	In the Modified Reports pane, click POP Purchase Order Blank Form , and then click Open .
4.	Click Tables .
5.	Click Purchasing Manufacturer Numbers , and then click Remove . When you are prompted to remove the table, click OK .
6.	Click Purchase Order Line Rollup Temp , and then click New .
7.	Click Purchase Order Line , and then click OK .
8.	Click Purchase Order Line , and then click New .
9.	Click SOP_POPLink , and then click OK .
10.	Click SOP_POPLink , and then click New .
11.	Click Sales Transaction Work , click OK , and then click Close .

Modify the restrictions

1.	In the Report Definition window, click Restrictions .
2.	Click MFG PO , and then click Delete . When you are prompted to delete the restriction, click Yes .
3.	In the Report Restrictions window, click New , and then type a name in the Restriction Name field.
4.	In the Report Table list, click Sales Transaction Work .
5.	In the Table Fields list, click SOP Number , and then click Add Field .
6.	In the Operators area, click = .
7.	Click Add Field , click OK , and then close the Report Restrictions window.

Modify the report layout

1.	In the Report Definition window, click Layout .
2.	Click Tools , and then click Section Options .
3.	In the Additional Headers section, click MFG Item Header , and then click Remove . When you are prompted to remove the header, click Yes .
4.	Click to clear the Body check box.
5.	In the Additional Headers area, click Comment3 Header , and then click New .
6.	In the Header Options window, type a name in the Header Name field.
7.	In the Report Table list, click Sales Transaction Work .
8.	In the Field list, click SOP Number .
9.	Click to clear the Suppress When Field Is Empty check box, click OK , and then click OK to create the H4 section on the report layout.
10.	In the Toolbox list, click Sales Transaction Work .
11.	Drag SOP Number to the H4 section on the report layout.
12.	Close the Report Layout window. When you are prompted to save the changes, click Save .
13.	In the Report Definition window, click OK .
14.	Exit Report Writer. To do this, follow the appropriate step: • In Microsoft Dynamics GP 10.0 and in Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP on the File menu. • In Microsoft Business Solutions -Great Plains 8.0, click Microsoft Business Solutions-Great Plains on the File menu.

Assign security permissions to the modified report

To assign security permissions to the modified report, use one of the following methods.

Method 1: Use security in Microsoft Dynamics GP 10.0

1.	On the Microsoft Dynamics GP menu, point to Tools , point to Setup , point to System , and then click Alternate/Modified Forms and Reports .
2.	In the ID box, type the user ID of the user who will print the report that you modified.
3.	In the Product list, click Microsoft Dynamics GP .
4.	In the Type list, click Reports .
5.	Expand Purchasing .
6.	Expand the folder for the report that you modified.
7.	Click to select the Microsoft Dynamics GP (Modified) check box.
8.	Click Save .
9.	On the Microsoft Dynamics GP menu, point to Tools , point to Setup , point to System , and then click User Security .
10.	In the User list, click a user ID.
11.	In the Company list, click a company.
12.	In the Alternate/Modified Forms and Reports ID list, click the ID from step 2.

Method 2: Use the Advanced Security tool in a version that is earlier than Microsoft Dynamics GP 10.0

1.	On the Tools menu, point to Setup , point to System , and then click Advanced Security .
2.	If you are prompted, type the system password in the Please Enter Password box, and then click OK .
3.	In the Advanced Security window, click View , and then click By Alternate, Modified and Custom .
4.	Follow the appropriate step: • In Microsoft Dynamics GP 9.0, expand Microsoft Dynamics GP . • In Microsoft Business Solutions - Great Plains 8.0, expand Great Plains .
5.	Expand Reports , expand Purchasing , and then expand the report that you modified.
6.	Follow the appropriate step: • In Microsoft Dynamics GP 9.0, click Microsoft Dynamics GP (Modified) . • In Microsoft Business Solutions - Great Plains 8.0, click Great Plains (Modified) .
7.	Click Apply , and then click OK .Note By default, when you start the Advanced Security tool, the current user and the current company are selected. Any changes that you make affect the current user and the current company. However, you can select additional users in the Users area of the Advanced Security window. You can select additional companies in the Company Name area of the Advanced Security window.

Method 3: Use the Standard Security tool in a version that is earlier than Microsoft Dynamics GP 10.0

1.	On the Tools menu, point to Setup , point to System , and then click Security .
2.	If you are prompted, type the system password in the Please Enter Password box, and then click OK .
3.	In the User ID list, click the ID of the user who you want to have access to the modified report.
4.	In the Type list, click Modified Reports .
5.	In the Series list, click Purchasing .
6.	In the Access List box, double-click the report that you modified, and then click OK .Note An asterisk (*) appears next to the report name.

APPLIES TO

•	Microsoft Dynamics GP 10.0
•	Microsoft Dynamics GP 9.0
•	Microsoft Business Solutions–Great Plains 8.0
•	Purchase Order Processing
•	Report Writer
•	Sales Order Processing