37 Journalize Consolidation Reports

This chapter contains these topics:

37.1 Journalizing Consolidation Balances Report

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

Figure 37-1 Journalize Consolidation Balances report, Financial Rollup

Description of Figure 37-1 follows
Description of "Figure 37-1 Journalize Consolidation Balances report, Financial Rollup"

37.1.2 Data Selection for Journalize Consolidation Balances

You must set the transmitted file status EQ (equal to) to 1.

37.1.3 Data Sequence for Journalize Consolidation Balances

Set the user ID to sequence 001 and the batch number to sequence 002. The user ID is the source system ID.

37.2 Accounts Created Financial Rollup Report

This report shows new accounts that the system created at the target company. These accounts did not exist before this consolidation was processed.

Figure 37-2 Accounts Created report, Financial Rollup

Description of Figure 37-2 follows
Description of "Figure 37-2 Accounts Created report, Financial Rollup"

37.2.1 What You Should Know About

Topic Description
Creating journal entries When the system creates journal entries in the Journal Entries Transactions Batch table, it does the following 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