The following shows what data must / can be delivered to Acubiz via automatic maintenance.

Minimum requirements for supplier data

The files must contain at least the following information:

1. Unique vendor key (CVR/VAT number)
   Used to decide if it is a new vendor or one that needs to be updated. The CVR number must always have the country code preceded by eg DK12345678.
2. Supplier name
3. Country code
4. CVR/VAT number (same as #1)
5. Vendor number in the ERP system.
6. Account type in ERP
   Normally "k" = Vendor

Example of basic vendordata:

The file for Acubiz should not contain header lines - only user data:
Example of file content

DK12345678;Pedersens Handelsfirma ApS;DK;DK12345678;12345678;k
DK22222222;Tømrefirmaet ApS;DK;DK22222222;22222222;k
DK55667788;Sandvig Taxaselskab A/S;DK;DK55667788;55667788;k
DK78544444;Vekselerfirmaet Mønt;DK;DK78544444;78544444;k

Extension with requester and approver

It is also possible to indicate in the data who is resp. requester and approver.

1. Unique vendor key (CVR/VAT number)
   Used to decide if it is a new vendor or one that needs to be updated. The CVR number must always have the country code preceded by eg DK12345678.
2. Supplier name
3. Country code
4. CVR/VAT number (same as #1)
5. Vendor number in the ERP system.
6. Account type in ERP
   Normally "k" = Vendor
7. Requester
   Initials from user master data on the requester are specified here
8. Approver
   Initials from user master data on the approver are specified here

Example of extended vendordata:

The file for Acubiz should not contain header lines - only user data:
Example of file content

DK12345678;Pedersens Handelsfirma ApS;DK;DK12345678;12345678;k;dk;approver
DK22222222;Tømrefirmaet ApS;DK;DK22222222;22222222;k;dk;approver
DK55667788;Sandvig Taxaselskab A/S;DK;DK55667788;55667788;k;finance;approver
DK78544444;Vekselerfirmaet Mønt;DK;DK78544444;78544444;k;finance;approver