Current sales price Field in Item table

guganvarman_21

I have created a field in the item table.That field will display the latest current price of the item.

Ex.
I have updated the price for the item A as $10 from 01/01/19 to 31/12/19.the field will show $10 as the current price.
Suppose when i update the price of the item A for a certain period 01/10/19 to 30/11/19 as $15. It should display the current price as $15 for that period alone.After 30/11/19 it should display the previous price $10.

How to achieve this?

Thanks
Gugan

TallyHo

Sales prices can vary per item not only by starting date but also
Customer,Campaign,Currency Code,Variant Code,Unit of Measure Code,Minimum Quantity

You'd have to rule some of this out or create/use filterfields for them, make your field a flowfield, add a date filterfield to the item table for the purpose. Use the datefilter field in your flowfield.
In the page where you show your flowfield create this line of code:
"New Date Filter Field" := workdate;

guganvarman_21

okay.
I need to fetch only the latest price here.