Skip to Content
Former Member
May 19, 2016 at 03:25 AM

SQL table contains Inventory transfer request open quantity for batch items



I have created a Inventory transfer request with batch items. For example, item A with quantity 3 (batch 1 x 1; batch 2 x 2). Then I copy to Inventory transfer with one item A (batch 2). The open quantity for the item A in ITR is 2 (batch 1 x 1; batch 2 x 1).

Which SQL table should I look for to obtain the open quantity for each batch (batch 1 x 1; batch 2 x 1)?