ou You must set up the entity lists, data sources, out of balance tolerances, and entity bank relationships for use during the reconciliation of positions, ledger balances, and lots. You must also configure the MSGSERVICES.INI parameter file to control the functionality made available by the Position Recon console for triggering streams and querying results.

...

You can define entity lists and composite entities to control the scope of Eagle Accounting, custodian, and data warehouse holdings and ledger balances to reconcile. Entity lists are static lists containing PORT entity types. You can use the Entity List Manager to create entity lists and composite entities that control the position reconciliation process; however, you can not control the reconciliation process using dynamic lists.

To access the Entity List Manager tool:

...

You must define the data sources to use before loading records for reconciliation. The data sources identify the positions, ledger balances, and lots data to audit for any portfolio and entity list. When position reconciliation compares two sets of competing records, the process chooses records by data sources for the left side and the right side of the mathematical comparison.

To define data sources to use during Position reconciliation:

...

NOTE: You can group a set of sources using the code value tables for a specific Code Category, such as POSREC_SRCS. A set of custodians, such as CUSTODY1 and CUSTODY2, can be defined for use as a unified set of sources by adding the sources as code values under the category, along with a name to use as the name of the list. The set of sources is called a named list of sources and the data associated to the set of sources can be used as one side of the match. On the code values record serving as the name of the list, you must set the Code Value Description to L.

The following table list examples of data sources used with position reconciliation.

...

Anchor
_Toc439930427 _Toc439930427

Define Exception Assignment Rules

You can create exception assignment rules to simplify the workflow to automatically identify breaks based on entity or security attributes and then take the appropriate actions, such as, apply comments, categorize explained differences, and assign unexplained differences to users or user groups for resolution. Once created, you can execute these rules from the Position Recon console or execute in a message stream following the Run Match Now stream.

To define an exception assignment rule:

...

You must define entity bank relationships when Custodian cash activity records contain internal custodian account numbers requiring translation to the Eagle Accounting entity id values. For a given custodian bank code, the Entity Bank Relationship feature provides a unique mapping for a custodian account to an Eagle STAR entity ID. The entity bank relationship mappings are required when using the local MSGCENTER tables loaded by custodian message streams.

To define an Entity Bank Relationship:

...