Inventory Stocktake Import
Step 1: Download our inventory stocktake template file or Export to modify existing stocktakes
Start by downloading our inventory stocktake XLSX (Microsoft Excel Spreadsheet) template file. This file gives you a good base to start with that you can modify to fit your requirements.
Step 2: Modify the template
Using Excel or another spreadsheet editor, modifying the BUZ template to fit your requirements.
Step 3: Upload an excel document
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.
| Field | Details |
|---|---|
| PKID | |
| Inventory Code* | |
| Description | |
| Date | |
| Stock Take Ref No | |
| Qty Count | |
| Qty Weight | |
| Qty Stock Take | |
| Unit Cost | |
| Location Code | |
| Operation |