You can email the Supplier’s invoice using a CSV file. Ensure with Expedient that you have an email address set up to accept these files.
The file needs to be CSV format, NOT Excel, txt, doc, etc.
Only the specified fields can be used in the following order.
Columns A to F are mandatory. If something is not valid, the user will get an email from the system detailing what line produced the error and which column was at fault. Please allow up to 30 minutes for file to process. An email will be sent to the sender after the file has been successfully completed.
|
Column |
Description |
Validation |
|
A |
Client Code |
Mandatory |
|
B |
Invoice Number |
Mandatory |
|
C |
Part number |
Mandatory |
|
D |
Part Description |
Mandatory |
|
E |
Qty |
Mandatory |
|
F |
Line Amount |
Mandatory |
|
G |
Country |
Optional |
|
H |
Preference |
Optional |
|
I |
Order Number |
Optional |
|
J |
Shipment Ref |
Optional |
|
K |
Currency |
Optional |