The Unbalanced Orders Summary report displays all orders with a balance owing and/or a credit balance. You can use this report to determine which orders are not completely balanced. Once displayed, you can click the order numbers to access the order and get more details on the out-of-balance orders. This is particularly useful for end of day balancing to ensure that no orders have been created erroneously.
|
Information If unpaid reasons are required, any blank unpaid reasons will indicate that customers made their purchases using online payment plans. |
Criteria
The following table describes this report’s criteria:
Criteria |
Description |
Series |
Filters the report by the 'Series Name' defined on the Event Configuration - Events|Basic page. |
Event Code |
Filters the report by a specific event. Click |
Balance Due Date Format |
Specifies the date to use for the report: •Date Range •Previous 7 Days (excluding today) •Today •Yesterday |
Balance Due From |
Filters for those orders with a balance due date on or after the date entered. Any value entered into this field will only apply if Date Range is used. Click Your entry will be ignored if you do not enter a 'Balance Due Date To' date. |
Balance Due To |
Filters for those orders with a balance due date on or before the date entered. Any value entered into this field will only apply if Date Range is used. Click Your entry will be ignored if you do not enter a 'Balance Due Date From' date. |
Report Output by |
Filters the report by: •All Unbalanced Orders •Overpaid Orders •Underpaid Orders |
Advanced Section
The following criteria is available in the advanced section:
Criteria |
Description |
User Role |
Filters by the selected user role(s.) This is the user who last updated the order. |
User Role Group |
Filters by the selected user role group(s). This is the user role group who created or updated the order to place it in an allocated or deallocated state. |
Events From |
Filters for those events that occur on or after the date entered. Your entry will be ignored if you do not enter a value for 'Events To' date. Click |
Events To |
Filters for those events that occur on or before the date entered. Your entry will be ignored if you do not enter a value for 'Events From' date. Click |
Output
The following table describes the report’s output:
Column |
Description |
Order # |
The order number associated with the unbalanced order. Click the order number to view the order details. Links will not function if you email or download the HTML version of the report. |
Cust # |
The customer associated with the unbalanced order, if any. Click the customer number to view the customer’s account. Links will not function if you email or download the HTML version of the report. |
Customer/Organization Name |
The customer’s name and associated organization, if any. |
First Event Date |
The date of the earliest event on the order. |
Balance Due Date |
The date that the outstanding balance is due. |
Order Value |
The total value of the order. |
Payments to Date |
The total payments that have been made on the order. |
Balance Due/Over Payment |
The outstanding balance or balance owed. |
