How to update the data in a worksheet
We have a custom level that we use for the item versions named Item Family. When we apply a sales base override at that level it gets allocated to the items in that family that have a final forecast. The issue is that we have multiple versions of the item and are in the same item family when we apply the sales base override it gets to the version that had the final forecast at that time.
When we do an engine run it create forecast to the new version but the sales base override does not move causing the sales proj vol to take both the override value of the old version and the final forecast of the new item.