5 Replies Latest reply on May 20, 2017 12:08 PM by beverly

    Total for purchase order in schema or not?


      Dear friends,

      as some of you know I'm struggling through my first FM experience by attempting to create a full Oder/Inventory/Sales system.


      On a first thought I had defined a order_total field in the Purchase Order table but actually I could always reconstruct this number by summing all of the PurchaseOrderLines quantity*price relating to that given PO.


      What would be the best way to proceed ? Dumping the field and calculating it on the fly or keep it there for some reason ?


      Thank you