Ignore lot number

Epicor ERP 10
1

Hi all,

I’d like a BAQ that shows the OnHand Qty for a bin ignoring the lot numbers or is the sum of On Hand Qty for all lot numbers.
E.g. in my case for Bin 0M0D I want to see OnHand Qty = 251.

Thanks

image
image.png828×464 23.6 KB

2

A simple BAQ of the PartBin table can provide that.
Add a calc field of type decimal, with the formula

SUM(PartBin.OnHandQty)

All other displayed fields will have to have their Group By box checked.