Completing a stocktake by using the csv download option
Introduction
There is a client option which enables you to download your stock location, complete your stocktake in the csv file and then upload it. This means you don't need to be online when adding the data into the excel template.
There is a separate offline option for clients who want to want to fill in their stocktake in an offline mode but directly in the application, not into the csv.Â
Please speak to IndiCater or your IndiCater gatekeeper if you are interested in either of these options and don't have them activated.
Assumptions
The client is using detailed stocktaking
Where to find this
Within an outlet, click StORM > Stocktakes
Step-by-step guide
- Â In the correct week, click Add to add a Detailed Stocktake
- Select the correct Department, Stock Location and date within the chosen week
- Click Download. This will create a zero value 'placeholder' stocktake which will be updated once your completed template has been uploaded.
- Open the excel template. It may be necessary to click Enable Editing.
- Note that the only fields that can be edited are the Case, Pack/Sleeve and Individual columns, the same as if you were doing it online.
- Once you have added in the quantities, save your document. Please save it as type Excel Workbook
- In IndiCater click upload and select your saved document.
- Click OK in the pop up box to confirm
- Your stocktake will appear as normal in the list of Detailed Stocktakes
- To amend it, click on the date and then Update and you will see the stocktake in the normal format on the screen.