CD - Invoice/Credit Upload
Overview
The Commercial Debtors ‘Invoice/Credit Upload’ program provides a convenient method to upload charge and credit transactions from a correctly formatted comma-delimited file. This is an alternative to entering charge and credit transactions individually through Finance > Commercial Debtors > Customer Transactions > Invoices or Credits.
The comma-delimited upload file can be easily created from a Microsoft Excel® spreadsheet.
For this charge and credit upload to be successful, the spreadsheet must conform to the specifications that follow.
The spreadsheet must be saved in comma-delimited (CSV) format and contain the following columns:
Field No. | Field Name | Field Type/Size | Field Description |
|---|---|---|---|
A | Transaction Type | char(1) | Transaction type single character "1" = Invoice, "3" = Credit - NOT NULL. |
B | Customer Code | char(8) | Customer code. Must be a valid TASS customer code - NOT NULL. |
C | Transaction Date | date | Transaction date in the format dd/mm/yyyy - NOT NULL. |
D | GL Account | char(18) | GL account code. Must be a valid TASS GL account code - NOT NULL. |
E | Tax Code | char (3) | Transaction tax code. Must be a valid TASS tax code - NOT NULL where ABN is present. |
F | Tax Percentage | decimal (5,2) | Transaction tax percentage must be greater than or equal to zero. 2 decimal places if required – NOT NULL. |
G | Transaction Amount | money | Transaction amount must be greater than zero. Money amount with 2 decimal places if required - NOT NULL. |
H | Tax Amount. | money | Tax amount must be greater than or equal to zero. 2 decimal places if required - NOT NULL. |
I | Total Amount. | money | Total amount must be greater than zero. 2 decimal places if required (must equal 7+ 8) - NOT NULL. |
J | Description | char(4000) | Transaction Description, up to 4000 chars of free-form text. No embedded commas. |
The sheet must NOT have header or footer rows.
All formats must be removed from this sheet (Within Microsoft Excel® go Edit > Clear > Formats).
Money amounts must be formatted to display 2 digits after the decimal point.
Remove all other formats from money amounts including '$' and ',' separators for thousands.
All fields cannot be at a 'NULL' value.
When the CSV file has been saved, select the 'Browse' button to locate and attach the file.
Select the 'GO' button to proceed with uploading the charges and credits file.
At the completion of a successful upload, the following message 'Invoice/Credit Upload successfully completed. NNN Invoices created and NNN Credits created' will be displayed.