Job Cost commitment import file example

File Types

There are four types of commitment records that you can import.

• Commitment
• Commitment Item
• Commitment Change Order
• Commitment Item Change Order

General Information

General information about commitment import files. See the Job Cost Help topic "Import commitments file" for more detailed information.

• When you import commitments, the commitment record comes first, followed by the commitment line items
• When you import commitment change orders, the commitment change order comes first, followed by the change order items
• If you're importing the commitment change order and its commitment in this file, the commitment must come first in the file
• Import file rows that start with a semi-colon is a comment line; Job Cost ignores these lines
• Some columns are a check box
  • Use a 1 to select the check box
  • Use a 0 or blank to clear the check box
• Enter the amount of the line item, or enter a unit and unit cost to calculate the amount
• Set up the job or extra before importing, or the lines will reject

Review the import file for rejections. One rejection can cause multiple related rejections.

Sample file

You can download the file below as an example of the layout of a Job Cost commitment import file.

Attachment: POimport.txt

How do I import commitments in Job Cost?