Understanding the Journalize Consolidation Balances Program

After you receive the multisite consolidations at the target company, you should run integrity reports to ensure that the data that you received is accurate. Then you must run the Journalize Consolidation Balances program (R10480) to create journal entries for the summarized account balances that were received from the source company. These journal entries are based on the difference from one consolidation batch to another.

When you run the Journalize Consolidations Balances program, the system reads the F1001, F1002, and F1003 tables and creates journal entries in the Journal Entry Transactions - Batch File table (F0911Z1).

You can run this batch program in proof or final mode. In proof mode, the system prints a report of the journal entries, but does not update the F0911Z1 table. In final mode, the system creates the journal entries in the F0911Z1 table and, based on a processing option, prints a report of the journal entries.

The report shows the journal entries that were created for the summarized balances from the source company by source system ID and batch number. It also shows batch totals.

The BU (Business Units) and AC (Accounts) columns contain information about dynamically created business units and accounts. Review values that you might see in these columns:

• Blank:

  The business unit or account already existed.

• 1:

  The business unit or account was not dynamically created because an error occurred during processing.

• 2:

  The business unit or account was dynamically created.

When the system creates journal entries in the F0911Z1 table, it does this for each journal entry:

• Places a concatenation of the source system ID, the batch number, and the transmission date in the Explanation field.

• Places the consolidation name in the Transaction Number field.

• Places the last day of the corresponding accounting period in the G/L Date field.

• Places the source system ID in the User ID field.

  Note: Regardless of the type of account, the system always updates the Balance Forward field in the F0902 table. Usually, the system does not print balance-forward amounts for income statement accounts. However, to enable inception-to-date reporting for multisite consolidations, the system prints beginning balances for income statement accounts.

If the Journalize Consolidation Balances program dynamically creates business units or accounts, it generates reports that show the new information.