Skip to main content

General info

Import field relations with general data

If you filled in the following columns in the Excel file: 

  • Budgetcodes 
  • Currencies
  • Product categories
  • Units
  • Ranks

Then this data must exist in the Administration module

All fields in the Excel file must be in text format.
For example, if there is a problem after importing inventory with the PartNumber (column C) change the format of this column (Right mouse click on this column, select Format Cells) to category General 

Excel field format.jpg

Do not change the top row of the Excel file! If this is changed, the import will fail