Overwrite calculated line items
I'm currently working on a large P&L module with a lot of line items (100+) that are either populated via a lookup to calculations modules or calculated by taking a YTD average + inflation.
The problem is that some of those average YTD values turn out to be negative due to a one-off negative transaction in the actual months. In these cases the end user would like to overwrite these values. At the moment, this is not possible because the line item is calculated.
I thought about doubling all line items with a calculated line and an overwrite. The final P&L would then take whichever line is appropriate. This would be a very tedious and cumbersome process since there are a lot of line items. The end user will only need this functionality in rare situations.
Does anyone have a better way of solving this issue? Ideally, the end user can indicate which line item to overwrite, do it and leave the rest untouched.
Thanks in advance