lock updating older rows

[Gokul1]

when i change the pricing of goods. when changes are being made to older bills, the app formula in those rows  updating the row  with the current price. 

[AleksiAlkio]

Instead of using app formula, read the value etc. with the initial value. Then it won't change later.

[Gokul1]

i feel like the user needs the app formula because when they make changes to the item and quantity it should reflect after making changes.

[AleksiAlkio]

Then you need to have an additional column where you have the "base" price, and that is read with the initial value. Then you can have the app formula, but it reads the base price from that row, not from another table.

[Gokul1]

once they select an sku and save it. when they go back again and change the order to a different sku wouldnt the base price(initial value formula) be of the previous sku?

[AleksiAlkio · Accepted solution]

If that's the case, yes this will happen. You need to deside where you set the limit. If the user change the SKU, it could probably change the base price. You could use that as a condition with the "Reset on edit". There are many ways to control this, but first you need to decide how it should work exactly.

[Gokul1]

i didnt know we could condition rest on edit!!! it works

[AleksiAlkio]

Excellent!

[jaichith]

MASTER DATA should be prices and items names (make it as separate table)

from master data you should call initial value (price of the products)

use select() function to call price for the specific product. 

formula (calculation) can be done using virtual column or table column. it is your choice. 

don't put the value in formula column because it change all the records which is done earlier too during when ever app refreshes or syncs.