I need available batch quantities

Hi,

I need help to compose this query below:

When there is a goods receipt (PO) the system should send a message to user about the items ready to release to fulfill open quantities. The problem comes from batch numbers as we use them at every item. I need available batch quantities that may cover open quantities of an order (pick & pack manager).

Thanks for any help.