Match Positions, Ledger Balances, and Lots

Recon Center allows you to reconcile positions, ledger balances, and lots. You can use the Position Recon console to trigger the match process using tolerance rules and match profiles. Or, you can use a recon position event to manually trigger reconciliation for model office testing and quality assurance purposes. You can use customized Run Match Now streams to implement the match and reconciliation process for the production cycle. The position, ledger, and lot match results are posted to the MSGCENTER database in their respective POSITIONS_RESULTS, LEDGER_BALANCES_EXCEPTIONS, and LOTS_BALANCES_EXCEPTIONS tables.

Match Using the Position Recon Console

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.

On this page

1 Match Using the Position Recon Console
2 Match Using Recon Event Panels
3 Match Using Run Match Now Streams

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.

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 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 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 page for details about the position lot options.
Click Submit.

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.

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.