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

    Total for purchase order in schema or not?

    rjalex

      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