[BUG]Low inventory report is multiple-showing items that have had inventory in more than one location. It shouldn't

[cielf]

Summary

If a bank has had inventory of an item in multiple locations, it is showing up in the low inventory list on the dashboard multiple times. It shouldn't

Why fix

Better, more concise report

Details

To recreate this:
sign in as [email protected]

You should see it in freshly setup data -- so take a look on the dashboard before going further.

Otherwise,

Choose an item -- then check its current levels (Inventory, Items&Inventory, view on the first tab.) Note the sum of the current levels. (if there is only inventory in one storage location, pick another item. )
Edit that item (back, then Edit), and set the minimum inventory to higher than that sum. Now check the dashboard -- you should see two entries for that item in the Bank-wide Low Inventory Report

Criteria for completion

• consolidate low inventory query so it only returns one line per item
• tests to support

[nikolaz90]

Hello,
Could I take this one ?
Thanks

[dorner]

You got it!