You can use the Tools menu options on the Position Recon console to match and reconcile positions, ledger balances, and lots for a given effective date. You can create and reuse profiles to specify the match and tolerance criteria, including the tolerance rules, the entities, and the effective date of records to reconcile.
To match and reconcile positions, ledger balances, and lots from the Position Recon console:
- Confirm that the positions data to reconcile is available in the positions locations expected for your mode of comparison, before using the Position Recon console to schedule the recon message streams:
– Warehouse tables for positions, lots, and ledger balances. You must confirm that all data uploaders with records from external sources have completed. You can view the Message Center console (MCC) file processing statistics for load streams to check record counts and completion statuses. If using STARDIRECT warehouse records, you must confirm that the STAR to PACE Direct batch process has completed for the positions, lots, or ledger balances, for the portfolios you want to reconcile.
– Local tables (Positions only). You must confirm that all required message streams to load position records to work tables have completed. You can use the Positions report and the Custody Positions report to view the loaded work tables for reasonableness and completion. - From the Position Recon console, click Tools and then click Run Match Positions, Run Match Ledger, or Run Match Lot, depending on the reconciliation you want to execute.
You see the Run Match Now dialog box.
NOTE: You can click the Matching Profile drop down and select a previously saved set of options for reuse. - Click the Left Source drop down and select the data source for the left side of the match.
- Click the Right Source drop down and select the data source for the right side of the match.
- Click Date and select the business date for the records to match.
- Click the Tolerance Rule drop down and select the tolerance rule you want to apply before applying the tolerances specified in the Run Match Now default message stream. For example, you can create tolerance rules to control reconciling positions, ledger balances, and lots for records based on security types or entities.
- Set Scope with the entity criteria for the records to reconcile.
Options include:
– All Entities. Reconcile all entities.
– Process Center. Reconcile by process center.
– Entity List. Reconcile by entity list.
– One Entity. Reconcile by entity. - Click Save to store these options as a matching profile for reuse with this dialog box.
- Click Submit.
You see the stream specified by the corresponding Match Stream option in the MSGSERVICE.INI file submitted to Message Center for processing.
Anchor |
---|
| 1posrecn_match_positions_htm_mat_6875 |
---|
| 1posrecn_match_positions_htm_mat_6875 |
---|
|
Anchor |
---|
| _Toc439930446 |
---|
| _Toc439930446 |
---|
|
Match Using Recon Event Panels
You can use recon event panels to match and reconcile positions, ledger balances, and lots for a given effective date.
To reconcile positions, ledger balances, and lots using Recon Event panels:
- From the Accounting Center window, select Reconciliation in the left navigation and then click Position Recon and Recon Events.
- To reconcile positions, double click Recon Positions and complete the Recon Position event panel options. See the Recon Event Panel Options section page for details about the position options.
- To reconcile ledger balances, double click Recon Ledger and complete the Recon Ledger event panel options. See the Recon Event Panel Options section page for details about the ledger balance options.
- To reconcile lots, double click Recon Lots and complete the Recon Lots event panel options. See the Recon Event Panel Options section page for details about the position lot options.
- Click Submit.
Anchor |
---|
| _Toc439930447 |
---|
| _Toc439930447 |
---|
|
Match Using Run Match Now Streams
You can use Run Match Now message streams to perform the match and reconciliation using Message Center services.
To match and reconcile positions using a Run Match Now message stream:
- From the Message Center console, click Message Streams.
You see the Msg Stream Query dialog box. - Enter Position in the Title text box.
- Click Search.
You see the list of message streams with titles starting with the character string in the text box. - Select the Run Match Now message stream you want to execute.
NOTE: You can copy, rename, and customize the Eagle default message streams and then establish the custom stream as the Run Match Now default option using MSGSERVICE.INI parameters. The following are the Eagle default message streams:
– Position-match-db. The default Positions match stream.
– Position-match-db-ledgerbalance. The default Ledger Balances match stream.
– Position-match-db-lots. The default Lots matching stream. - Right click Run Now.
You see the message stream submitted for execution.
Note |
---|
Eagle recommends storing only out of balance exceptions to conserve database storage. You can elect to store only out of balance exceptions by setting IVAR_INT_7250 (tag 7250) field to 1 in the Message Center runmatch-db2 rule of the position matching stream. |
Anchor |
---|
| 1posrecn_recon_event_opts_htm_to_6840 |
---|
| 1posrecn_recon_event_opts_htm_to_6840 |
---|
|