BCGSNAP - Insert BC Members And Check Financial Integrity Of All FTs

This process performs the following two functions:

  • It summarizes new financial transactions under the current Pending balance control group as follows:
  • It creates a balance control member for every combination of Division, SA Type and FT Type referenced on the financial transactions belonging to the balance control group.
  • It updates each balance control member with the following information:
  • The number of financial transactions (FTs)
  • The sum of the total amounts on the FTs in this balance control group.
  • The sum of the current amounts on the FTs in this balance control group.
  • The sum of the total amounts from all FTs (in this and all other balance control groups).
  • The sum of the current amounts from all FTs (in this and all other balance control groups).
  • It sets the status of the balance control group to Complete.
  • It checks the integrity of the financial transactions in each historical Balance Control Group. It does this by summarizing EVERY financial transaction throughout time and determining if the sums are in sync with the values maintained on the balance control members. If integrity problems are detected, a detailed error message is displayed on the run control associated with the process.

If you opt to run the balance control processes on a nightly basis, you will find that the verification processing will take longer every night (because there are more financial transactions over time). In order to deal with this issue, the BCGSNAP process has a parameter that allows you to control which of the above functions is implemented (it's call VERIFY-ONLY-SW). In order to speed nightly processing, run this process with the switch set to "G" (this causes new financial transactions to be summarized under a new balance control). Then, once a week (or month), run this process with the switch set to "Y" (this checks the financial integrity of all financial transactions in the system).

If you run the balance control processes less frequently, you can set the VERIFY-ONLY-SW to "N" (this causes both of the above functions to execute).