This release provides the ability to load Export Shipper Invoices from a .csv file that contains more than one invoice in the file.
In AU the file can be loaded from Sundry>Down Load Data Files>Load Export Invoice File.
In NZ the file can be loaded from Down Load Data Files>Load Export Invoice File.
The format for the CSV file is configured in this screen. Select a pre-existing template for the load file or create a new template. The templates must include all the mandatory columns, which are indicated with a ‘*’ in the name. The columns can be in any order.
You can then browse to the required CSV file and click on the 
button. The file will then be read into the screen line by line. If the program detects an error you will get a message explaining the problem, however no further lines of the file will be processed after this error (i.e. there are 10 invoice lines in the file, but the system detects a problem on line 5, only the first 4 lines will be loaded). If errors are detected you will probably want to cancel the invoice you are adding, fix the errors in the file, and then start the load process again.
The Import Log will display a summary of the details loaded. Use 
to see more in depth information.
RULES:
The Country, if provided, must be in two digit ISO format (i.e.: CN for China) – PREFERENCE and PREFERENCE RULE, if provided, must be the same codes as used by Australian Customs.
- The file must contain one invoice line per file line.
- Quantity and Amount fields must contain only numbers or decimal point (no dollar signs).
- Each Invoice line must be in the same currency.
- Case is not important; the system will convert all values to Upper Case.