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:
- 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. - Supplier name
- Country code
- CVR/VAT number (same as #1)
- Vendor number in the ERP system.
- 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.
- 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. - Supplier name
- Country code
- CVR/VAT number (same as #1)
- Vendor number in the ERP system.
- Account type in ERP
Normally "k" = Vendor - Requester
Initials from user master data on the requester are specified here - 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
Comments
0 comments
Please sign in to leave a comment.