You cannot run the report for a selected date. If you need a stock on hand report of a specific date then you must have a backup to be able to load the data to generate the report.

Generating the Report

1. On the top menu bar of Retailer, click on Reports > Stock Reports > Stock Listing Reports > General Stock Listing
   
2. Select Quantity On Hand Level
   
1. All Stock Items - Will show stock regardless of quantity on hand
   
2. Greater than 0 - Only show stock with quantity on hand greater than 0
   
3. Less or equal to 0 - Only show stock with quantity on hand less than 0 or equal to 0
   
4. Less than 0 - Only show stock with quantity on hand less than 0
   
3. Stock Options:
   
1. Select All  - Shows stock from all departments/categories.
   
2. Selected - Tick the departments you want included in the report. By clicking the arrow next to a department, you can expand its categories and further narrow down the included stock by category.
   
3. Include stock not in a Category - Tick this box to include stock from the selected departments that has not been assigned a category
   
4. Details to Display - this changes whether the PLU or Supplier stock code is shown
   
1. Stock item's PLU
   
2. Supplier Stock Code
   
5. Order items by - this option is only available if Supplier Stock code is chosen in the option above
   
1. Alphabetical order
   
2. Supplier Stock Code
   
6. Locale Options - Report must set to landscape orientation to use these options
   
1. Show Locales - Ticking this will display the store locales of stock on the report
   
2. All Locales - Tick to include all stock regardless of locale on report.
   
3. Selected Locale - Choose a locale to only include stock from that locale.
   
7. Other Options
   
1. Only Show Items With A PLU - This will only show on the report, items with a PLU, PLU can be added in the Stock screen.
   
2. Only Items that are Active - This will hide inactive stock items. This is set in the stock screen tick option Make Item Inactive.
   
3. Show Banding on Report - This will add coloured lines to the report to make it easier to read. The colour of these lines can be set in Setup > System > General
   
4. Price List Only - This will change the report to only show the description, barcode and retail price
   
5. Show Qty Pending Order - This shows if items on the report are on a pending supplier order.
   
6. Show Qty Sent Order - This shows if items on the report are on a sent supplier order.
   
7. Show Webstore items only - Will only include items that are ticked as webstore items.
   
8. Show Totals Only - This only shows the department and category totals rather then each stock item individually
   
9. Exclude Agency - This hides stock from departments that are set to Agency. This is set in Stock > Suppliers and Departments
   
10. Show Serial Numbers - If your stock has serial numbers if will show them.
    
11. Show Tags - Includes the tags for each stock item that has them.
    
12. Only Show items where Sell is below Cost - This only shows items where the Retail price is lower than the cost price
    
13. Exclude Reserved Stock from QOH count - When ticked, the Qty On Hand column will not have Reserved Stock Quantity added on. When unticked, the Qty on Hand column will include the Reserved Stock Quantity. The Reserved Qty will always appear as a separate column.
    
14. Show only items with Reserved Stock - The Report will only show items that have Reserved Stock
    
15. Show the Breakdown of Stock On Hand per Store (Multi-Store Only) - Shows the Quantity on Hand for each Store Location
    
8. Stock Tags - Select a tag from the drop down box and click the + symbol to add a tag. The report will only include stock that has one of the selected tags. To search for a specific tag, hit the ... symbol to bring up the tag searcher. You can remove a tag by hovering over it and then clicking the x symbol. If you do not select any tags, all stock will be included.
   
9. Page Orientations - Choose the orientation of the report
   
1. Portrait
   
2. Landscape
   
10. Click Preview or Print.
    

Reading the Report

1. Stock Description - The name of the stock item or name of department/category
   
2. Barcode - Barcode of the stock item
   
3. PLU or Supplier Stock Code - This will depend on the option chosen when running the report
   
4. Qty On Hand - The current quantity on hand of the stock item
   
5. Reserved Qty - The current quantity that has been Reserved in Quote and Invoice Management
   
6. Total Input Credit - The total GST on the cost price of the item
   
7. Cost Inc. - Cost price per item including GST
   
8. Total GST - Total GST on the Retail price
   
9. Sell per Item - Sell/Retail price per item
   
10. Total Cost - Total cost of the item including GST
    
11. Total Retail - Total retail of the item including GST
    
12. GST - In this column if there GST next to the item it means there is GST on the item
    

Exporting the Report to Excel

In Retailer 3.2, there is now a tickbox in the Report Options screen, Perform Export to CSV after Print Preview. Tick this box then click Preview. After closing the Report Preview, you will be prompted to save a CSV file of the report.

1. PDF - Click on the Printer 🖨️ button in the top left. Tick 'Print to File' and select 'PDF File' as the Type. Click on the three dots button [...] to choose your save destination. Click OK to save the file.
2. Excel spreadsheet - Click on the Print button in the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button [...] to choose your save destination. Click OK to save the file.