Previous  Next          Contents  Index  Navigation  Glossary  Library

Journal Import Execution Report

Review the status of accounting data you import from external feeder systems, such as accounts payable, purchasing and so on.

The report prints a line for each journal entry source from which you import accounting data. Each line includes the source name, the group ID, whether the import was successful, the total number of journal lines, batches, and entries, the number of unbalanced batches and entries, and the total number of errors. For each batch created, the report prints the batch name, period name, total lines, total entries, and total accounted debits and credits.

The report prints similar information for batches posted to suspense due to flexfield errors, unbalanced journals which were not imported, error journal lines, and invalid accounts. Each line of these Exception sections includes an error code.

General Ledger automatically generates this report when the Journal Import process completes. Note that in some cases you may not use the Import Journals form to explicitly launch the Journal Import process. For example, when entering budget journals or transferring budget amounts without budgetary control, General Ledger runs Journal Import. You may also choose to have General Ledger run Journal Import after a consolidation run.

Selected Headings

Refer to the selected heading descriptions below for additional information.

Concurrent Request ID: request ID for this set of data. General Ledger assigns a request ID to your data when you initiate the Journal Import program.

Group ID: group identification number that you specified when you ran Journal Import. General Ledger allows you to enter a unique group number when you run Journal Import to distinguish import data within a source.

Status: status of the journal source from which you imported journals. For each journal source, the status will be one of the following:

If Journal Import encounters an error in any journal line, the entire source will have the Error status.

Warning: the warning WUO1 if your batch is unbalanced and you allow suspense posting in your set of books.

Flexfield Error Code: one of the following types of account errors for each batch posted to your suspense account:

    EF01: Expired account
    EF02: Detail Posting Not Allowed
    EF03: Disabled account
    EF04: Cross Validation Rule Violation
    EF05: Invalid Code Combination ID

Accounting Flexfield: If you enter segment values for your account in the GL_INTERFACE table, the invalid account. If you enter a code combination ID instead of segment values and if suspense posting is disabled, the invalid code combination ID. If you enter a code combination ID and if suspense posting is enabled, only the segment value separators. Therefore, we recommend that you disable suspense posting if entering code combination IDs.

Error Key Column Headings

General Ledger prints the error codes and an explanation for all errors that could have interfered with the Journal Import process in the Error Key section of the Journal Import Execution Report.

See Also

Importing Journals


         Previous  Next          Contents  Index  Navigation  Glossary  Library