The General Ledger Oracle 1 report is a variation of the core General Ledger report, allowing you to import information into Oracle or Oracle-based reports like PeopleSoft. It has a summary line per 'GL Code' where transactions occurred for the given date. Transactional information on all sales and payments plus some predefined fields will be included for all items.
The report includes GL information for all items provided that the 'GL Code 1', 'Receivable GL Code', 'GL Description1' and 'GL Description2' fields have been populated in the following areas:
•Event Configuration - Events|Basic page for all events
•General Configuration - Payment Methods|Basic page for all payment methods (does not have a 'Receivable GL Code' field)
•Product Configuration - Charges|Details page for all charges
•Product Configuration - Miscellaneous Items|Details page for all miscellaneous items
•Product Configuration - Stored Value Items|Details page for all stored value items
•Funds Management - Funds|Details page for all funds
Criteria
Criteria |
Description |
Transaction Date Format |
Specifies the date to use for the report: •Date Range •Previous 7 Days (excluding today) •Today •Yesterday |
Transaction From |
Filters for those transactions that occur on or after the date entered. Your entry will be ignored if you do not enter a value for 'Transactions To' date. Click |
Transaction To |
Filters for those transactions that occur on or before the date entered. Your entry will be ignored if you do not enter a value for 'Transactions From' date. Click |
Include Unallocated/Receivable Items? |
•Yes: Displays both the unallocated and receivable items •No: Does not display the unallocated or receivable items |
Display Headers |
•Yes: The header row is displayed •No: The header row is not displayed |
Output
|
Information Many of the output values in this report are static. You can configure these static values in the Registry - Registry::EN::Application::Business Intelligence and Reports::Report Labels::General Ledger Oracle 1::Oracle Values node. |
The report output contains the following information:
Column |
Description |
Status Code |
Display Value: New |
Ledger ID |
Display Value: 300000006578514 |
Effective Date of Transaction |
The date of the transaction. |
Journal Source |
Display Value: External |
Journal Category |
Display Value: AudienceView |
Currency Code |
Display Value: USD |
Journal Entry Creation Date |
Display Value: "Generated on” <date the report was run expressed as YYYY/MM/DD> |
Actual Flag |
Display Value: A |
Segments 1-4 |
Displays the first GL description. |
Segment 5 |
Displays the second GL description. |
Segment 6 |
Display Value: 00000 |
Segment 7 |
Display Value: 00000 |
Segment 8 |
Display Value: 00000 |
Segment 9 |
Blank |
Segment 10 |
Blank |
Segment 11 |
Blank |
Segment 12 |
Blank |
Segment 13 |
Blank |
Segment 14 |
Blank |
Segment 15 |
Blank |
Segment 16 |
Blank |
Segment 17 |
Blank |
Segment 18 |
Blank |
Segment 19 |
Blank |
Segment 20 |
Blank |
Segment 21 |
Blank |
Segment 22 |
Blank |
Segment 23 |
Blank |
Segment 24 |
Blank |
Segment 25 |
Blank |
Segment 26 |
Blank |
Segment 27 |
Blank |
Segment 28 |
Blank |
Segment 29 |
Blank |
Segment 30 |
Blank |
Entered Debit Amount |
Displays the total debits for each of the GL codes. |
Entered Credit Amount |
Displays the total credits for each of the GL codes. |
Converted Debit Amount |
Blank |
Converted Credit Amount |
Blank |
REFERENCE1 (Batch Name) |
Blank |
REFERENCE2 (Batch Description) |
Blank |
REFERENCE3 (Batch Description) |
Blank |
REFERENCE4 (Journal Entry Name) |
Blank |
REFERENCE5 (Journal Entry Description) |
Display Value: woh dep <transaction date expressed as YYYY/MM/DD> |
REFERENCE6 (Journal Entry Reference) |
Blank |
REFERENCE7 (Journal Entry Reversal Flag) |
Blank |
REFERENCE8 (Journal Entry Reversal Period) |
Blank |
REFERENCE9 (Journal Reversal Method) |
Blank |
REFERENCE10 (Journal Entry Line Description) |
GL Code |
Status Code |
Display Value: END |
