Help With quantity on Hand Calculation

[Lola]

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. I want also that my Initial value for Quantity returned is my Quantity Received from my parent table. 

 

Attached is the file that I'm working.

Thank you so much in advance.

Material Transaction.fmp12

Edited August 2, 2018 by Lola

[Lee Smith]

These old threads might be helpful.

https://fmforums.com/topic/98149-simple-inventory-database/?tab=comments#comment-446272

https://fmforums.com/topic/98078-decrease-stock-quantity-from-item-sold-when-sales-completed/?tab=comments#comment-445950

Lee

 

[Lola]

Thanks Lee,

I will take a look.

[Lee Smith]

Hi Lola,

 I move your question to the calculation topic Calculation topic