You can email the Shipper’s Invoice to Expedient using a standard CSV file format. Email the CSV File to: shipinv@<yourdomain>.com.au. Once this is loaded you will be able to view the Downloaded invoices by clicking the lookup within the Invoice number field.
The format for the CSV is
|
Column |
Format |
Mandatory/Optional/Conditional |
|
Client Code |
char(10) |
Mandatory |
|
Invoice No |
char(10) |
Mandatory |
|
Part No |
char(28) |
Mandatory |
|
Part Description |
char(35) |
Mandatory |
|
Quantity |
decimal(12,2) |
Mandatory |
|
Unit Price |
decimal(12,2) |
Conditional: Mandatory if Line Price not provided |
|
Line Price |
decimal(12,2) |
Conditional: Mandatory if Unit Price not provided |
|
Order No |
Char(20) |
Optional |
|
Currency |
Char(3) |
Mandatory |
|
Cntry of Manufacture |
Char(2) |
Mandatory |
|
Weight |
Decimal(12,2) |
Mandatory |