Purge Zero Budgets and Actuals - GLUTDIPU

This utility purges the Organization Key and Object Association (Account) for any account which has a zero budget and against which no transactions have been posted.

It reads the specific glba_budact_mstr record for a specific account.

It checks: 

• glb_budget

• glb_bud_acc

• gla_actual

• gla_en

• gla_open

• gla_close

If any of these fields have zero values, then it deletes the glba_budact_mstr record.

Then it looks at the cash accumulators for account at this level (for example CB for the OB level). If any of the gla_actual, gla_en, gla_open, gla_close amounts are zero, then it deletes the glba_budact_mstr record.

This utility provides only information for glba_budact_mstr records which are being purged. In the background, it checks general ledger (glt_trns_dtl) and encumbrance (en_dtl) transactions for the given account and if the balance is zero, then it deletes the glba_budact_mstr record. 

If the Purge of Accounts displays No Entries Deleted, it means that the given account does not have a zero budget, and transactions have been posted.