Forum Discussion

JA_Xtnow's avatar
3 years ago

Inventory Report not accurate when trying to deselect Inactive Items

I have a problem with the Item List Summary Report trying to deselect inactive items.

Granted we have over 15,000 items.

The report works with all items but its slow.  We only have 4,000 active items which we want reported.

I have seen the instructions re the Show Inactive Items Filter under the Select Item Filter.

I seem to be able to select:

Include Zero Quantity

Deselect the box Show Inactive Items

Then select the box for all items.

The report that prints does not include all active items and actually also includes inactive as well.  Its as though its randomly picked inactive items to replace the active ones.

We are talking nearly 2,000 wrong.

 

 

 

3 Replies

Replies have been turned off for this discussion
  • CloverQ's avatar
    CloverQ
    Former Staff
    3 years ago

    Hi JA_Xtnow 

     

    Thank you for the details and the screenshot. We are aware that there's a problem with the Item List Summary report not remove inactive items properly from the list, when the 'Show Inactive Items' tickbox is unticked. 

     

    This is something our developer teams are looking into, in the meantime, you can work around it by:

     

    1. Deselect the show inactive Items option
    2. Select all the desired Items
    3. Select show inactive Items option
    4. Click OK
    5. Run the report
  • Thankyou for responding Clover but unfortunately the work around has not resolved the issue.

    You can see the screen shot that the items selected are being replaced by inactive items.

  • CloverQ's avatar
    CloverQ
    Former Staff
    3 years ago

    Hi JA_Xtnow 

     

    Thank you very much for the update and screenshot, I've passed on the feedback to the relevant team for help with their investigation.

     

    In the meantime, I'd suggest ticking all items then export the report to Excel for futhre filtering. Alternatively File > Import and Export Assistant can export all item fields promptly, the exported .txt file can be customised in Excel as well.