How to query Receiving Quantity & Inbound quantity
Hi Experts,
I am developing a report to show Item On hand quantities along with the Lot and corresponding Sales Order details.
I am also trying to show the Receiving Quantity as well as Inbound Quantity in it. However, I am unable to find the exact column that stores these quantities. In rcv_transactions table, the item's Receiving quantity is shown, but in the frontend that Receiving quantity is showing under Inbound Quantity and Receiving quantity is 0.
Therefore, kindly help me to find how I can query the exact value from backend.
Regards,
Pamela
0