I need to produce a Negative Stock On Hand report. What filters do I need to add to my Inventory Sta


Comments
-
This content has been removed.
-
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.0
-
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
Shaz Hughes Dip(Fin) ACQ NSW, MICB
*** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***
* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *
Accounted 4 Bookkeeping Services
Ballajura, WA
(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
2 -
Thank you so very much Shaz
You are a Life Saver
1