I need to produce a Negative Stock On Hand report. What filters do I need to add to my Inventory Status by Item report?

  • 1
  • Question
  • Updated 4 days ago
I need to run a Stock on Hand report with values less than 1. I know how to run an Inventory status by item report. I just dont know what filters to add to get the result I need.
Photo of Olsens Produce

Olsens Produce

  • 100 Points 100 badge 2x thumb

Posted 4 days ago

  • 1
Photo of Kevin Russell

Kevin Russell, Accredited Partner

  • 59,336 Points 50k badge 2x thumb
What have you tried so far?
Photo of Olsens Produce

Olsens Produce

  • 100 Points 100 badge 2x thumb
As I am new to reckon, finding the filters for different things is a little hard. I have tried an item amount < 1 but it doesnt give me what I need. 

Hi Olsens Produce

 

You can modify an Item Listing report to achieve this:

 

  • Go to your Item List (can access via your Home screen or under the Lists dropdown menu)
  • At the bottom of the window, click on Reports > Item Listing
  • Click on Modify Report at the top left
  • On the first (“Display”) tab, you can tick/untick applicable columns as required
  • On the next (“Filters”) tab, select “Quantity on Hand” in the Filter list, then select the “<” then type “0” into the blank box
  • On the next (“Headers/Footers”) tab, you can rename the report by typing into the Report Title box (eg “Negative Items on Hand Report”)
  • Click OK to generate your report

 

You can also remove report columns on screen by hovering your mouse to the right side of a column heading & then - when the pointer changes to a double-ended arrow - clicking & dragging the column across to the left.

 

Once you have customised your report, you can memorise it for re-use at any time by clicking on the Memorise button at the top left next.

You can also add this (& any other report or window) to your Icon bar for 1-click shortcut access by clicking on the View dropdown menu > “Add ... to Icon Bar

 

Hope that helps  :)

 

Shaz Hughes Dip(Fin) ACQ NSW, MICB

Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

Accounted 4 Bookkeeping Services

Ballajura, WA

0422 886 003

shazinoz2@bigpond.com

www.accounted4bs.com