Cleaning Historical Blank Cash Transactions

Cleaning Historical Blank Cash Transactions

This enhancement creates a new private function CLEANBLANKGLTRANS. The utility is used to clean up cash transactions in APL that have a missing (i.e., "blank") sleeve code.

The utility prompts you for a date range and set of accounts.

The utility then scans all cash transactions during the given date range for the set of accounts.

Note: Non-UMA accounts will not be affected since sleeve level cash is not calculated for these accounts.

Cash transactions with a transaction type of “OPE” or “MEMO,” or containing a zero value (i.e.: security reorg indicators) will be excluded from consideration since these transactions do not impact sleeve level cash.

Cash transactions meeting the requirements with a BLANK sleeve code will be deleted from APL. The value of the deleted cash transactions will be prorated across the corresponding asset allocation for the account on the date of the given cash transaction. These prorated values will be reposted to APL using the standard MSPPOSTGL utility. The description of the deleted cash transaction will be replicated across each new prorated cash transaction. Deleting untagged cash transactions and reposting cash transactions with a sleeve code will not impact sleeve level cash on APL.