Wasp Barcode Inventory Control - Manual (Page 283)

InventoryControl Printable Help
 If you will be importing data into both the Manufacturer table and the Item table:
The same values that reside within the Import Data Columns you choose to map to the
Manufacturer table's Name field must also occur within the Import Data Columns you choose to
map to the Item table's Manufacturer field. The actual Import file used for the Manufacturer import
does not have to be used for the Item import. It's the Name and Manufacturer values themselves
which must be the same in both Imports to create the proper connections between the
Manufacturer and Item tables.
If, while importing Item data, a previously unknown Manufacturer value is read, a new
Manufacturer will be created using the new value; the Item record being imported will not be
associated with an existing Manufacturer.
 If you will be importing data into both the Item table and the Inventory table:
The same values that reside within the Import Data Columns you choose to map to the Item table's
Item Number's field must also occur within the Import Data Columns you choose to map to the
Inventory table's Item Number field. The actual Import file used for the Item import does not have
to be used for the Inventory import. It's the Item Number values themselves which must be the
same in both Imports to create the proper connections between the Item and Inventory tables.
If, while importing Inventory data, a previously unknown value for either Item Number, Site,
Location, or Supplier Code is read, a new Item Number, Site, Location or Supplier Code will not
be created using the new value; the Inventory record being imported will be rejected. Negative
values for Quantity can also cause an Inventory record to be rejected. Lastly, if one or more
Tracked By or Require the user to fill out options are enabled for the Item Number specified in an
Inventory record that fails to supply that information, the record will be rejected. These errors will
be listed in the
Import-Export Error Report .
These same relationships apply when using Create New Location , Create New Supplier , Create New
Manufacturer , Create New Item or Add Inventory .
The Customer table's fields are not related to fields within any of the other tables.
268