When your Spend data import fails, one of the problems below is often the cause.
If the separator you specify in the wizard does not match the separator in the supplied data, the data import will fail.
Seperator is used in data
If the separator occurs in the data (for example, in a supplier's name) then the import can not be carried out properly. It is important to remove these separators from the data fields. The separator must be a unique character that has no other function in the import file.
Incorrect date format
The data import will fail when another date format is supplied in date fields than expected, for example MM-DD-YYYY instead of DD-MM-YYYY. Standard expects VendorLink DD-MM-YYYY (31-12-2018) unless otherwise arranged.
Duplicate supplier names and/or invoice numbers
Ensure that the import file takes into account the following points:
- Are the Vendor Reference (VendorName) and VendorName (VendorName) combinations unique?
- Are the combinations Vendor Reference (VendorReference) and invoice number (Invoicenumber) unique?
When processing the data, VendorLink establishes a relationship between the supplier number and the invoice number (Invoicenumber). If the above combination is not unique, a wrong name may be retrieved and displayed when retrieving the name of the supplier.