Wasp Barcode Inventory Control - Manual (Page 277)

InventoryControl Printable Help
16.1.5 Notes on Importing Inventory:
The steps for importing inventory are the same as those listed above; however, there is some important
information to be aware of when you are importing inventory:
 Importing data into the Inventory table is optional. It is equivalent to manually adding inventory at
the PC. Quantity and Location data, imported along with an Item Number, increases Item
quantities in the database. You cannot remove inventory by importing negative quantities.
 The value specified in the Select Site screen/From Site field can impact the Locations into which
imported Inventory information will be recorded. When something other than <all> is specified as
your From site, imported inventory will be put into Locations at the specified From Site. If you
have varying Site information you wish to import along with the Location and Quantity data for
each Item Number, you must make sure the From Site is set to <all> in Select Site before
importing data into the Inventory table. For further information on the Select Site screen, please
see the
Select Site topic.
 Item Number, Quantity, Site and Location are all required fields for Importing into the Inventory
table. 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. Instead, the Inventory record being imported will be
rejected. Negative values for Quantity can also cause an Inventory record to be rejected.
 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.
For more information on these options, please refer to the
Create New Item topic.
262