<< Click to Display Table of Contents >> Navigation:  System Manager > Data Import > Import Parameters > Inventory On-hand Quantity

 

To successfully import on-hand quantities for selected inventory items, take note of the following general conditions when creating your import source file:

 

•There can be any number of entries in the source file, one following immediately after the other.

 

•The first line in the source file is not imported. Be sure to enter the first entry after the first line.

 

•You must enter the data field's name in the first line as a column heading. The data import is case-sensitive so be sure that each column name is spelled correctly and that it matches with the actual data field's name.

 

•Each line in your source file after the first line will be treated as a separate record.

 

Additionally, take note of these conditions:

 

•If an inventory item in a certain warehouse has a balance (i.e., on-hand quantity) or transactions, you can no longer import the bin on-hand quantity into the Inventory Bin file for that inventory item in that same warehouse.

 

•You cannot import Unit Cost information for inventory items with balances (e.g., on-hand quantity) or transactions for the warehouse specified in the source file.

 

There are certain validations that the data import feature performs which differs depending on the import function selected. Validation checks are in place to ensure that data to be entered into the system are acceptable. Below are the data-specific requirements you need to successfully import inventory item on-hand quantities:

 

 

 

Required Module: Accounts Receivable (AR), Sales Order (SO), Purchase Order (PO), or Inventory Control (IC)

 

Required Import Field(s):

•ItemCode

•WarehouseCode

•BinCode

 

 

 

 

 

Illustration:

 

The following example shows you how to format the source file properly to successfully import inventory on-hand records. The sample import template below shows you the following:

 

•It is for importing nineteen (19) different inventory on-hand records.

•It includes the required fields ItemCode, WarehouseCode, and BinCode, respectively.

•It also contains values for the the selected data fields to be included in the data import. You have the option to include all data fields in your source file or to select only a few fields. For those non-required fields that you opt not to include in the source file, the system will auto-populate it with the default values.

 

 

 

 

 

 

 

© 2023 AccountMate Software Corporation