Import Purchase Orders
Use the Import Purchase Orders application to import purchase orders from an ASCII fixed-length file.
Only one user at a time can run this application. You can view Purchase Orders loaded from this application using the Manage Purchase Orders screen in Costpoint Purchasing.
Deltek designed the preprocessor interface for loading purchase orders into Costpoint. You can use the loaded purchase orders to perform commitment, accrual, invoicing, and two-way and three-way matching in the Costpoint database into which you loaded them.
An Ongoing Support Plan (OSP) is available for routine maintenance and upgrades to this interface. Customization is priced separately. Please contact your Deltek account representative for additional information.
For detailed functional information regarding purchase orders, see Functional Information.
There are two ways to work with input files in Costpoint
- You can access the input file from the network by using Alternate File Locations.
- You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.
If you decide to use the first option, click in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
Input File Excel Template
Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.
- Related Topics:
- Display the Import Purchase Orders Screen
You access the Import Purchase Orders screen from the Materials domain. - Contents of the Import Purchase Orders Screen
Use the fields and options to configure the Import Purchase Orders screen. - Table Information for the Import Purchase Orders Screen
Changes to the Import Purchase Orders screen update the W_FUNC_PARM_CATLG table. - Functional Information
If the PO vendor is changed in an existing purchase order (PO_HDR), Costpoint updates the corresponding PO_HDR_DFLT row for the vendor-related initial values. This does not update values in existing PO lines. - Setup Procedure
After copying the new files and executing the script file, perform the following setup actions before running the application for the first time. - Processing Details
The Import Purchase Orders application uses the following dynamically created worktables for processing: