Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 52 Next »

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.

OptionDescription
Default Search Options
Entity NameSpecifies the unique account description for the entity to query.
Src NameSpecifies the name of the interface source. You can accept the default based on the Entity Name and Entity ID field values.
Cash BalanceSpecifies 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 BasisSpecifies the accounting basis used by the entity. If there are multiple bases, select a basis from the list.
Base CurrencyDisplays the currency that the entity uses for accounting purposes.
Cash Balance Date TypeIndicates 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 BalanceIndicates 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 DateSpecifies 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 DateSpecifies the end date for which you want to view rejection and corporate action activity.
Trade Activity Start DateSpecifies 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 DateSpecifies the end date for which you want to view trade activity.
Include Zero HoldingsDetermines 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 DateSpecifies 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 DateSpecifies the end date to view income activity.
Max Items CompositeSpecifies the maximum number of rows of data to return.
Page RowsSpecifies the number of rows to return in the grid, up to the maximum specified in the Max Items Composite field.
Additional Search Options
Entity IDSpecifies the unique account identifier for the entity to query. This is the primary key to the Entity table.
Custodian BankSpecifies the name of the custodian bank associated with a bank account relationship.
Custodian Bank CodeSpecifies the code value, or short name, used to identify the custodian bank holding the assets for a bank account relationship.
  • No labels