External stocktake

The Full product list report can be used. This report includes all products, not just store assortments.

1. From FredNXT Head Office, navigate to Reports > Full product list.
2. On the Full product list, click the Barcode heading to sort the column and display the list without a barcode at the top of this list.

   Alternatively, export the list to a spreadsheet and sort the list as explained above.

   

3. To add the missing barcodes using DIEF, refer to Add barcodes to a product (DIEF)

   You can also add the barcode manually from the Release product sections.

   In order to add the missing barcodes, go to AppCAT or the various Supplier Portals, then copy and paste the barcode into the DIEF spreadsheet.

1. In Release products, select all products and click Validate.

   

   This option is used to locate any missing product configuration, such as Model group or Dimension group.

   The validation process will take on average 15 to 20 mins to run. It may run for 20 mins to process 30,000 products.

   Products with missing data display in the Infolog.

   

2. In Release products, update the following product information:
   • Manage cost fast tab > Item group – select the appropriate Item group for the selected product. For example, Ethicals, Front of Shop, etc ...
   • General fast tab > Item model group: set MOVG for all products, SERV for service items.
   • Product > Dimension groups
     • Storage dimension group – select SiteWH
     • Tracking dimension group – select None.

Run the On-hand inventory report to check on the Total product count for the store (this count does not consider assortments in place). This report also identifies Total products with SOH <> 0

1. Navigate to Inventory management > Common > On-hand inventory.
2. Click Add to add an additional line to the range table.
3. Select the Inventory dimensions table.
4. In Criteria, select the applicable warehouse for the store.

   

5. Click OK to save.
6. To assist with your data analysis, export this report to a spreadsheet.

   This process will take some time.

   

   The data in the report includes:

   • Total product for the store (not including assortments) – total count of records on the spreadsheet.
   • Filter by products with 0 SOH to get a count of these lines.

• Ensure the end of day process has been completed on all terminals that have processed transactions.

  See Fred NXT Office> End of Day

• Commit or post any outstanding purchase orders and invoices.
• Print the Waiting Scripts report in Fred NXT POS and reconcile against items in the Waiting Scripts area.

  Waiting script items are marked as sold and should not be included in the count.

  See POS reports .

Items with no recorded barcode are not exported to the Export datasheet.

1. From the FredNXT Head Office area page, navigate to Inventory and purchasing, then click Generate Third Party Stocktake.

   

2. In the Third Party Stocktake form, set the following:

   

   Option	Description
   Store	Select the relevant store
   Include Zero Stock Items	(Recommended) Do not select this option to exclude items with 0 SOH. You should generate a counting journal only for items with a SOH value at the store. If you include Zero Stock Items, your counting journal will include an excessive number of unwanted lines.
   Batch Tab	(Recommended) Select this option in order to allow batch processing and improve performance.

3.  Once the batch processing is complete, return to Inventory and purchasing, then click Counting to retrieve the newly generated Counting Journal.

   The processing time may vary according to the number of lines in the journal.

4. In the Counting form, select the relevant journal, then select Export Stocktake from the Import/Export menu.

   

5. Select the file path and file name for saving the journal and click OK.

   

   Once this file has been generated, it can be provided to the stocktake provider.

   This file will exclude any items that do not have a valid barcode, as this is the primary identifier for the External Stocktake Vendor. Items without barcode records will be handled as exceptions.

1. In the Stocktake form, click Create to create a new journal.
2. In the new Create Stocktake form, enter a Description.
3. Click Add Products.

4. As required, toggle Advanced Filters to Yes to exclude specific products from the stocktake on the basic of these criteria:

   • Negative stock only
   • Exclude zero stock: Products with negative or positive SOH are include, but products with 0 SOH are excluded.
   • Exclude products with no barcodes
   • Counted prior to: Selected a date.

   

   If one or more Advanced Filters have been applied, the colour of Advanced Filters button changes to green.

   

5. Once all the products to be counted have been added, click Export Stocktake to export your list of products as .csv.

   For products with multiple barcodes, the newly created counting journal (.csv) displays one line for each barcode associated with a product.

   Recommended: Once the .csv file is downloaded, it is recommended to send it immediately to the stocktake provider, without opening it or editing it.

During a stocktake you will encounter products that cannot be counted. For example, products with an invalid barcode in Fred NXT Head Office or products that do not exist in Fred NXT Office.

All these products should be set aside and handled after the stocktake.

1. In Fred NXT Office, search for the product in Search Products ...

   

   You can search by barcode or description.

2. Click Quick Update.

   

3. In Quick Update, enter the correct available total SOH value for this product and adjustment reason

   

4. Save your changes.
   • For any product that can be found in Fred NXT Office with a missing barcode, add the barcode yourself or contact you Head Office.
   • For any product that cannot be found at all, inform your Head Office to create the product.

This process also includes any products never counted for the selected store. The On-Hand-POS/Dispense value is summed across all stores. The On-hand value is correct for the selected store.

1. in Fred NXT Head Office, under Inventory and Purchasing, click Counting.
2. Set the name of the new journal to CNT, then enter a Description.

   

3. Click Lines, then Create > On Hand.

   The Create on-hand counting journal form is displayed.

   

4. Enter the required date in the Not Counted Since field.

   

5. Click Select and select the required store (warehouse).

   

6. Click OK to close the form, then OK again to exit the Create on-hand counting journal form.

   The journal lines are populated with any lines not counted since the selected date for the selected store.