Hi everyone, 

When a need for reorganizing product lines occur, how are you dealing with that while reflecting the changes to the history files?  For example, simply changing a product line of an inventory will not change any history files or update SO_RecapByProductLineWhse.  So a common custom report that utilizes a ProductLine field in a history table or SO_RecapByProductLineWhse might have to be completely re-written, especially if it involves cross-period comparison or time-series.   Sure, a "OldProductLine" fields and effective dates can be added to mitigate some issues but that'll still leave the Pre-Calculated tables like RecapByProductLine table useless for a while.  

Ideally, an inventory item is assigned to a different product line, and we have an option to preserve the history as is or apply the new data to the past (though it might go over the maintenance window).  Is there a magical utility or a process to combat this challenge?

Ken