2 Replies Latest reply on Aug 23, 2016 4:48 AM by chris.tidey@tideyelectrical.com

    Stock Deduction

    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.