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:
In Accounting Center, in the left navigation pane, click Reports > Position Viewer.
You see the Position Viewer workspace.Â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.Complete the search criteria.
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 |
---|---|
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:
|
Position Type | Allows you to view position information for the current day or as of a point in time. Options include:
|
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:Â
|
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:
|
Display Zero Cash Balance | Indicates whether to include zero cash balances. A zero cash balance is a valid balance. Options include:
|
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:
|
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. |
Â