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

On the Tools menu, point to
Setup, point to System, and then click
Edit Launch File.

If you are prompted to enter a system password, type your password, and then click OK.

Click Great Plains. The path of the Reports.dic file appears in the Reports box in the
Dictionary Locations section.

Use Windows Explorer to make a backup copy of the Reports.dic file

Click Reports.

In the Original Reports list, click
POP Purchase Order Blank Form, and then click
Insert.

In the Modified Reports list, click
POP Purchase Order Blank Form, and then click
Open.

In the Report Definitions dialog box, click Tables.

In the Report Table Relations list, click
Purchasing Manufacturer Numbers, and then click
Remove.

If you are prompted to confirm the removal of this table and related tables, click OK.

In the Report Table Relationships dialog box, click Close.

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.

In the Report Definition dialog box, click
Layout.

On the Tools menu, click Section Options.

In the Additional Headers list, click
MFG Item Header, and then click Remove. If you are prompted to confirm the deletion, click Yes.

Click to clear the Body check box, and then click OK to return to the layout.

On the Layout tab in the toolbox, click Calculated Fields in the
Resource list.

In the list of resources, click
nSuppressMFGHeader, and then click
Open.

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.

In the list of resources, click
nSupressMFGItem, and then click
Open.

Repeat step 8a through step 8e.

Close the report layout. If you are prompted to save your changes, click Save.

In Report Writer, click Tables, and then click Tables.

In the Tables list, click
popPOLineRolluptemp, and then click Open.

In the Table Definition dialog box, click
Relationships.

In the Table Relationship dialog box, click New.

Click the ellipsis button (...).

In the RelationshipTable Lookup list, click Purchase Order Line, and then click OK.

In the Secondary Table Key list, click
POP_POLineIdxID.

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.

Close the Table Relationship dialog box.

Click OK to close the Table Definition dialog box.

Close the Tables dialog box.

If you are prompted to save your changes, click
Save.

In the Report Definition dialog box, click
Tables.

In the Report Table Relationships dialog box, click 07.-Purchase Order Line Rollup Temp*, and then click New.

In the Related Tables dialog box, click
Purchase Order Line, and then click
OK.

Close the Report Table Relationships dialog box.

In the Report Definition dialog box, click
Layout.

On the Layout tab in the toolbox, click Purchase Order Line in the
Resource list.

In the list of resources, drag Requested by to the H3 section of the report.

Close the report layout. If you are prompted to save changes, click Save.