Last purchase price

[kris_vliegen]

Hi All,

I have a table with a purchase price by article by vendor and with a start date of that price.

So It could be that we by one product on several(two) places at the same day.

The price is value till the record with the next date for that article.

We also have a table with the data of sales.

Now I would like to get the correct purchase price on every salesline.

How can I do this best in the script?

Regards,

Kris

[micheledenardi]

Hi Kris,

look at this thread, i think is exatly what you need

Populate column with previous available value.

[kris_vliegen · Accepted solution]

Thanks Michele for the answere.

But I've create a from and a to value (date)

And I use now the intervalMatch function.

regards,

Kris