Your Tailored Stocktake Steps

1. Tap Reporting.
2. Set Inventory Reports to Committed Stock Report.
3. Tap Open Report and clear the option Only show items with stock. 
4. Tap Run Report.

1. Tap, hold and drag Department into the column heading.

2. Tap Item Description column heading to sort alphabetically.

3. Tap Print Preview.

4. Tap File, then Print.

5. Tap Print.

   The list of all items with committed quantities is printed.

6. Tap File, then Exit.

   Use the printed list to check committed quantities accuracy against what is actually awaiting collection in your store.

1. Right click on the grey bar above the column headers and select Full Expand.

2. Tap the first item line of the report to focus on the results displayed.

3. Press CTRL + A on the keyboard to select all items on the report.

   The CTRL and SHIFT keys while tapping can be used to select only those items you want to set to zero instead.

4. Right-click and select Item Quick Action.

5. If the Welcome screen appears, tap Next.

6. Tap to expand the Inventory tree. 

7. Tap Set or Adjust the Committed Quantity, then Next.

8. Leave the options set as shown on the Configure Actions step, then tap Next.

9. Tap Confirm to apply these changes, then tap Next.

10. Tap Finish.

1. Tap Inventory.

2. Tap Items.

3. Search for and open the item of interest.

4. Type the actual Committed quantity.

5. Tap Save and Close.

6. Repeat for all items on the report (as appropriate) as well as items not on the report that do have a committed quantity figure.

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. Ensure Adjust stock on hand by difference when stock count was performed is selected.

   This option ensures that changes to the item since the count (such as sales or receipt of stock) are taken into account when the stock take is calculated.

   For instance, the system reports I have 5 in the store (SOH figure), but I count 8 (a difference of +3). I then sell 1 of this item before I commit my stocktake. This means my SOH figure in Fred Office Plus is currently 4. When I commit my stocktake, the SOH will adjust by the difference of +3, changing the SOH figure to 7.

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.

   • The Difference is what the SOH figure will be adjusted by when this stocktake file is Committed.

   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. It is the difference between the Counted column and the SOH When Counted column.

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 SOH is adjusted by the Difference.