Invoices can be sent to the Debtor as a CSV file which can be uploaded into the Debtor’s system. Set the Debtor to receive invoices by EDI in the Administration > Customer Masterfile Debtor tab. The toolbar button 
will then appear in the Debtors > Invoice screen and from the Job Invoice screen as a toolbar button. Select this button to generate the CSV file and email to selected email addresses.
The CSV file generated will be in the following format
The CSV file will include the Field Name headings in the first row of the CSV
|
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 |