I am working on a yield report to calculate the input output yield. I store the WIP in different warehouses.
Input A in Warehouse A with qty 10
Output A1 in Warehouse B with qty 8
So the yield for A should be (8/10)*100 = 80%
My problem is I don't know how to get the total quantity in warehouse B to be divided by total quantity in warehouse A for item A.
Is it possible to get the total quantity in one warehouse divided by total quantity in another warehouse in SAP B1?
Thanks & BR,