Points for the comparison report training.
Explain what the STOCK and the CATALOGUE files are. The Stock is your day to day file that holds your Stock Onhands etc. But the Catalogue holds EVERY product that is in your warehouse (DANKS or MITRE10).
Explain that normally if the store is a MITRE 10 or DANKS store, they will get any updates from the Warehouse loaded into their CATALOGUE every night, which is great for NEW products they scan. But this doesnt update their existing STOCK file. They need to run the comparison report for this.
The Comparison Report is looking through all the products in the “report” specified (IMPORT CODE), and finding a match in the STOCK file by barcode, part number or warehouse part number. This is specified in the IMPORTCODE field in the *.RPT file.
There could be times when it pops up with “xxx items that may need to be matched”. This occurs the first time the report has been run, when it “thinks” it is the same product. Once these are LINKED it wont prompt for that link again.
Where is the link? The link from a STOCK items SUPPLIER line to a CATALOGUE line. You can see this on the SUPPLIER line, COSTS tab.
For a store that has never run a comparison report before, always break down the report by Department or Supplier. There is a bug that the departments filter doesnt work in 2021.xxx but this has been fixed in 2022.2 and above.
Comparison Report - By Department
Then after that they can just run it with out any filters.
We would suggest to run the Comparison Report every fortnight.
Standard Report options
Normal Report options I untick:
Untick the “New Products…”
Untick “Change Description”
Remember Selection option
Ensure you tick the “Remember Selection” option as it remembers the ticks and options selected.
Reports to discuss:
Existing lines with new supplier.
If this store has never had a comparison report performed before, it is a good idea to ensure you have reviewed the stores multiple suppliers and tidied up accordingy. As we dont want the system to create a new SUPPLIER line when it doesnt need to.
Ability to set the Retail from the Catalague instead of recalcing the markup
This is in the Advanced button on the bottom right side of the Comparison Report.
The Text files
Where do they live?
\We\Share\Programs\CatalogImport\ComparisonReport
When a new “Import Code” has been created by the Supplier File Import, it will create the Comparison Report option report for you.
There are DEFAULT reports that has the options:
\We\Share\Programs\CatalogImport\ComparisonReport\#DEFAULT#.RPT
or
\We\Share\Programs\CatalogImport\ComparisonReport\#TEMPLATE#.RPT
The Field and details of these RPT files are stored in the:
\We\Share\Programs\CatalogImport\ComparisonReport\Fields.txt
Explain that the system doesnt change the Cost or Retail if the Supplier isnt a MAIN supplier.
By default it will use the existing markup on a product and recalc the price.
How do I set it so it uses the RRP?
Set the Pricing Type to RRP or RRP + Rounded.
Benefits of the rounding tables.
Cuts down printing labels for a 1 or 2 cent price change.
Links