Define Entity Bank Relationships (Local only)

Owned by Tom Fahey (Unlicensed)
Last updated: Oct 04, 2016 by Former user (Deleted)
2 min read

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 when loaded by custodian message streams.

To define an Entity Bank Relationship:

  1. From the Accounting Center window, click Accounts and then click Account Setup and Maintenance and Entity-Custodian Relationships.
  2. Double click Add Entity Bank Relationship.
    You see the Add Entity Bank Relationships panel.
  3. Complete the options on the panel.
  4. Click Submit.

The Code Values table stores custodian bank codes using code category CUSTODIAN_BANK.

Configure the MSGSERVICE.INI Parameters

The MSGSERVICE.INI configuration file sets key variables used by the Cash Recon console and associated message streams. The configuration file is located in the Eagle STAR Config Files/Configuration Files/msgcenter webserver folder and the Cash Recon parameters are located in the [CASHRECON] section of the file.

To view/edit the file MSGSERVICE.INI configuration file:

  1. From the Accounting Center window, click Reconciliation.
  2. Click Admin and Administration.
  3. Double click Engine Manager.
    You see the Engine Manager application window.
  4. In the left pane, navigate to the folder path and filename with the MSGSERVICE.INI configuration file.
  5. Open the file for editing.
  6. Complete the options in the [CASHRECON] section of the configuration file.
  7. Click Save.
    You must exit and then re-open the Cash Recon console to acquire the new configuration options.

[CASHRECON] Section Options

The following CASHRECON options configure the behavior of the Cash Recon console:

  • DataSetOption. Specifies the mode of comparison for Cash reconciliation. Refer to the Decide on the Mode of Comparison section for additional information.
  • LoadSTARActivityStream. Specifies the stream to load pre-settled activity.
  • LoadCUSTActivityStream. Specifies the stream to load custodian CSV files.
  • LoadSettledActivityStream. Specifies the stream to load settled activity.
  • MatchStream. Specifies the stream to match cash records from two sources on local tables in the MSGCENTER database.
  • ResultsStream. Specifies the stream to post exceptions and establish downstream messages to adjust settled cash.
  • AddCashStream. Specifies the stream to add cash transactions equal to the custodian cash transaction amount.
  • RecPayStream. Specifies the stream to load pre-settled cash activity.
  • CashTranStream. Specifies the stream to load settled cash activity.
  • MatchStreamWH. Specifies the stream to match cash records from two sources on the CASH_ACTIVITY tables in the CASH database or one source and the ESTAR database traded/settled cash activity tables.