How to add a field that is named "Requested by" to a purchase order in Microsoft Dynamics GP
This article describes how to add a field that is named Requested by to a purchase order in Microsoft Business Solutions - Great Plains 8.0. The Requested by field will be available for every line item in the purchase order.
Applies to: Microsoft Dynamics GP
Original KB number: 904052
To add a Requested by field to a purchase order so that it is available for every line item in the purchase order, follow these steps.
Back up the Reports.dic file
- On the Tools menu, point to Setup, point to System, and then select Edit Launch File.
- If you are prompted to enter a system password, type your password, and then select OK.
- Select 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
Remove the report table relationship
- Select Reports.
- In the Original Reports list, select POP Purchase Order Blank Form, and then select Insert.
- In the Modified Reports list, select POP Purchase Order Blank Form, and then select Open.
- In the Report Definitions dialog box, select Tables.
- In the Report Table Relations list, select Purchasing Manufacturer Numbers, and then select Remove.
- If you are prompted to confirm the removal of this table and related tables, select OK.
- In the Report Table Relationships dialog box, select Close.
Delete the manufacturing restrictions and the manufacturing fields from the report
In the Report Definition dialog box, select Restrictions, and then follow these steps:
- In the Report Restrictions list, select MFG PO, and then select Delete. If you are prompted to confirm the deletion, select Yes.
- Close the Report Restrictions dialog box.
In the Report Definition dialog box, select Layout.
On the Tools menu, select Section Options.
In the Additional Headers list, select MFG Item Header, and then select Remove. If you are prompted to confirm the deletion, select Yes.
Select to clear the Body check box, and then select OK to return to the layout.
On the Layout tab in the toolbox, select Calculated Fields in the Resource list.
In the list of resources, select nSuppressMFGHeader, and then select Open.
In the Calculated Field Definition dialog box, follow these steps:
In the Result Type list, select Integer.
In the Expression Type section, select Conditional. If you receive a message that says that this operation will destroy the current expression, select Continue.
In the Expression Type section, select Calculated.
Select the Constants tab.
In the Constant box, type 0, select Add, and then select OK.
In the list of resources, select nSupressMFGItem, and then select Open.
Repeat step 8a through step 8e.
Close the report layout. If you are prompted to save your changes, select Save.
Create a new report table relationship
In Report Writer, select Tables, and then select Tables.
In the Tables list, select popPOLineRolluptemp, and then select Open.
In the Table Definition dialog box, select Relationships.
In the Table Relationship dialog box, select New.
Select the ellipsis button (...).
In the RelationshipTable Lookup list, select Purchase Order Line, and then select OK.
In the Secondary Table Key list, select 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. Select OK.
Close the Table Relationship dialog box.
Select OK to close the Table Definition dialog box.
Close the Tables dialog box.
If you are prompted to save your changes, select Save.
Add the new table
- In the Report Definition dialog box, select Tables.
- In the Report Table Relationships dialog box, select 07.-Purchase Order Line Rollup Temp*, and then select New.
- In the Related Tables dialog box, select Purchase Order Line, and then select OK.
- Close the Report Table Relationships dialog box.
Add the "Requested by" field to the report layout
- In the Report Definition dialog box, select Layout.
- On the Layout tab in the toolbox, select 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, select Save.