Import your stock count quantities

Details about the file requirements to import during the stock take / inventory count process.

(Guide for Pastel Partner 14, but older versions will loosely follow the same method).

Instead of manually counting and entering physical quantities on hand for the inventory count, you may have equipment into which you can scan quantities on hand, and from which you can then export these into an ASCII comma delimited file. If this is the case, you can import them directly into the inventory count function.

There are different layouts for this file depending on the add-on modules you are using.

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

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

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 is a line per inventory item. For serialised items, set the quantity to 1. For non-serialised items, leave the serial number blank, e.g.:

Itemcode,JHB,23,

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 is a line per inventory item. For serialised items, set the quantity to 1. For non-serialised items, leave the serial number blank, e.g.:

Itemcode,23,

When you have the file completed, save it as a .TXT file (ASCII comma delimited).