This section describes the following multiperiod Accounting reports:
Multiperiod Accounting and Accrual Reversal Report: Created when user runs the Create Accounting program and displays accrual, recognition, and accrual reversal journal entries
Multiperiod Accounting Report (summary or detail): Created when user runs the Complete Multiperiod Accounting program and displays recognition and accrual reversal entries processed by the program
For information on submission parameters, seeCreate Accounting Program.
Note: Not all data elements have a corresponding field on the seeded multiperiod and accrual reversal report templates.
Multiperiod Accounting and Accrual Reversal Report Level Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Source Application | SOURCE_APPLICATION | Source Application value from Create Accounting request parameter |
| Application | APPLICATION | Subledger Application value from Create Accounting request parameter |
| End Date | END_DATE | End Date value from Create Accounting request parameter; processes only those events with event dates on or before the end date |
| Process Category | PROCESS_CATEGORY | Process Category value from Create Accounting request parameter; restricts the events for accounting to a particular process category |
| Accounting Report Level | ACCOUNTING_REPORT_LEVEL | Accounting Report Level value from Create Accounting request parameter |
| Create Accounting | CREATE_ACCOUNTING | Create Accounting value from Create Accounting request parameter; determines whether to create subledger journal entries |
| Errors Only | ERRORS_ONLY | Errors Only value from Create Accounting request parameter; limits the creation of accounting to those events which previously failed accounting |
| Transfer to General Ledger | TRANSFER_TO_GENERAL_LEDGER | Transfer to General Ledger value from Create Accounting request parameter; determines whether to transfer the subledger journal entries to General Ledger |
| Post in General Ledger | POST_IN_GENERAL_LEDGER | Post in General Ledger value from Create Accounting request parameter; determines whether to post subledger journal entries in General Ledger |
| General Ledger Batch Name | GENERAL_LEDGER_BATCH_NAME | General Ledger Batch Name value from Create Accounting request parameter; user-entered batch name that appears on the transferred General Ledger subledger journal entries |
Multiperiod Accounting and Accrual Reversal Report Journal Entry Summary Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Event Class | EVENT_CLASS | Accounting event class name of the subledger journal entries used to group journal entries |
| Number of Documents | NUMBER_OF_DOCUMENTS | Number of documents processed for the event class |
| Ledger | LEDGER | Ledger name of processed journal entries |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Processed | JOURNAL_ENTRIES_PROCESSED | Number of journal entries processed for each type |
| In Error | JOURNAL_ENTRIES_IN_ERROR | Number of journal entries with errors |
Multiperiod Accounting and Accrual Reversal Report Transfer to General Ledger Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Ledger | LEDGER | Ledger for which entries are transferred |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Count | JOURNAL_ENTRIES_TRANSFERRED | Number of journal entries transferred to General Ledger |
Multiperiod Accounting and Accrual Reversal Report General Error Data Elements
| Data Source Element | Template Field | Description |
|---|---|---|
| Error Number | G_ERROR_NUMBER | Error code of the accounting program error |
| Error Message | G_ERROR_MESSAGE | Error description |
Multiperiod Accounting and Accrual Reversal Report Event Level Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Event Class | EVENT_CLASS | Accounting event class name of the subledger journal entries |
| Event Type | EVENT_TYPE | Accounting event type of the subledger journal entries |
| Event Number | EVENT_NUMBER | User-oriented number to identify the events of a document |
| Event Date | EVENT_DATE | Event date of the event |
| <User Trx Identifier Prompt XX> | USER_TRX_IDENTIFIER_PROMPT_XX | Prompt values based upon setup in the Accounting Methods Builder (AMB) of Event Class Attribute User Transaction Identifiers. All identifiers set up are displayed. |
| <User Trx Identifier Value XX> | USER_TRX_IDENTIFIER_VALUE_XX | User transaction identifier XX value |
Multiperiod Accounting and Accrual Reversal Report Journal Header Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Ledger | LEDGER | Accrual journal entry ledger name |
| GL Date | GL_DATE | Accrual journal entry General Ledger date |
| Ledger Currency | LEDGER_CURRENCY | Accrual journal entry ledger currency |
| Application Accounting Definition | APPLICATION_ACCOUNTING_DEFINITION | Application accounting definition name used to create accrual journal entry |
| Application Accounting Definition Version | AAD_VERSION | Application accounting definition version of accrual journal entry |
| Journal Entry Description | JOURNAL_ENTRY_DESCRIPTION | Accrual journal entry description |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Journal Entry Status | JOURNAL_ENTRY_STATUS | Accrual journal entry status |
| Accounting Sequence Name | ACCOUNTING_SEQUENCE_NAME | Sequence name used to number the journal entry at completion time |
| Accounting Sequence Version | ACCOUNTING_SEQUENCE_VERSION | Sequence version used to number the journal entry at completion time |
| Accounting Sequence Number | ACCOUNTING_SEQUENCE_NUMBER | Sequential number assigned to the journal entry at completion time |
Multiperiod Accounting and Accrual Reversal Report Journal Entry Line Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Line Number | LINE_NUMBER | Accrual journal entry line number |
| Account | ACCOUNT | Accrual journal entry line account |
| Currency | CURRENCY | Transaction line entered currency code |
| Entered Debit | ENTERED_DEBIT | Transaction line currency debit amount |
| Entered Credit | ENTERED_CREDIT | Transaction line currency credit amount |
| Accounted Debit | ACCOUNTED_DEBIT | Ledger currency debit amount |
| Accounted Credit | ACCOUNTED_CREDIT | Ledger currency credit amount |
Multiperiod Accounting and Accrual Accounting Report Error Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Line Number | LINE_NUMBER | Error line number |
| Error Number | ERROR_NUMBER | Accounting program error code |
| Error Message | ERROR_MESSAGE | Error description |
Multiperiod Accounting Report (Detail) Report Level Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Application | APPLICATION | Subledger Application value from Complete Multiperiod Accounting request parameter |
| End Date | END_DATE | End Date value from Complete Multiperiod Accounting request parameter |
| Process Category | PROCESS_CATEGORY | Process Category value from Complete Multiperiod Accounting request parameter |
| Errors Only | ERRORS_ONLY | Errors Only value from Complete Multiperiod Accounting request parameter |
| Transfer to General Ledger | TRANSFER_TO_GENERAL_LEDGER | Transfer to General Ledger value from Complete Multiperiod Accounting request parameter |
| Post in General Ledger | POST_IN_GENERAL_LEDGER | Post in General Ledger value from Complete Multiperiod Accounting request parameter |
| General Ledger Batch Name | GENERAL_LEDGER_BATCH_NAME | General Ledger Batch Name value from Complete Multiperiod Accounting request parameter |
Multiperiod Accounting Report (Detail) Journal Entry Summary Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Event Class | EVENT_CLASS | Accounting event class name of the subledger journal entries used to group journal entries |
| Number of Documents | NUMBER_OF_DOCUMENTS | Number of documents processed for the event class |
| Ledger | LEDGER | Processed journal entries ledger name |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Processed | JOURNAL_ENTRIES_PROCESSED | Number of journal entries processed for each type |
| In Error | JOURNAL_ENTRIES_IN_ERROR | Number of journal entries with errors |
Multiperiod Accounting Report (Detail) Transfer to General Ledger Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Ledger | LEDGER | Ledger for which entries are transferred |
| Type | JOURNAL_ENTRY_TYPE | Type of journal entry:
|
| Count | JOURNAL_ENTRIES_TRANSFERRED | Number of journal entries transferred to General Ledger |
Multiperiod Accounting Report (Detail) General Error Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Error Number | G_ERROR_NUMBER | Program error code |
| Error Message | G_ERROR_MESSAGE | Error description |
Multiperiod Accounting Report (Detail) Event Level Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Event Class | EVENT_CLASS | Accounting event class name of the subledger journal entries |
| Event Type | EVENT_TYPE | Accounting event type of the subledger journal entries |
| Event Number | EVENT_NUMBER | Number to identify the events of a document |
| Event Date | EVENT_DATE | Date of the event |
| <User Trx Identifier Prompt XX> | USER_TRX_IDENTIFIER_PROMPT_XX | Prompt values based upon setup in the Accounting Methods Builder (AMB) of Event Class Attribute User Transaction Identifiers. All identifiers set up are displayed. |
| <User Trx Identifier Value XX> | USER_TRX_IDENTIFIER_VALUE_XX | Value for the user transaction identifier XX |
Multiperiod Accounting Report (Detail) Journal Entry Header Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Ledger | LEDGER | Journal entry ledger name |
| GL Date | GL_DATE | Journal entry General Ledger date |
| Ledger Currency | LEDGER_CURRENCY | Journal entry ledger currency |
| Application Accounting Definition | APPLICATION_ACCOUNTING_DEFINITION | Application accounting definition name used to create journal entry |
| Application Accounting Definition Version | AAD_VERSION | Application accounting definition version |
| Description | DESCRIPTION | Journal entry description |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Journal Entry Status | JOURNAL_ENTRY_STATUS | Journal entry status |
| Accounting Sequence Name | ACCOUNTING_SEQUENCE_NAME | Sequence name used to number the journal entry at completion time |
| Accounting Sequence Version | ACCOUNTING_SEQUENCE_VERSION | Sequence version used to number the journal entry at completion time |
| Accounting Sequence Number | ACCOUNTING_SEQUENCE_NUMBER | Sequential number assigned to the journal entry at completion time |
Multiperiod Accounting Report (Detail) Journal Entry Line Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Line Number | LINE_NUMBER | Journal entry line number |
| Account | ACCOUNT | Journal entry line account |
| Currency | CURRENCY | Journal entry line entered currency code |
| Entered Debit | ENTERED_DEBIT | Journal entry line entered currency debit amount |
| Entered Credit | ENTERED_CREDIT | Journal line entered currency credit amount |
| Accounted Debit | ACCOUNTED_DEBIT | Ledger currency debit amount |
| Accounted Credit | ACCOUNTED_CREDIT | Ledger currency credit amount |
Multiperiod Accounting Report (Detail) Error Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Line Number | LINE_NUMBER | Error line number |
| Error Number | ERROR_NUMBER | Accounting program error code |
| Error Message | ERROR_MESSAGE | Error description |
Multiperiod Accounting Report (Summary) Report Level Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Application | APPLICATION | Subledger Application value from Complete Multiperiod Accounting request parameter |
| End Date | END_DATE | End Date value from Complete Multiperiod Accounting request parameter |
| Process Category | PROCESS_CATEGORY | Process Category value from Complete Multiperiod Accounting request parameter |
| Errors Only | ERRORS_ONLY | Errors Only value from Complete Multiperiod Accounting request parameter |
| Transfer to General Ledger | TRANSFER_TO_GENERAL_LEDGER | Transfer to General Ledger value from Complete Multiperiod Accounting request parameter |
| Post in General Ledger | POST_IN_GENERAL_LEDGER | Post in General Ledger value from Complete Multiperiod Accounting request parameter |
| General Ledger Batch Name | GENERAL_LEDGER_BATCH_NAME | General Ledger Batch Name value from Complete Multiperiod Accounting request parameter |
Multiperiod Accounting Report (Summary) Journal Entry Summary Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Event Class | EVENT_CLASS | Accounting event class name of the subledger journal entries used to group journal entries |
| Number of Documents | NUMBER_OF_DOCUMENTS | Number of documents processed for the event class |
| Ledger | LEDGER | Processed journal entries ledger name |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Processed | JOURNAL_ENTRIES_PROCESSED | Number of journal entries processed for each type |
| In Error | JOURNAL_ENTRIES_IN_ERROR | Number of journal entries with errors |
Multiperiod Accounting Report (Summary) Transfer to General Ledger Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Ledger | LEDGER | Ledger for which entries are transferred |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Count | JOURNAL_ENTRIES_TRANSFERRED | Number of journal entries transferred to General Ledger |
Multiperiod Accounting Report (Summary) General Error Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Error Number | G_ERROR_NUMBER | Accounting program error code |
| Error Message | G_ERROR_MESSAGE | Error description |
Multiperiod Accounting Report (Summary) Journal Entry Header Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Ledger | LEDGER | Journal entry ledger |
| GL Date | GL_DATE | Journal entry General Ledger date |
| Ledger Currency | LEDGER_CURRENCY | Journal entry ledger currency |
| Application Accounting Definition | APPLICATION_ACCOUNTING_DEFINITION | Application accounting definition name used to create journal entry |
| Application Accounting Definition Version | AAD_VERSION | Application accounting definition version |
| Description | DESCRIPTION | Journal entry description |
| Type | JOURNAL_ENTRY_TYPE | Journal entry type:
|
| Journal Entry Status | JOURNAL_ENTRY_STATUS | Journal entry status |
Multiperiod Accounting Report (Summary) Journal Entry Line Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Line Number | LINE_NUMBER | Journal entry line number |
| Account | ACCOUNT | Journal entry line account |
| Currency | CURRENCY | Journal entry line entered currency code |
| Entered Debit | ENTERED_DEBIT | Journal entry line entered currency debit amount |
| Entered Credit | ENTERED_CREDIT | Journal entry line currency credit amount |
| Accounted Debit | ACCOUNTED_DEBIT | Ledger currency debit amount |
| Accounted Credit | ACCOUNTED_CREDIT | Ledger currency credit amount |
Multiperiod Accounting Report (Summary) Error Data Elements
| Field Name | Data Element (XML Tag) | Description |
|---|---|---|
| Line Number | LINE_NUMBER | Error line number |
| Error Number | ERROR_NUMBER | Accounting program error code |
| Error Message | ERROR_MESSAGE | Error description |