Editing Datapiped Purchase Order Forms

Purchase Orders includes both "datapiped" and "non-datapiped" purchase order forms. You may be able to print these templates "as is," or you can use SAP Crystal Reports® to change the layout to suit your needs (or to create your own forms).

A "datapipe" is a dynamic link library (DLL) program that performs database queries for reports or forms. More...

Because datapipes are compiled and optimized for specific reports, they can provide significant performance advantages over reports that use standard database access techniques (ODBC access).

The disadvantage of datapipes is that they provide access to a fixed group of fields. You cannot customize a datapiped report as much as you can customize non-datapiped one.

For more information on designing and adapting forms and reports, see the Customizing Printed Forms guide, which is available online.

You can also include detail comments and instructions, item information, and/or vendor information (such as Web site and e-mail addresses, and vendor optional fields) on the purchase order forms. To do so, you set certain parameters in the PORPT.INI datapipe query to 1.(If the information is not required on the forms, set the parameter to 0.)

To edit datapiped purchase order forms:

  1. In your Sage 300 program folder, locate the PORPT.INI file, and then open it in text editing software.
  2. To include detail comments and instructions, item information, and/or vendor information, set the following parameters to 1:
    • Parameter 12 (comments and instructions)
    • Parameter 13 (item information)
    • Parameter 14 (vendor information)
    • Parameter 15 (vendor optional fields)
    • Parameter 16 (header optional fields)
    • Parameter 17 (item optional fields)
    • Parameter 18 (detail optional fields)

    Note: If the information is not required on the forms, set the parameter to 0.

  3. Save, and then close the file.
  4. Restart Sage 300.