Connect/Disconnect Cash Plan Snapshot

Explanation

Use this activity to connect or disconnect a cash plan snapshot to a project cash forecast. In the dialogue, select which cash plan and snapshot to connect. Only snapshots in status Ordered can be connected.

A cash plan snapshot holds information about objects in various parts of the system that are used for cash planning, for example sub contracts, purchase orders, invoices payments and general ledger transactions. The snapshot details include information about the cash amount, currency and date, as well as project, sub project, activity and cost/revenue element information.

The cash plan snapshot consists of planned and actual values. The planned values include transactions from the cash plan snapshot where the cash transaction has not yet occurred, for example sub contracts, purchase orders, invoices. The actuals include payments and the general ledger transactions that have been configured to be included in cash planning.

When a snapshot is connected to the cash forecast, the matching process tries to find an exact match (the combination of sub project, activity, cost/revenue element and currency) between the snapshot lines and the forecast lines and adds the snapshot amounts to the Planned From Cash Plan and the Actuals From Cash Plan columns. Remaining Amount is calculated as Total Amount less Planned From Cash Plan and Actuals From Cash Plan. The Total Amount can be updated if needed. The Remaining Amount needs to be spread and sent back to the cash plan, as it represents the cash amounts not covered by other cash plan sources. The planned amounts from the cash plan snapshot are also displayed, distributed by accounting period, in the Cash Forecast Spread Details and Forecast Spread Line Details pages.

If the Project Setup Parameters is defined with Cash Forecasting in Multi Currency set to on, the Transaction Currency and Transaction Currency Amount from the cash plan snapshot details will be used in the matching process. If the Cash Forecasting in Multi Currency is off, the Accounting Currency and Accounting Currency Amount from the cash plan snapshot details will be used in the matching process.

If no match is found an exception line is added to the cash forecast, displaying the values from the cash plan. To handle the exceptions, new forecast lines with appropriate sub project, activity, cost/revenue element and currency from the snapshot lines needs to be created. When this is done the application will match the snapshot line with the new forecasted line and update the amounts.

When a snapshot has been connected to a forecast it is possible to disconnect it and replace it with a new snapshot.

The Cash Plan Details command, when executed at the Project Cash Forecast line level, serves the purpose of allowing users to access and examine the cash plan snapshot data in detail. This command is enabled upon the selection of a specific line and is only possible if the selected line has associated values for Planned From Cash Plan and/or Actuals From Cash Plan.

 

Prerequisites

System Effects