Invoices can be sent to the Debtor as a CSV file which can be uploaded into the Debtor’s systems. Set the Debtor to receive invoices by EDI in the Customer Masterfile Debtor tab. The toolbar button Send EDI Invoice will then appear. Select this button to generate the CSV file and email to selected email addresses.
The CSV file generated will be in the following format
|
Seq. |
Field Name |
Type |
Length |
Sample Data |
Business Rules |
|
1 |
EDICode |
char |
50 |
MILLMAN |
Client Code in Expedient |
|
2 |
InvoiceNo |
char |
20 |
123456789 |
Invoice Number |
|
3 |
InvDate |
Date |
|
3/02/2012 |
Date of Invoice |
|
4 |
BillNumber |
char |
20 |
987654321 |
Master Air Way Bill Number, Ocean Bill Number or House Bill Number |
|
5 |
Currency |
char |
3 |
AUD |
Invoice Currency |
|
6 |
TtInvAIGST |
decimal |
12,2 |
123.45 |
Total value of the invoice including GST |
|
7 |
TtInvAEGST |
decimal |
12,2 |
123.45 |
Total value of the invoice excluding GST. |
|
8 |
TtInvGST |
decimal |
12,2 |
111.00 |
Total value of the GST on the invoice. |
|
9 |
JobNumber |
char |
10 |
1234567890 |
Expedient Job Number |
|
10 |
CostCode |
char |
100 |
FREIGHT |
Expedient Cost Code. |
|
11 |
CCAExcGST |
decimal |
12,2 |
123.45 |
Cost Code Amount excluding GST |
|
12 |
CCGSTInd |
char |
1 |
Y or N |
Indicates whether GST is applied to the Cost Code – (Y)es or (N)o |
|
13 |
Custref |
Char |
25 |
978654321 |
Customer Ref from the Import Job Registration screen, or Shipper Ref from the Export Job Registration screen |
The CSV file will include the Field Name headings in the first row of the CSV
Sample Invoice
The above invoice will generate a CSV as shown below.
EDICode,InvoiceNo,InvDate,BillNumber,Currency,TtInvAIGST,TtInvAEGST,TtInvGST,JobNumber,CostCode,CCAExcGST,CCGSTInd,Custref
DEMCON,185567,21/11/2012,NJU7541,AUD,100,100,0,3002155,AE,100,N,987654321