Create Trade Exception Report

You can use the Trade Recon console to create a total summary and detail report of trade match exceptions and drill down to the activity detail within a security. Results are based on the TRADE_EXCEPTION table in the MSGCENTER database.

Create the Total Trade Summary Report

You can use the Trade Summary report to total trade recon exceptions by date range, entity, and data source.

To create the Total Trade Summary report:

From the Trade Recon console, double click Total Trade Summary in the left pane.
Click the Total Trade Summary tab.
You see the Total Trade Summary panel.
Complete the fields on the Total Trade Summary panel.
Click Search.
You see the Total Trade Summary report.

On this page

Query Total Trade Summary Panel Options

The following describes the key options on the Query Total Trade Summary panel.

Option	Description
Entity Query Based On	Specifies the Entity list to filter query results. Or, you can select by composite entity ID to roll up all entities in the composite to the security level.
Select by Effective Date	Specifies whether an exact date or date range is used to filter query results. Options include: Exact Value (Default) Range
Effective Date	Specifies the effective date to exactly match to query results. To use this option, you must select Exact Value as your effective date selection.
Start Effective Date	Specifies the low effective date in a date range to include in query results. To use this option, you must select Range as your effective date selection.
End Effective Date	Specifies the high effective date in a date range to include in query results. To use this option, you must select Range as your effective date selection.
Right Source Name	Specifies the custodian data source to filter query results. This is the right side of the mathematical match.
Left Source Name	Specifies the second data source to filter query results. This is the left side of the mathematical match.
Query Based On	Specifies additional filter to use for query results. Options include Primary Asset ID, Issue Name, and Xref ID.
Max Items	Specifies the maximum number of result records that are returned for viewing. Default is 100 records.

Create the Trade Recon Exceptions Report

You can use the Trade Recon console to review trade exceptions and identify data warehouse breaks on trade records from different sets of data sources, such as Eagle Accounting and custodians.

To review trade recon exceptions:

From the Trade Recon console, double click Trade Recon Exceptions in the left pane.
Click the Trade Recon Exceptions tab.
You see the Trade Recon Exceptions panel.
Complete the fields on the Trade Recon Exceptions panel.
Click Search.
You see the Trade Recon Exceptions report.
You can correct breaks by entering new trades, cancel and rebooking old trades, processing corrected trade records from external custodian sources, and then resubmitting the Recon Trade Event panel to reconcile the additional information.
NOTE: You can automatically close/delete comments by selecting the Close Comments option on the Run Assignment Rule dialog box.

Trade Recon Exceptions Panel Options

The following describes the key options on the Trade Recon Exceptions panel.

Option	Description
Status	Specifies the status of the trade activity match to filter query results. Options include: Matched Matched With Tolerance Manual Recon Out-of-Balance Error Unmatched
Start Date	Specifies the low date to include in trade activity query results.
End Date	Specifies the high date to include in trade activity query results.
Entity Query Based On	Specifies the entity qualification to use to filter query results. Options include: Entity ID/Entity Composite ID Process Center Entity List All Entities
Entity ID	Specifies the Entity ID to filter query results. Available when Entity Query Based On is set to Entity ID.
Query Based On	Specifies the security qualification to use to filter query results. Options include: Primary Asset ID Issue Name (Default) Xref ID
Primary Asset ID	Specifies the asset identifier to filter query results. Available when Query Based On is set to Primary Asset ID.
Issue Name	Specifies the issue name to filter query results. Available when Query Based On is set to Issue Name.
Xref Type	Specifies the security xreference type to use to filter query results. Available when Query Based On is set to Xref ID.
Xref ID	Specifies the security xreference for the Xref ID type to filter query results. Required when Query Based On is set to Xref ID.
Assigned to User	Specifies the assigned user ID to filter query results.
Assigned to Group	Specifies the assigned user group to filter query results.
Has comments	Indicates whether the exception record has comments to filter query results.
Left source	Specifies the left data source to filter query results.
Right source	Specifies the right data source to filter query results.
Category	Specifies the comments category to filter query results.
Sub category	Specifies the comments sub category to filter query results.
Max Rows	Specifies the maximum number of result records that are returned for viewing. Default is 100 records. You can also qualify report results by transaction code, is approved (yes/no), and custom xref type.