Consolidation Journal Management

Menu Path: General Ledger Images\bluerarw.gif Consolidated Ledger Management Images\bluerarw.gif Consolidation Journal Management

Purpose

Track and process journal entries in source and destination ledgers.

Overview

Use Consolidation Journal Management to process journal entries for source and destination ledgers.

Processing Consolidation Journal Entries

To process consolidation journal entries:

  1. Select filter criteria for the journal entries you want to process.

  2. Click the Show Data button in the ribbon. The Results tab displays journal entries based on the criteria you selected in step 1.

  3. Select the check box in the Select column for journal entries you want to process. You can also click the Select All button in the ribbon to select the check box in the Select column for all displayed journal entries.

  4. Use the ribbon buttons to process the selected journal entries:

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Consolidation Journal Management window.

Show Data

Click this button to display account information on the Results tab, based on the criteria selected on the Selection tab.

Select All

Click this button to select the check box in the Select column for all displayed journal entries.

Deselect All

Click this button to clear the check box in the Select column for all displayed journal entries.

Send Journal Entries

Click this button to send journal entries for which the check box is selected in the Select column. When you click this button, the selected journal entries are sent to an .xml files in the export folder set up in Ledger Maintenance. You can then move the file to an external database and import the journal entries in General Ledger Transaction Import.

Create Journal Entries

Click this button to create destination journal entries for source journal entries for which the check box is selected in the Select column. Use this button to create journal entries if the destination ledger is not set up to create real-time journal entries. You can also use this button to create journal entries that previously failed to be created because of errors (after you have corrected the cause of the errors).

Import

Click this button to display General Ledger Transaction Import, which allows you to import general ledger transactions.

Void Journal Entries

Click this button to void unposted journal entries for which the check box is selected in the Select column.

Void Transactions

Click this button to void journal transactions for which the check box is selected in the Select column. If you void journal transactions, you can recreate the transactions in Consolidation Journal Rebuild.

Select Tab Fields and Buttons

Field or Button

Description

All Ledgers (Source)

Select this check box to display journal entries for all source ledgers. This check box is selected by default.

Source Ledger ID

Enter a source ledger ID for which to display journal entries, or click the Lookup button to select a source ledger ID. This field is only enabled if you clear the All Ledgers check box to the left of it.

All Ledgers (Destination)

Select this check box to display journal entries for all destination ledgers. This check box is selected by default.

Destination Ledger ID

Enter a destination ledger ID for which to display journal entries, or click the Lookup button to select a destination ledger ID. This field is only enabled if you clear the All Ledgers check box to the left of it.

All Posting Sequences

Select this check box to display journal entries for all posting sequences. This check box is selected by default.

From (Posting Sequence)

Enter the first posting sequence in a range of posting sequences for which to display journal entries, or click the Lookup button to select a posting sequence. This field is only enabled if you clear the All Posting Sequences check box.

To (Posting Sequence)

Enter the last posting sequence in a range of posting sequences for which to display journal entries, or click the Lookup button to select a posting sequence. This field is only enabled if you clear the All Posting Sequences check box.

All Posting Periods

Select this check box to display journal entries for all posting periods. This check box is selected by default.

From (Posting Period)

Enter the first posting period and year in a range of posting periods and years for which to display journal entries, or click the Lookup buttons to select a period and year.

To (Posting Period)

Enter the last period and year in a range of posting periods and years for which to display journal entries, or click the Lookup buttons to select a period and year.

All Statuses

Select this check box to display journal entries of all statuses. This check box is cleared by default.

Ready to Create

Select this check box to display journal entries for which destination ledger journal entries are ready to be created. This check box is selected by default.

Ready to Send

Select this check box to display journal entries that are ready to be sent to an external ledger. This check box is selected by default.

Sent

Select this check box to display journal entries that were previously sent to an external ledger. This check box is cleared by default.

Dest JE Created

Select this check box to display journal entries for which destination ledger journal entries were created. This check box is cleared by default. This check box is selected by default.

Dest JE Failed

Select this check box to display journal entries for which destination ledger journal entries failed to be created.

Dest JE Posted

Select this check box to display journal entries for which destination ledger journal entries were posted. This check box is cleared by default.

Voided

Select this check box to display journal entries for which journal transactions were voided. This check box is cleared by default.

Results Tab Fields and Buttons

Field or Button

Description

Journal Entries

This grid displays journal entries after you click the Show Data button in the ribbon, based on the criteria selected on the Select tab. Select the check box in the Select column to select a journal entry to process.

Double-click a journal entry to display Consolidation Journal Entry Detail, which allows you to view source and destination journal entries for a selected journal entry (and any errors that may have occurred).