Override function to SUM function
We develop a table setting out the results of transactions per code type across multiple categories (AP, AR, GL. etc). The results are calculated from detailed transactions . The customer process dictates that the amounts determined should allow for overrides to assign the amounts (all or a portion) to another area within the same code e.g. Code BO87 from AR to AP on the same code using an override column per category
The underpinning formulas are:
The Override column must enable user inputs (overrides) and the results has be recalculated.
The layout and results does not allow for manual input