...
Step 4: Import the updated template file
Here are the list of worksheets that available to be imported :
Note: Please select maximum 4 Sheets at a time.
Export to Modify Existing Stocktake
Once your stock is added for the first time it is just a matter of editing the stock when completing a stock take.
- Export This sheet under "Stocktake Template File"
- Select the Inventory group you wish to record stock for
View Previous Stocktakes
Once your stock is added you can view your previous stocktakes.
Export this sheet under "Previous Stocktakes"
Exported Field Descriptions
| Field | Details |
|---|---|
| PKID | Primary Unique Identifier for the row in the database so this should not be changed or deleted (system generated) |
| Inventory Code* | Inventory Code (system generated) |
| Description | Inventory Description (system generated) |
| Date | Last Edited Date |
| Time | Time of Stocktake count |
| Stocktake Ref No | Reference No (E.g Stocktake 1, or Month and YearAn integer) |
| Qty Count | Stocktake count in QTY |
| Qty Weight | QTY in weight |
| Qty Stocktake | Current Stock Level |
| Unit Cost | Last Purchase Price @ Average cost method |
| Location Code | Where this item was located in warehouse |
| Operation | The Operation should be Blank, A(Add item), E(Edit item) or D(Set item Inactive). |