thong127

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

LoLa

Outcomes