Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Import Purchase Order Receipts

The Import Purchase Order Receipts screen is an add-on preprocessor product in the Materials menu.

Use it to upload purchase order receipts from fixed-length ASCII files or comma-separated files. You can specify the network location and name of the input file, and the application will perform all necessary database and business rule validation. If the input file record is valid, the application modifies the proper Costpoint database tables and the input file extension is replaced by .OLD. If the input file record is invalid, the application creates an error record and saves it to an error file with the extension .ERR. The error file format exactly matches the input file format, so you can modify the error file and resubmit it.

You can review the transactions loaded through this preprocessor on the Manage Purchase Order Receipts screen in Costpoint Receiving.

This preprocessor application is a separately licensed product for Deltek Costpoint. It is available only for an Oracle or an SQLServer database. You must obtain a license from Deltek in order to use this application. Please contact your account manager or Deltek Support Services for more 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.
Note: 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.