AssetsParts

General
Location Specific 
In the database of MXSuite there is one list with all parts. For each part is the visibility of a location selected. If you want that all parts in the Excel file are visible for all locations, run the import of the Excel file at the office for each location. 
In the table, fields which marked as location specific means that it could be that the content is different per location. The content of all the other fields is for every location the same. 
Import match 
When importing an Excel file, it is possible to let the new Excel file update the existing inventory. If the OWNCODE matches an existing item in the inventory, the details of the existing item are overwritten by the details mentioned in the Excel file.
Field
MAX Characters
 Required
Comment
Description
1024
X
PartNumber
128
X
Owncode
50
X
The owncode is a unique field, and this number will be used to update the part with the same owncode or import the part if the owncode is not known for the entire fleet.
CostCode
50
X
Unit
128
X
The unit name should exactly match the name of the Unit (table). 
IsCritical
True or False If nothing filled: value is “False” 
IsOperationalCritical
True or False If nothing filled: value is “False”  
ActualStock
 
Number If field is blank, the stock is 0. 
MinStock
128
Number
MaxStock
128
Number
Manufacturer
128
The name of Manufacturer
PrefferedSupplier
CatalogNo
128
Storage
256
Box
256
Barcode
256
Size
256
DrawingNumber
256
PosNo
128
ShipDrawingNo
128
ShipPosNo
128
ProductCategory
128
Lookup to the product categories as defined in the tab Administration. This should exactly match the name of the product category. 
Material
128
Standard
128
HSCode
Country
Comments
HazMatDoc