Menu Path: General Ledger Consolidated Ledger Management Consolidation Journal Management
Track and process journal entries in source and destination ledgers.
Use Consolidation Journal Management to process journal entries for source and destination ledgers.
To process consolidation journal entries:
Select filter criteria for the journal entries you want to process.
Click the Show Data button in the ribbon. The Results tab displays journal entries based on the criteria you selected in step 1.
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.
Use the ribbon buttons to process the selected journal entries:
If you want to export selected source ledger journal entries to an external ledger, click the Send Journal Entries button in the ribbon.
If you want to create destination ledger journal entries for selected source ledger journal entries, click the Create Journal Entries button in the ribbon.
If you want to void selected unposted destination ledger journal entries, click the Void Journal Entries button in the ribbon.
If you want to void journal transactions for selected journal entries, click the Void Transactions button in the ribbon.
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. |
Field or Button |
Description |
Select this check box to display journal entries for all source ledgers. This check box is selected by default. |
|
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. |
|
Select this check box to display journal entries for all destination ledgers. This check box is selected by default. |
|
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. |
|
Select this check box to display journal entries for all posting sequences. This check box is selected by default. |
|
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. |
|
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. |
|
Select this check box to display journal entries for all posting periods. This check box is selected by default. |
|
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. |
|
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. |
|
Select this check box to display journal entries of all statuses. This check box is cleared by default. |
|
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. |
|
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. |
|
Select this check box to display journal entries that were previously sent to an external ledger. This check box is cleared by default. |
|
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. |
|
Select this check box to display journal entries for which destination ledger journal entries failed to be created. |
|
Select this check box to display journal entries for which destination ledger journal entries were posted. This check box is cleared by default. |
|
Select this check box to display journal entries for which journal transactions were voided. This check box is cleared by default. |
Field or Button |
Description |
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). |