P&L Forecast
The P&L Forecast is a Summary Report that displays actual and budget
period values. The filtering for the columns is driven by the static and calculated values in
rows 200 and 201.
The Report Designer is used to filter the columns in the report for Ledger A (actual balances) and Ledger B (budget balances).
The report is sorted in ascending order using the Account Code and Department Analysis Code.
These fields are included on the report :
- Account Code
- Description
- Name
- Base Amount
- Department Analysis Code
- Department Code Total
Note: To open the Summary Report definition screen, double-click cell F10.
This table shows the filters used on the report:
| Filter | Value | Field reference |
|---|---|---|
| Table | Ledger (LA) | - |
| |Ledger | Defined in the Report Designer | - |
| Account Code | 10000 - 35999 | - |
| Accounting Period | All | C8 |
| CA\Account Type | P | - |