Reports on payments and payment allocations to sellable items, with an output format designed to be exported to an Oracle General Ledger system. Use Day of Sale mode to report on payments and allocations which happened on the selected days. Use Day of Event mode to report on allocations for events, charges and miscellaneous items with start dates on the selected days. Day of Event mode is designed for recognizing revenue on the day of the event.
The report includes GL information for all items provided that the 'GL Code 1', 'GL Code 2' (when the 'Report Mode' is set to Day of Event), 'Receivable GL Code' (when 'Report Mode' is set to Day of Sale), '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 |
Report Mode |
The report returns payments and payment allocations to sellable items, and can be run in two modes: •Day of Sale: The report returns payments processed in the selected date range as debits, and allocations to sellable items in the selected date range as credits. The value from the 'GL Code 1' field for the items is displayed for each row. •Day of Event: The report returns payment allocations made to events, event charges and miscellaneous items which have start dates in the selected date range. The items are displayed once as debits along with 'GL Code 1', and as credits along with 'GL Code 2'.
Day of Event mode is designed for organizations who want to recognize event, charge and miscellaneous item revenue on the day of the event rather than on the day of the sale. For these items, the GL code used to indicate deferred revenue on the day of sale should be entered in 'GL Code 1', and the GL code used to indicate recognized revenue on the day of the event should be entered in 'GL Code 2'. The report can then be run twice daily - once in Day of Sale mode, to capture deferred revenue for that day, and again in Day of Event mode, to capture revenue moving from the deferred account to the recognized account for events taking place that day. |
Sales Mode |
Filters the report by the values that you want to display: •Paid: Items that have been paid for. •Sold: Items that are on an order, but have not been paid for (the customer will pay for the ticket when he/she picks it up at will call). |
Date Format |
Specifies the date(s) to use for the report: •Date Range •Previous 7 Days (excluding today) •Today •Yesterday |
Date From |
Filters for those sales that occur on or after the date entered. Your entry will be ignored if you do not enter a value in the 'Date To' field. Click |
Date To |
Filters for those sales that occur on or before the date entered. Your entry will be ignored if you do not enter a value for in the 'Date From' field. Click |
Show Detail? |
Enables you to view detailed allocation information: •Yes: Displays order number and one row per GL code per order •No: Displays one row per GL code |
Display Headers |
•Yes: The header row is displayed •No: The header row is not displayed |
Suppress Items with No GL Code |
•Yes: Items that do not have GL Codes will not be displayed. •No: All items will be displayed. |
