Search Position Data for One Portfolio

In the Position Viewer workspace, you can select a Search type of One Portfolio to review Cost, Cash, and Income position data based on a single entity.

To search position data for one portfolio:

  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, ensure One Portfolio is selected.
    The Search Type option has a value of One Portfolio by default. In the Search Details pane, you see the search criteria for the selected search type.

  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. 

One Portfolio - Search Options

The following are the options in the Search Details pane of for a Search type of One Portfolio in the Position Viewer workspace.

Option

Description

Option

Description

Default Search Options

 

Entity Name

Specifies the unique account description for the entity to query.

Src Name

Specifies the name of the interface source. You can accept the default based on the Entity Name and Entity ID field values.

Cash Balance

Specifies the cash balance as of date. Available options include:

  • Settlement Date. Returns cash balances as of the settlement date.

  • Trade Date. Returns cash balances as of the trade date.

Position Type

Allows you to view position information for the current day or as of a point in time. Options include:

  • Current. Default. Allows you to view all positions as of the current day. You can view every transaction that processed regardless of date. The position data can potentially be for a future accounting date.

  • AS OF. Allows you to view positions for a specified date. When you select this option, additional options appear. You specify a date range and set the Summary View field to As Of Summary.

As Of Start Date

Specifies the As Of start date. You can use the default value. This field appears if you set the Position Type field to AS OF.

As Of End Date

Specifies the As Of end date. The date you specify allows you to view the position as of a certain historical date. The default value is the current day. This field appears if you set the Position Type field to AS OF.

Summary View

Indicates whether the position results reflect transactions up to the current date or up to a specified date. This field appears if you set the Position Type field to AS OF. The summary view you select affects the Cost position results that appears in the upper grid of the Position Viewer workspace. Options include: 

  • As Of Summary. Uses a point in time query that rolls back all the positions to the date provided. The results for the position take every transaction that processed up to the date provided.

  • Current Summary. Default. The results for the position take every transaction that processed up to the current day, excluding any transactions with a future date.

Bypass Cost Recalculation

If you previously encountered error 240, this option indicates whether to bypass the recalcCost function in the accounting engine. If you run an As Of cost query against positions that are out of sync between the lot level units and position units, and you encounter error 240, which prevents you from researching the problem in Position Viewer, you can set this option to Yes to view position data by bypassing error 240: Function- recalcCost; Original open quantity - close quantity +/- adjusted quantity. This field appears if you set the Position Type field to AS OF. Available options include Yes and No (Default).

Account Basis

Specifies the accounting basis used by the entity. If there are multiple bases, select a basis from the list.

Base Currency

Displays the currency that the entity uses for accounting purposes.

Cash Balance Date Type

Indicates the date type of cash balance record you want to view. Options include:

  • Posting date (Default)

  • Trade date

  • Accounting date

  • Contractual settlement date

  • Month end date

Display Zero Cash Balance

Indicates whether to include zero cash balances. A zero cash balance is a valid balance. Options include:

  • Yes. Default. The results include zero cash balance records for the specified cash position and asset currency.

  • No. The results exclude zero cash balances.

Rejection/Corporate Actions Begin Date

Specifies the begin date for which you want to view rejection and corporate action activity. If you specify a range, you exclude activity that occurred outside this date range from the Rejections and Corporate Action detail tabs in the Cost object.

Rejection/Corporate Actions End Date

Specifies the end date for which you want to view rejection and corporate action activity.

Trade Activity Start Date

Specifies the begin date for which you want to view trade activity. If you specify a range, you exclude trade activity that occurred outside this date range from the Trade Activity detail tab in the Cost object.

Trade Activity End Date

Specifies the end date for which you want to view trade activity.

Include Zero Holdings

Determines whether zero holdings appear in the query result. Available options include:

  • No. Do not include these holdings in the query result.

  • Yes. Include these holdings in the query result.

Income Report Start Date

Specifies the begin date to view income activity. If you specify a range, you exclude income activity that occurred outside this date range from the Income object.

Income Report End Date

Specifies the end date to view income activity.

Max Items Composite

Specifies the maximum number of records in rows of data to return for your search criteria. Your Center Role determines the default value that appears. If your Center Role allows it, you can change the default value to a lower number of rows, but you cannot exceed the default value. 

Additional Search Options

 

Entity ID

Specifies the unique account identifier for the entity to query. This is the primary key to the Entity table.

Custodian Bank

Specifies the name of the custodian bank associated with a bank account relationship.

Custodian Bank Code

Specifies the code value, or short name, used to identify the custodian bank holding the assets for a bank account relationship.

Â