Here previous price
Then I Changed price
The whole column have been changed price.I want to change price for next order not for previous
Thanks All
Write the price to a basic column in the sale table when a row is added instead of using a lookup to get the price.
Also for the future, a Rollup column is not necessary the way you are using it. The Lookup column should be enough as long as your relation is a single relation instead of a multiple relation. But for this case, you shouldn’t need a relation, lookup, or rollup if you write the price when the row is added.
1 Like
Tenho um projeto da maneira que você esta tentando fazer, uso outra tabela para atualizar o preço, depois uso um relacionamento para vuscar informações sobre atualizacoes de preços, em seguida uso uma coluna para inverter os preços e uso o último.
Ao invés de buscar o valor do produto por um relacionamento, tente gravar o preço assim que for salvo
2 Likes
I don’t understand.The previous price have been changed when I try that you say.I want to create POS.
To change the price automatically, I would put a stock on the product, then a conditional, that when the stock is equal to the minimum that you decided to execute, it changes to the column with the other price, it is something simple to do, remember to synchronize the buy action button so that the stock is automatically subtracted, so when the quantity is lowered it will apply to the column with the new price.
1 Like
But item are still.How to do that I want change only price?
Have you tried doing exactly this?
1 Like