With this import process, so-called spend link exceptions can be imported in Admin > Spend settings > Data bundling > Connect Vendor/Cost Type/Commodity.
When you use the import process 'Admin - Import Spend - Vendor/Cost type/Category', you need to upload a file containing information about vendors, cost types and categories. Based on this information, links will be made in Admin > Spend settings > Data bundling > Connect Vendor/Cost Type/Commodity. To do this, use the template that you can download in step 2 of the import process.
Below you can see an example of part of a correctly filled import file:
The supplied supplier/cost type/category links will be added to the overview in Admin > Spend settings > Data bundling > Connect Vendor/Cost Type/Commodity.
All columns from the import template are explained below. If the import file does not meet these requirements, the import will fail.
Column | Explanation | Requirements | Mandatory |
CostType | The name of the cost type. | The name of an existing cost element in Admin > Tables > Cost Types. | Yes |
VendorRef | The reference of the vendor. | A reference number of an existing vendor in Spend. | Yes |
CategoryCode | The reference of the category. | A reference number of an existing category in Admin > Tables > Commodities. | Yes |