Updating previous day balances

Use this procedure to bring forward the previous day balances to the current day for cash codes in which no activity existed for the current day.

The Cash Management cash code file is used to find all cash codes with the Summarize Ledger Balances flag set to Yes.

For each cash code found, the program finds the most recent Cash Management consolidation record at the cash code level. If a record is found for the current date (the date for which the CBCONSOL Current Day Build (CB181) is run), then no further processing is done for the cash code.

If a previous day record is found and no balances exist, then no further processing is done for the cash code.

If a previous day record is found and balances exist in the bank ending balance, the open ending balance, or the account ending balance, then these processing take place:

  • A Cash Management consolidation record for the cash code level is created for the current day. The existing ending balances from the previous day record are moved to the respective beginning and ending balance fields for the new current date record.

  • Using the previous day date found for the cash code, a search for all related company level records is performed. If any company level records are found and they contain any ending balances, then a Cash Management consolidation record is created for the current date at the company level. The existing ending balances from the previous day record are moved to the respective beginning and ending balance fields for the new current date record.

  • For each company level record found, a search for all related transaction code level records is performed. If any transaction code level records that contain open ending balances are found, then a Cash Management consolidation record for the current date is created at the transaction code level. The open ending balance from the previous day record is moved to the respective beginning and ending balance fields for the current date.

Complete these steps to bring forward previous day balances:

  1. Access CBCONSOL Current Day Build (CB181).
  2. Use the Job Name, Job Description, and User Name fields to narrow your search.
  3. Click Submit to process your request.