Current sales price Field in Item table

guganvarman_21guganvarman_21 Posts: 14Member
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 Posts: 304Member
    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 Posts: 14Member
    okay.
    I need to fetch only the latest price here.
Sign In or Register to comment.