This utility is used to upload a comma-delimited text (.txt) or comma-separated values (.csv) file to create invoice records. Once the records are imported, the invoices are given an “Approved” status. The invoices can be printed; however, cannot be edited or deleted.

Notes:

• A separate invoice record is created for each row of data in the file, and the Invoice Numbers are assigned in sequential order.
• Commas may only be used in the file to separate data values, not within a field (e.g., (Invoice) Description field).
• The current system date will populate any blank Date Requested fields. If there are any invalid dates, an error is displayed on the report and the import is not completed.
• Decimal places are not implied for amounts (e.g., 6789 indicates $6,789.00 and 67.89 indicates $67.89). You can enter 11 numeric characters with two decimal places, or if using whole numbers, you can enter nine numeric characters.
• Account codes are validated on the Finance > Maintenance > Create Chart of Accounts page.

Import Invoices File Layout