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

Options
Olsens Produce
Olsens Produce Member Posts: 8
edited August 2020 in Reckon Accounts (Desktop)
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.

Comments

  • Olsens Produce
    Olsens Produce Member Posts: 8
    edited August 2020
    Options
    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. 
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,593 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited August 2020
    Options

    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


    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

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)
  • Olsens Produce
    Olsens Produce Member Posts: 8
    edited August 2020
    Options
    Thank you so very much Shaz :)  You are a Life Saver