modifying a inventory status by item report

Kylie Austin
Kylie Austin Member Posts: 11
edited February 2020 in Accounts Hosted
I am wanting to modifying an "inventory status by item" report. using Accounts Hosted 2017
Quantities are in the report at this stage.
I am wanting to look at a specific range, so click modify, then item, then scroll to find the main item heading I would like, there are about 50 line items under this.
The report filters, then all the quantities (on hand / on sales order/  on purchase order etc) all show a 0. What am I doing wrong? is there a better report that i can be using?

Comments

  • Shane_6461899
    Shane_6461899 Reckon Staff Posts: 339 Reckon Staff
    edited February 2020
    Hi Kylie,

    The solution to this is that when you are filtering, on the item filter don't choose the header item, choose "Multiple Items" and then tick off the header item, and each of its sub items.  This way they can retain the quantity on hand.

    image

    Regards,
    Shane.