Search Position Data for All Custodian Banks and One Security

In the Position Viewer tool, you can view position data for actual cash settlements across all custody banks for a single security. The All Custodial Banks - One Security option restricts results to the custody accounting basis used with cash segregation. The query results shows results for a single security held across all entities within a database partition. You can view unit and cash balances by both entity and custody location. If you hold a security in multiple custodian banks, you can identify the quantity for holdings associated with each custodian. You can also identify the entitlements for units or cash that are segregated at the custodian level.

To search position data for all custodial banks and one security:

  1. In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
    You see the Position Viewer workspace.

  2. In the Search type list, select All Custodial Banks - One Sec.
    In the Search Details pane, you see the search criteria for the selected search type. When you select this option, you cannot choose an entity. The Account Basis field displays a value of CUST, indicating that you are viewing results for the custody accounting basis across all entities. The custody basis is the entity's accounting basis that has its Position Cash Segregation Basis field set to Yes to enable cash segregation. Additional fields appear where you can specify issue criteria.

  3. Complete the search criteria.

  4. Click the Search button.
    You see the selected search criteria in the header area. You see the search results in the grid. The grid shows a row for each custody location where you hold the security. The Custodian Bank Code column and the Custody Bank Acct Num column identify the custody location. You can also view the Account and Units for the holding at the custody location.

  5. View the cost, cash, and Income position data. 
    In the Reports pane, you can review the Cost, Cash, and Income objects for the position for each custodial bank that met your criteria for the selected security.

The following example shows the search results when you select the All Custodial Banks - One Security option for a security held in multiple custody locations. For a single security, you can have holdings for multiple entities/accounts in multiple custodian bank code/custody bank account number groupings.

Position Viewer - All Custodial Banks One Security