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:
In Accounting Center, in the left navigation pane, click Reports > Cash Projections Viewer >Â Query Cash Projections.
You see the Query Cash Projections panel.Complete the options in the panel.Â
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 |
---|---|---|
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:
|
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:
|
Projection type | 1256 | Displays the type of cash projection last run for the selected entity. Options include:
|
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:
|
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. |