AnsweredAssumed Answered

Stock Deduction

Question asked by on Aug 23, 2016
Latest reply on Aug 23, 2016 by

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.