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).
Related Articles
How to do a stock take
Guidance on the Inventory Count / Stock Take procedure. (Guide for Pastel Partner 14, but older versions will loosely follow the same method). The inventory count is a process where you would do a physical stock count and compare them to the quantity ...Error Code 161 - Pervasive User Count License Exceeded
Error Code 161: Pervasive License Exceeded. This error code means you have reached your user limit on the license and an extra user is trying to log in (Example, you have a 5 user limit, 5 users are currently logged in - meaning the 6th user to try ...Quantity on SO or PO is incorrect
Guidance on correcting your 'On Sales Order' and 'On Purchase Order' quantities. (Guide for Pastel Partner 14, but older versions will loosely follow the same method). Occasionally, you may find your stock levels for Sales Orders and Purchase Orders ...Importing General Ledger / Cashbook Batches
Guide on the import specifications, to import a Journal Batch or a Cashbook Batch (Guide for Pastel Partner 14, but older versions will loosely follow the same method) Attached at the bottom of the page is a template, which you can edit the relevant ...Discrepancies between Inventory Control Account and Inventory Valuation
Discrepancies between Inventory Control Account and Inventory Valuation Differences between the Inventory Control Account and the Inventory Valuation Report will be the result of the following: Inventory being integrated into the General Ledger. ...