AnsweredAssumed Answered

Total for purchase order in schema or not?

Question asked by rjalex on May 19, 2017
Latest reply on May 20, 2017 by beverly

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

Outcomes