I want to trace the Lot Number and How many quantities in which a certain material was used in a certain product until it finished.
My problem is I need help to my calculation to my Quantity Balance and Quantity Returned Fields because I cant figure it out.
In the attached File If I Received like for example 50Kg and they Dispensed 23Kg I Have a Quantity Returned of 27Kg, but in my Quantity Balance Field it shows only 4 Kg. and when I put 27Kg to my Quantity Dispense Field my Quantity Balance Field Shows 0 but in my Quantity Returned Field it shows 23Kg.
Please find attached file that I'm working.
Thank you so much in advance