Balance/Quantity Returned

Discussion created by thong127 on Aug 15, 2017
Latest reply on Aug 16, 2017 by thong127

Hello All,


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