Robot Stocktake - After Hours – Knowledge base

Fred Office Plus

Follow the steps below to carry out a robot stocktake after business hours.

From the File menu, select Save as and give the file a new name.
Example: Stocktake-2023-05-01-Modified.xls
This is a copy of the original file.
From the File menu, select Save as and change the file type to a .CSV file. This will ensure it is in the correct format for importing.
Example: Stocktake-2023-05-01-Import.csv

In Fred Office Plus, go to Assistants, then Stocktake, then click New.
Enter a name for the stocktake and select Adjust stock on hand by difference when stock count was performed, then click OK.
Example: ROBOT Stocktake 2023.05.01
Go to Add items, then select Data Import Templates, and select the saved template.
If you see No Valid Template Found, refer to the Create or Edit a Template section below.
Select the location and then click OK.

Click Data Import Wizard.
Click Browse.
Navigate to the location of the file you want to import.
Double-click the file to be imported.
If your file does not display, you may need to click the dropdown and select a different file type.
Click Next.
Select one of the following options and then follow the relevant steps below:
- Load Saved Template - to edit an existing template
- Let me map columns manually - to create a new template

Click Load Saved Template. If you don't have a template, click Let me map columns.
Select Template from the dropdown.
Click Next.
Confirm that the column headers match the data displayed.
If you need to manually match columns, click and hold your mouse on a field from the Column section at the top of the screen. While still holding, move your mouse onto the header line of the column with the relative information in your data preview displayed below. When your mouse is over the correct column heading, release the mouse button. This will slot the column heading into the correct position.
After you have confirmed the column headers match the data, click Next.

Click Let me map columns manually, then click Next.
In the Column section at the top of the screen, click and drag a field into the bottom section.
When your mouse is over the correct column heading, release the mouse button. The column heading slots into the correct position.
Repeat steps 2 to 3 until you have mapped all the required columns in the worksheet.
Select the First row in the file is the column header checkbox, then click Next.
If required, select Check this box to allow saving of this template and click Finish.
The Excel file will now load into Fred Office Plus.

Fix any imported items that have been unable to match using the barcode using the table below.
Ensure the Imported tab no longer exists before moving onto the next step.
You can resolve the unmatched items using one or more of the following:
- Delete the unmatched line.
- Use matching method.
- Use the Find button to manually find the matches using description.

The table gives you some tips for each option.

Action	Description
Attempt to match spreadsheet Alias field to Alias in your database.	Attempt to match spreadsheet Alias field to Alias in your database. Set Against this field to Alias. Tap Match, then OK. Tap Validate. This will move any matched items to the Ready tab.
Attempt to match spreadsheet Reorder Number field to Reorder Numbers in your database.	Set Against this field to Reorder Number. Select your primary supplier from the dropdown. Tap Match, then OK. Tap Validate. This will move any matched items to the Ready tab.
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 on. 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. 1. Tap in the red field(s) displayed and type the correct value. 2. Repeat for all items with red fields. 3. Tap Validate.
Remove rows or items.	1. Select the item you want to remove. 2. Tap Delete.

Key points to check for:

Check for items in both Robot and OTC/Shop Floor. Either remove or manually check the SOH of the 2nd location therefore ensuring correct figures.
Check for large changes between Counted and SOH when Counted.
Check for items with SOH when counted as negative. (This may already be on order or special orders - awaiting on stock).

To update and finalise SOH figures: