AnsweredAssumed Answered

Stock Deduction

Question asked by chris.tidey@tideyelectrical.com on Aug 23, 2016
Latest reply on Aug 23, 2016 by chris.tidey@tideyelectrical.com

Hi All,

 

I have a Materials / Stock ----->Materials_Orders<------Orders tables, I currently have a layout called worksheet which if you pick the Material ID it then fills out the materials detail from the stock cell. But what I want to do is when you pick quantity in the portal on the worksheet I want it to deduct the stock in my materials table. Ive tried Material::Amount in stock - Materials_orders::quantity and it returns a minus number.

 

I would also like to do a search bar in the worksheet materials table so that they can search for the materials and add them to the portal.

 

Ive attached the file.

Attachments

Outcomes