BUG #: 41422 (content maintenance)
INTRODUCTION
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.
More Information
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 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
Remove the report table relationship
-
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.
Delete the manufacturing restrictions and the manufacturing fields from the report
-
In the Report Definition dialog box, click
Restrictions, and then follow these steps:-
In the Report Restrictions list, click
MFG PO, and then click Delete. If you are prompted to confirm the deletion, click Yes. -
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:
-
In the Result Type list, click
Integer. -
In the Expression Type section, click
Conditional. If you receive a message that says that this operation will destroy the current expression, click Continue. -
In the Expression Type section, click
Calculated. -
Click the Constants tab.
-
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.
Create a new report table relationship
-
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.
Add the new table
-
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.
Add the "Requested by" field to the report layout
-
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.