General Stock Listing

General Stock Listing

The General Stock Listing Report lists selected stock items by department/category as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing stock with a negative stock on hand.
Warning
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
At the end of each category and department it will show a total as well as an overall total at the end.

Exporting the Report to Excel

Idea
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.
You can export the report to an Excel spreadsheet by using the Preview button and following the below steps:
  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.

    • Related Articles

    • Supplier Stock Listing

      The Supplier Stock Listing Report lists selected stock items by department, category and supplier as of when the report is run. It is most commonly used for the value of the stock in the store, however it can also be used in other ways like listing ...
    • Creating a Stock Item

      We have a video guide on adding a stock item into Retailer - ? Adding Stock items Creating a Stock Item If the stock wizard does not appear when you click the Add button, click HERE to enable it. The stock wizard can be accessed through several ...
    • General Debtors Report

      The General Debtors Report allows you to see a list of your customers and how much they owe for any date since upgrading to Retailer 3. Effectively, the report can be backdated to see what customer accounts would have owed on a past date, and whether ...
    • Consignment Stock

      You may sell consignment stock, or commissioned goods (typically from a local supplier) and want to keep track of the products through sales and potentially receiving/returning stock. There are a few potential ways to handle this in Retailer, using ...
    • Store Locale

      Retailer allows you to more efficiently manage your stock in a warehouse situation by allowing you to assign your inventory a locale. This allows you to quickly and easily find and manage what stock you have on hand and assists in ordering the stock ...