1 Reply Latest reply on Oct 17, 2012 9:41 AM by mikebeargie

    Update Inventory

    laguna92651

      Can you explain how to update an inventory list after Order Entry lines are created in an invoice.

        • 1. Re: Update Inventory
          mikebeargie

          you would need to do this both relationally and calculatory.

           

          Set up a relationship between Products and Invoice Line Items

          In Products, have a numeric field of "initial inventory"

          In Products, have a calc field of "counted used", that uses count(Invoice Line Items::quantity)

          In Products, have a calc field of "remaining inventory", that uses initial inventory - counted used.

           

          This will give you a field in products that shows the amount of product remaining.

          1 of 1 people found this helpful