Your Tailored Stocktake Steps

Here are your answers to the Interactive Stocktake Helper. If you want to change any of the answers, you can start the Interactive Stocktake Helper again.

When do you want to do the stocktake? After Hours
What do you want to count? Department
Are your Committed quantities accurate? No/Unsure
How will you count the stock? Manually

Committed quantities are first reset to zero and recounted (manually) to ensure accuracy. A stocktake file is then created in Fred Office Plus The stock is counted manually and figures updated in Fred Office Plus. Once the count is complete, the file must be protected, reviewed and committed.

The option used to create this stocktake file sets 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.

Overview of Your Tailored Stocktake Steps

  1. Update Committed Quantities.

  2. Create stocktake file (Set stock on hand to point stock count was performed) in Fred Office Plus.

  3. Count stock (Manual) and enter into Fred Office Plus.

  4. Review Discrepancies, Protect and commit the stocktake

Update Committed Quantities

  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.

Create the stocktake file for the stocktake

1. Tap Assistants, then Stocktake.

2. Tap New, then enter a name and description for your stocktake.

3. 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.

4. Tap OK.

1. Tap Add Items.

2. Do one of the following:

Action

Description

Add Item Group

  1. Tap the drop down next to Search.

  2. Tap Search by Group.

  3. In Search Criteria, set the relevant Item Group, then tap Search.

  4. Tap to add all items to the Selected list.

  5. Tap OK.

Add Supplier

  1. Tap the drop down next to Search.

  2. Tap Search by Supplier.

  3. In Search Criteria, select the relevant Supplier.

  4. Tap Search.

  5. Tap to add all items to the Selected list.

  6. Tap OK.

Add Department

  1. Tap the drop down next to Search.

  2. Tap Search by Department.

  3. In Search Criteria, select the relevant Department, then Category if required.

  4. Tap Search.

  5. Tap to add all items to the Selected list.

  6. Tap OK.

Add Individual Item(s)

  1. Enter an Alias, Code or Description and tap Search.

  2. Highlight the item(s) you want to add and tap  to move the item(s) to Selected.

  3. Alternatively, tap to move all items returned in the search to Selected.

  4. Repeat the search and selections until all items required have been moved to Selected.

  5. Once complete, tap OK.

Add Ad Hoc items

(This option is only recommended when using Fred Mobility to count the stock)

Examples:

  • Stocktake a section of the store where it is mixed departments,

  • Stocktake by shelves/location (not already defined in a group)

  1. Press Cancel to return to the stocktake screen

  2. No items will be preloaded into the stocktake

  3. Continue with procedure to Count the Stock (items will appear within the stocktake file as the stock is counted)

 

The CTRL and SHIFT keys can be used to select only some of the items from the group. Use to add only the selected or highlighted items to Selected.

  1. Tap Print Stocktake, then File.

  2. Tap Print to print a List of all items in your store.

  3. When done, tap File, then Exit.

  4. Tap Save and Close to close the stocktake file.

If you would like to do smaller sections at a time, you can filter the stocktake file by Department prior to printing the stocktake . Then, click on the Description column heading to sort alphabetically.

Count the stock (Manual)

  1. Count your stock based off the items added to your stocktake, writing the quantities on the stock take list previously printed

    Ensure all orders have been received in prior to commencing your stocktake count. Your count must include all stock in the store including stock on shelves and any committed stock awaiting collection.

  1. Tap Assistants, then Stocktake.

  2. Right-click to open the Stocktake file.

  3. Tap on the column headers (e.g Department, Description) if required to sort the list of items to be the same as the printed list.

    Alternatively, tap on Search Bar. Use the search fields to find items.

  4. Tap into the Counted field and type the quantity counted for the item.

  5. Press the down arrow on the keyboard to move to the next line or search for the next item.

  6. Continue until all quantities counted have been entered.

  7. Press Save and Close.

Review Discrepancies, Protect and commit the stocktake

  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.