Hello,
I have a request to create a BAQ.
here is the challenge.
in Part BIN
Part BIN onhandqty PCID LotNum
1111 01 23 0001 0001-1
1111 01 34 0002 0001-2
1111 01 150 0003 0001-3
in the shipment, if the shipqty is 12, the count() of PCID in PartBIN is 1
if the shipqty is 50, the count() of PCID is 2
if the shipqty is 400, the count() of PCID is 3.
I need display the count() of PCID in the packslip based on the shipqty against sum(onhandqty) of PCID.
any ideas? i can do it in the sql but i don’t know how to do it in BAQ.
Regards,
Eddy