Loading ...

Item w zero on-hand shows despite filtering out zero on-hand Lots | CLEARIFY - Page 1

Posted in: QQube    General Usage

Item w zero on-hand shows despite filtering out zero on-hand Lots

Subscribe to RSS
  • I'm using the Filter Values options and selecting Does Not Equal.  I'm inserting 0 for the answer to that Does Not Equal question.  Yet some Lots with zero on-hands are still visible.  I expanded one and found this:

    Quantity Received:  248

    Quantity Invoiced:  -248.45

    Inventory Adjustment:  .45

    The net of those three transactions is zero.  So, not sure why it is still visible on the report.

  • You might try the forums at Mr. Excel - they are the absolute gurus as Excel functionality.

    https://mrexcel.com/ 

  • Thanks for the lead.  I'll try them next.

Page 1 of 1 (3 items)