When processing a stock take/count inventory, you can import the quantities instead of manually entering them.

It is important to ensure that you have the correct import layout. 

The layouts are based on the modules that affect the inventory that you’ve installed.

To import quantities into the inventory count

1. Prepare your text file according to the file layout the system requires. There are different layouts for this file depending on the add-on modules you’re using. 
    TIP: Click the applicable layout for more details
   
   
   ▼No Multi-Store, No Serial Number Tracking

   ▼No Multi-Store, No Serial Number Tracking

   Ref.	Field	Type	Format	Excel Ref.
   1	Item Code	Character	15 characters maximum	A
   2	Quantity	Numeric	9.4 maximum	B

    

   Example:

   

   ▼Multi-Store, No Serial Number Tracking

   Multi-Store, No Serial Number Tracking

   Ref.	Field	Type	Format	Excel Ref.
   1	Item Code	Character	15 characters maximum	A
   2	Store Code	Character	3 characters maximum	B
   3	Quantity	Numeric	9.4 maximum	C

    

   Example:

   

   ▼Multi-Store, Serial Number Tracking

   Multi-Store, Serial Number Tracking

   Ref.	Field	Type	Format	Excel Ref.
   1	Item Code	Character	15 characters maximum	A
   2	Store Code	Character	3 characters maximum	B
   3	Quantity	Numeric	9.4 maximum	C
   4	Serial Number	Character	30 characters maximum	D

   There’s a line per inventory item. For serialised items, set the quantity to 1. 

   Example:

   

   Total quantity for JHB = 9

   For non-serialised items, leave the serial number blank.

   Example:

   

   ▼No Multi-Store, Serial Number Tracking

   No Multi-Store, Serial Number Tracking

   Ref.	Field	Type	Format	Excel Ref.
   1	Item Code	Character	15 characters maximum	A
   2	Quantity	Numeric	9.4 maximum	B
   3	Serial Number	Character	30 characters maximum	C

   There’s a line per inventory item.  For serialised items, set the quantity to 1. 

   Example:

   

   Total quantity for JHB = 9

   For non-serialised items, leave the serial number blank.

   Example:

   

2. From the Choose Operation screen, choose the option to import a text file and click the Next button.
3. The Import Quantities from Text File screen displays:
   
   Choose a quantity method:
   1. If the import file has one line per inventory item, choose the option to replace existing quantities.
   2. If the import file has more than one line per inventory item, choose the option to add quantities to the existing ones.
4. Choose whether the item code in the import file is in the item code field or the barcode field on the inventory file. Usually, electronic readers use the barcode field.
5. Enter the name of the file to import. You can click the Browse button to select the file. Click the Next button to continue.
6. The Confirm Operation screen displays. Click the Process button to perform the operation, or click the Cancel button to leave the function without processing.
7. If there are errors in the input file, the system displays these, and you can print them. If there are errors, no imports occur, even for lines that aren’t in error. Correct the errors in the input file, and then re-import the whole file.