Current sales price Field in Item table

guganvarman_21guganvarman_21 Member Posts: 16
edited 2019-11-18 in NAV Tips & Tricks
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

Answers

  • TallyHoTallyHo Member Posts: 369
    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_21guganvarman_21 Member Posts: 16
    okay.
    I need to fetch only the latest price here.
Sign In or Register to comment.