Query Cash Projections

In the Query Cash Projections panel, you can list existing cash projections. This panel executes a query based on a cash projection and provides results in a grid format. Unlike the Cash Projection Viewer workspace, this report does not allow you to choose entity lists, composites, and process centers. The panel allows you to select an entity ID, and bases all other parameters for the report on the last projection run for the selected entity.

You can use the Query Cash Projections panel in cases where you prefer not to use the Cash Projections Viewer workspace to view and report on cash projection data. Instead, you can use the Query Cash Projections panel in conjunction with the global Create Projections panel. In this scenario, you first use the global Create Projections panel to generate the cash projection for the desired date range and entity combination. Then, you use the Query Cash Projections panel to run the cash projection query for that entity.

To query cash projections:

  1. In Accounting Center, in the left navigation pane, click Reports > Cash Projections Viewer > Query Cash Projections.
    You see the Query Cash Projections panel.

  2. Complete the options in the panel. 

  3. Click Submit.
    You see the Result - Query Projections workspace. In the Show All tab, you see information for the cash projections that met your criteria. In the Input Details tab, you see your criteria.

Query Cash Projections Panel Options

In the Query Cash Projections panel, when you list cash projections, you can select various options based on the requirements of your business. 

Option

Tag

Description

Option

Tag

Description

Projection Details





Entity ID

1163

Specifies the unique account identifier of the entity associated with the cash projection you want to query. You can select a value in the lookup that identifies the Entity ID, entity name, and accounting basis.

Status

1283

Displays the status of the last cash projection run for the selected entity. Options include:

  • Processed successfully. Default.

  • Processed with errors.

  • Processed with warnings.

  • Request processing

Report name

5362

Displays the name of the cash projection report associated with the last cash projection run for the selected entity.

Report Type

444

Displays the transaction types included in the last cash projection run for the selected entity. One or more specific transaction types can appear in this field, with the values separated by semicolons. Options include:

  • Dividends.

  • Fixed Income.

  • Forwards.

  • Others Buys/Sells/Spots etc.

  • Unsettled Transactions.

Projection type

1256

Displays the type of cash projection last run for the selected entity. Options include:

  • Cash Projections - All Currencies. The cash projection applies to all currencies.

  • One Currency. The cash projection applies to a single currency.

Currency

85

Displays the currency associated with the cash projection last run for the selected entity. If the Projection Type has a value of One Currency, this option can have a value.

Position

990

Displays the Eagle Accounting solution used for the cash projection last run for the selected entity. Options include:

  • ISTAR. Uses the ISTAR database for Eagle's insurance accounting solution. If you select this value, you cannot select the Report Type option or the Report End Date option.

  • ESTAR. Default. Uses the ESTAR database for Eagle's investment accounting solution.

Report Start Date

220

Specifies the first date of the last cash projection run for the selected entity.

Report End Date

221

Specifies the last date of the last cash projection run for the selected entity.