Recommendations for Establishing Budget Controls

 

With the introduction of the performance enhancement of incremental updates to budget lines in the Advantage 3.3 release, changing certain fields on the BUDCON table after budget lines have been created will involve a batch program.  Once a budget line is created that a control would apply to, a record is created in an offline tracking table that stores the LHS and RHS amounts calculated from that budget line for that control.  If a control was not activated (that is, marked as any other default violation other than No Action) initially for that budget line, then when that control is activated, a record will be missing in the offline table for that budget line.  The running of the Calculate Budget Control Amounts batch job will need to be run to update the offline table.

As mentioned earlier, certain changes to the BCADM table can require the same batch job to be run before the application should be used.  There are two other tables that changes to will cause the offline records of control amounts to become incorrect.  One is the Formula table, where formulas for calculated amount fields are stored.  Changing how an amount in a control is calculated would naturally make the amounts stored for a control to be incorrect.  The other is the Budget Tracking Amount (BUDTAM) table.  This table can cause incorrect control records in two ways.  The first is the formula for a calculated bucket being changed to another formula.  The second is selecting or deselecting one or more of the include pending amount flags.  The first of these two changes on BUDTAM and the change to the Formula table will have an impact beyond the stored control amounts: the budget inquiry tables will not reflect the current amounts until the application has performed a save to the budget line.