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 |