Your Tailored Stocktake Steps

1. Tap Assistants, then Stocktake.

2. Tap New and Enter a name and description for your stocktake.

3. Tap Full store stocktake.

   This ensures any item not counted will have their SOH figure reset to zero when the stocktake file is committed.

4. Tap Set stock on hand to point stock count was performed.

   This option changes the quantity in the system to the quantity counted. This change is applied at the time the stocktake file is committed. For this reason, this entire process must be completed after hours (including committing the stocktake file).

   This option does not take into account any sales of stock or orders received, therefore this option is only recommended for an after hours stocktake.

5. Tap OK.

6. Tap Save and Close.

1. Tap Tools, then Item, then Stocktake Export.

   You may need to wait for the values of the Total Items to be Exported to be calculated.

2. Tap Export, then select the location to save the Export File.

   If unsure, save the file to the Desktop.

3. Enter a File Name and adjust the file type (if required).

   CSV file type is usually recommended.

4. Tap Save, wait for the confirmation prompt, then press OK (twice).

   Prior to commencing your stocktake you must ensure all stock has been received into your store. Your external provider must include all stock in your shop including stock on shelves and any committed stock awaiting collection.

1. Tap Assistants, then Stocktake.

2. Right-click to open the Stocktake file previously created.

3. Tap on the drop-down arrow next to Add Items, then select Data Import Wizard.

   

4. At the Welcome screen (if shown), tap Next.

5. Tap Browse and locate the saved stocktake file (provided by your external stocktake provider), then tap Open.

6. The selected file is displayed in the list of Available Work Sheet.

   

7. Tap Next and select Let me map columns manually.

8. Tap Next.

9. Match the columns required (top grid) with the columns in your spreadsheet (lower grid).

   Tap and hold a field from the Column section and drag and drop to the appropriate column in your spreadsheet data preview.

   The field name will update in the column heading.

10. Repeat the above step until all appropriate fields are matched.

    It is recommended to include Description, Stock Count, Count Date and Code/ Alias as a minimum.

11. If the first row of the spreadsheet contains column header descriptions and not stocktake data, ensure First row in the file is the column header is selected.

    

12. Once complete, tap Next.

13. If the file you imported is typical of the format you would use in future, tap Check this box to allow saving of this template and type a template name.

14. Tap Finish.

    Fred Office Plus now attempts to match all items in the file to items in your database based on the fields you matched.

    • Items that can be matched are displayed in the Ready tab.

    • Items that cannot be automatically matched are displayed in the Imported tab, to allow you to match them.

1. Do one or all of the following:

   Action	Description
   Attempt to match spreadsheet Code field to Item Codes in your Database.	Set Match this key to Code and Against this field to Code. Tap Match, then OK. Items from your import file now matched to items in your database will display a tick in the first column of the Imported tab. Tap Validate. This will move any matched items to the Ready tab. Change the selection for Against this field to Alias. Tap Match, then OK. Tap Validate.
   Attempt to match spreadsheet Code field to Reorder Numbers in your Database.	Set Match this key to Code and Against this field to Reorder Number. Select your primary supplier using the pull down. Tap Match, then OK. Tap Validate. Repeat this step for all suppliers where the Code field from the spreadsheet may correspond to the reorder number of a different supplier in your database
   Directly match spreadsheet item to an item in your Database by searching.	Select the item you want to manually match to an item in your database. Tap Find under Issues. Enter the item Alias, Code or Description to search. Tap Search. Select the item from the search results. Tap the forward arrow to move the item to Selected. If the wrong item is selected, tap the back arrow to move it out of Selected. Tap OK (twice). Repeat the above steps for all items remaining on the imported tab.
   Resolve red fields.	This applies to all items where information in the spreadsheet was missing or invalid (wrong format). These items appear with a grid cross icon. Tap in the red field(s) displayed and type the correct value. Repeat for all items with red fields. Tap Validate.
   Remove rows or items.	Select the item you want to remove. Tap Delete.

2. Press Save and Close.

   

1. Tap Assistants, then Stocktake.

2. Right-click to open the Stocktake file.

3. Review discrepancies:

   • The Counted column is what was actually counted in your store.

   • The SOH When Counted field is the item’s SOH figure in Fred Office Plus when the item was counted.

   To assist you to review these figures, set the options Hide items with no differences and Use colour coding. This is found under the Count Method drop down on the stocktake form.

4. If any counted figures are suspected to be incorrect, re-count and edit counted quantities if required.

   

1. Tap Protect to prevent any further changes being made to the stock take file.

2. Tap Calculate. The Data Assistant Stock Take Discrepancy window appears and will show the final outcomes from the stock take count.

If you are not ready to commit your Stocktake (this cannot be undone), tap Cancel, then Unprotect to return to the main Stocktake screen and edit quantities.

1. Tap Commit.

2. Tap Yes to commit.

   This cannot be undone.

   The Current Count quantity will be set as the item’s new SOH quantity.