Hi,
I have got the following scenario. The price list is updated the way new records with the date of update from a supplier are added to it. Each updated record (line) shows further details on Supplier, P/N, Site and MOQ (Minimum Order Quantity). Old records stay in the price list and are never removed. The records may not be sorted.
I need to look up for each record (line) in the price list the previously valid price (in order to be able to compare it, calculate inflation, etc.) which corresponds to the same Site, Supplier, P/N and same or the closest MOQ.
Many thanks for help.
Bookmarks