How to add a field that is named "Requested by" to a purchase order in Microsoft Dynamics GP

Back up the Reports.dic file

1. On the Tools menu, point to
   Setup, point to System, and then click
   Edit Launch File.
2. If you are prompted to enter a system password, type your password, and then click OK.
3. Click Great Plains. The path of the Reports.dic file appears in the Reports box in the
   Dictionary Locations section.
4. Use Windows Explorer to make a backup copy of the Reports.dic file

Remove the report table relationship

1. Click Reports.
2. In the Original Reports list, click
   POP Purchase Order Blank Form, and then click
   Insert.
3. In the Modified Reports list, click
   POP Purchase Order Blank Form, and then click
   Open.
4. In the Report Definitions dialog box, click Tables.
5. In the Report Table Relations list, click
   Purchasing Manufacturer Numbers, and then click
   Remove.
6. If you are prompted to confirm the removal of this table and related tables, click OK.
7. In the Report Table Relationships dialog box, click Close.

Delete the manufacturing restrictions and the manufacturing fields from the report

1. In the Report Definition dialog box, click
   Restrictions, and then follow these steps:
   1. In the Report Restrictions list, click
      MFG PO, and then click Delete. If you are prompted to confirm the deletion, click Yes.
   2. Close the Report Restrictions dialog box.
2. In the Report Definition dialog box, click
   Layout.
3. On the Tools menu, click Section Options.
4. In the Additional Headers list, click
   MFG Item Header, and then click Remove. If you are prompted to confirm the deletion, click Yes.
5. Click to clear the Body check box, and then click OK to return to the layout.
6. On the Layout tab in the toolbox, click Calculated Fields in the
   Resource list.
7. In the list of resources, click
   nSuppressMFGHeader, and then click
   Open.
8. In the Calculated Field Definition dialog box, follow these steps:
   
   1. In the Result Type list, click
      Integer.
   2. In the Expression Type section, click
      Conditional. If you receive a message that says that this operation will destroy the current expression, click Continue.
      
   3. In the Expression Type section, click
      Calculated.
   4. Click the Constants tab.
   5. In the Constant box, type
      0, click Add, and then click
      OK.
9. In the list of resources, click
   nSupressMFGItem, and then click
   Open.
10. Repeat step 8a through step 8e.
11. Close the report layout. If you are prompted to save your changes, click Save.

Create a new report table relationship

1. In Report Writer, click Tables, and then click Tables.
2. In the Tables list, click
   popPOLineRolluptemp, and then click Open.
   
3. In the Table Definition dialog box, click
   Relationships.
4. In the Table Relationship dialog box, click New.
5. Click the ellipsis button (...).
6. In the RelationshipTable Lookup list, click Purchase Order Line, and then click OK.
7. In the Secondary Table Key list, click
   POP_POLineIdxID.
8. In the Primary Table column, select the following fields in the order in which they are listed:
   
   • PO Number
   • Ord
   • Break Field 1
   The fields in the left column should match the fields in the right column. Click OK.
9. Close the Table Relationship dialog box.
10. Click OK to close the Table Definition dialog box.
11. Close the Tables dialog box.
12. If you are prompted to save your changes, click
    Save.

Add the new table

1. In the Report Definition dialog box, click
   Tables.
2. In the Report Table Relationships dialog box, click 07.-Purchase Order Line Rollup Temp*, and then click New.
3. In the Related Tables dialog box, click
   Purchase Order Line, and then click
   OK.
4. Close the Report Table Relationships dialog box.

Add the "Requested by" field to the report layout

1. In the Report Definition dialog box, click
   Layout.
2. On the Layout tab in the toolbox, click Purchase Order Line in the
   Resource list.
3. In the list of resources, drag Requested by to the H3 section of the report.
4. Close the report layout. If you are prompted to save changes, click Save.