PURPOSE
To provide the details used by CS Lucas to show the Actual/Forecast Analysis.
WHY IS THIS IMPORTANT?
Allow users to verify the details of Actual/Forecast Analysis.
QUERY
1. Navigate to Reporting > Standards > Report 1418: Actual/Forecast Analysis.
2. Fill in the mandatory parameter – Acct Cntr, Time Bucket, From Date, To Date, Rpt Ccy, UOM and Grouping Order.
3. Click Action and select the required format.
4. The report shows the Section, Description, Total and Forecasts.
For explanation of Excel Raw export, please see link.
For explanation of buttons, please see link.
DATA SOURCE
To view the following transaction,
Follow the steps as shown below:
1. Navigate to Cash Management > Forecasting > Operational.
2. Select Acct Cntr* (From example: TFS-SG)
3. Key in the From Date* (From example: 03/07/2017)
4. Select Rpt Ccy* (From example: SGD)
5. Select SSI* (From example: TFS OPS+FIN)
6. Click Refresh.
FREQUENTLY ASKED QUESTIONS
FAQ01. What exchange rate is used for conversion to the reporting currency?
The Valuation Rate on the value date (VDate) is used to convert opening balances, treasury activities and forecast amounts from the original currency to the reporting currency. If no rate is available for the specified date, the last available rate will be used.
RELATED INFORMATION
General Formatting For All Reports
CHANGE HISTORY
0 Comments