This release provides the ability to load a CSV of a Creditor’s Statement and perform a comparison of the Statement details against Invoices for the Creditor stored in Expedient.
A new option has been added in Creditors > EDI Creditors – EDI Creditors Statement. If you cannot see this menu option please contact Expedient by raising a Support Ticket.
Find your Creditor in this screen. The Creditor must be flagged to send Creditors Statement EDI to you in the Creditor tab of the Administration > Customer Masterfile screen.
Use the Load File button to locate the file and load it. The file must be in CSV and must contain the following columns with no column headings
|
Column |
Details |
Comments |
|
A |
Creditor Code |
Mandatory |
|
B |
Reference |
Optional. Reference on Invoice |
|
C |
Invoice Number |
Mandatory |
|
D |
Invoice Date |
Mandatory. Format DD/MM/YYYY or DD/MM/YY or DDMMYY or DDMMYYYY |
|
E |
Invoice Amount |
Mandatory. Amounts are inclusive of GST |
|
F |
Invoice Currency |
If left blank Expedient will assume your site currency is the currency for the invoice, e.g. in NZ the assumed currency will be NZD |
|
G |
Invoice Balance |
Mandatory. Amount outstanding for the invoice which will indicate part payment. Amounts are inclusive of GST |
Expedient will check all the mandatory information is in the file and load the lines from the statement that pass checks. Expedient will show a message to inform you of any lines that do not pass checks so these can be corrected before loading.
Once loaded use the Comparison Reports toolbar button to check the details of the statement against the invoices stored in Expedient for the Creditor. Expedient can highlight any discrepancies. These are all CSV reports
Sample output (Report Type: All Data)
