Content Comparison

...

For items that are made up of Material, Material Type and Colour the Code and Description are automatically created using a concatenation of the their descriptions and the column headings get have an * (astrix) on the end to indicate this, if it is desired to not use the default then remove the * from the heading.

                                                                                                               Example Inventory Items Import file = 20180912.1553_InventoryItems_BUZ_demo.xlsm

                                                                                                                    Image Added

Step 3: Upload an excel document

...

Step 4: Confirm import

...

Import Error Messages

To see a list of items and save click arrow on left the . The Save button is at the bottom left of list.

Each Group has to be saved individually, there is no Save All option.

Image Added

Import Error Messages

If there are errors in the imported data there is a separate error section below the valid data section and the Save button will be disabled.Each Group has to be saved individually, there is no Save All option. To see a list of items and save click arrow on left.

Duplicate PKID error

This happens when the Inventory Item is already loaded to BUZ and has a PKID

Image Added

Explanation of Inventory item spreadsheet

...