How to handle VC calculations with changing values

[Marc_Dillon]

I was wondering what kind of solutions people have come up with to handle calculations where an assigned value gets changed over time, such as an item’s price. In an old contract/order/etc where a total has already been calculated with an old value, you would not want the total to change if that value got updated.

One solution I thought of is a table of “products” that includes a product name, price, and date. Can be multiple records of the same product, but with different price and date values. Each contract/order can also have a date value, and so would only reference product values that are “current” to it, via the dates.

Anyone else have other solutions?

[Aleksi]

I normally save the original price with the normal column which is not editable… and I mean together with the “order”. Then you don’t need to worry about the total calculation.

[Marc_Dillon]

Thanks @Aleksi . That sounds like it would be more efficient too.

[Aleksi]

You’re welcome