Hi Team , I am looking for the ideas to bring historical forecasts and actuals from the old SKU to new SKU . The Idea is we have NPI product which is actually a successor of the Old SKU with difference in some aspects such as packaging size. I want bring all the Historical data associated with old SKU to new SKU by some factor. It can't be formula driven since we Plan to delete to old SKU in future.
Can anyone please suggest me Best Practices in this regard and how I may achieve this. Thankyou!!.