
Dear Experts,
I'm developing a Query to get the information about the available quantities of the materials in a sales order.
Below I've joined the JPG image of the Joined tables. My question is How can I convert the unit of measure from PC to Carton in the query? Because the query displays the available quantities only in PC (Base Unit of Measure).
For example 2000 is a sales order. It has 10, 20, 30, 40 & 50 Items. I want to see the unrestricted stock available in the plant for the material before delivering the sales order. The sales order has all the sales items in Cartons. Sometimes we have lot of items for a sales order. We can not check each item in MMBE. So, I'm developing a Query.
Can you suggest me a solution to get the unrestricted quantities of a material in CARTON using the query?
Thank you in advance.