Best way to handle validity of products prices
Hello Anaplan community,
I'd like to create a model that stores prices for my items, and the evolution of these prices.
A few constraints though:
- Prices can evolve with time, and the applicable price at one date can be different from the applicable price at another date.
- Products don't change prices at the same time, and changes in prices don't happen so often (perhaps once a year or once every two years).
- The active price is the latest price input.
- I'd like to be able to easily gather the current price for one or more products, or their prices at a specific date.
- I'd also like to keep track of the history of price changes to have a neat view of the price evolution of a product.
- It must be quite simple to input the prices for many products in bulk.
I thought about a few solutions:
- Create a module where time is a dimension, and products also, with a line item with the product price, but:
- I find it really heavy to maintain the price for each day/week/month/year (depending on the time granularity) for each product
- The price may change at a specific date/time, in the middle of the week/month/year
- Create a numbered list where each item would be the n-th price of the product, and create a module with that list and the list of products and two line items (one with the product price, one with the effective date), but:
- Getting the current active price, or the price at a specific date seems complicated, as it may be on a different item of the n-th change list.
- Changing latest prices in bulk seems complicated too.
What would be your recommendation on how to handle this?
Thanks a lot,