F
Frank
Hello,
to keep track of frequent price changes with several products I
maintain a simple list of 3 columns: ProductName, DateOfChange,
NewPrice.
To calculate turnover, I then need to multiply the quantities ordered
of each product with the product’s price that was actually valid at
the order date.
Is it possible to find the applicable prices for a, or any, given
order date ?
Grateful for your consideration,
kind regards,
H.G. Lamy
to keep track of frequent price changes with several products I
maintain a simple list of 3 columns: ProductName, DateOfChange,
NewPrice.
To calculate turnover, I then need to multiply the quantities ordered
of each product with the product’s price that was actually valid at
the order date.
Is it possible to find the applicable prices for a, or any, given
order date ?
Grateful for your consideration,
kind regards,
H.G. Lamy