AnsweredAssumed Answered

Help in Finding my Quantity on Hand

Question asked by thong127 on Aug 2, 2018
Latest reply on Aug 2, 2018 by philmodjunk

Hello All,

 

I have two tables, Material table and Material Transaction table In my material table I have the Quantity on Hand a Calculation Field (Sum ( Material Transactions::Units In | Out ))  and on my Material Transaction I have the following Fields Quantity Dispensed ; Quantity Returned ; Type (Auto Enter Data "In") ;  Units In | Out which is a calculation field (If ( Type = "Out" ; 0 - Quantity Returned ; Quantity Returned )

 

In my portal from Material Transaction I have a button bar (In | Out) which there is a single step script that set the type into In or Out which is not working and my Quantity on Hand and my Quantity Returned is not matching which is my problem.

 

Attached is the file that Im working.

 

Thank you so much in advance.

Outcomes