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

Applies to: Dynamics GP 2010Dynamics GP 2013Microsoft Dynamics GP 2015

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

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

  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.