The Financial Forecast folder in the Global Sales Business Warehouse (BW) provides self-service functionality to users for loading financial forecast data into the BW cube, for reporting purposes. It represents a functionality in itself, rather than a report. The financial forecast includes data determining how much we aim to sell for each product to which customer, specifying quantity, value, and contribution margin. The primary objective of the financial forecast data is to compare the budgeted figures with the achieved results, identifying gaps in terms of products and customers. |
Finance team |
Target Users: financial controller |
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 27.11/2023 | Azadeh Nasiri | Initial draft |
|
GBUs define the annual budget at the end of the year, and this budget is considered fixed and not open to alterations. Nevertheless, every quarter, modifications and changes to the budget are made through a separate process and maintained in distinct files. (Note: it's worth mentioning that currently, majority of GBUs rely on Dynasys as their source for budgeting, while in the past, this was a manual process.
GBUs are expected to load their budgets into the BW reporting system, making it visible to reports and dashboards. Access to this process is limited to specific users. Forecast part of the Global sales folder in BW has been developed to support these processes. This application allows to load FINANCIAL FORECAST in BW : BUDGET and BFR (Business Forecast Review).
This application allows to load financial forecast in BW:
The loading is done using an Excel file.
The BW transaction to be used is ZBW_SD_PC
Forecasts are used after and combined with sales in global sales reporting solutions including orderbook.
Note about Forecast in Dynasys
This section will approach the concepts/definitions that will be used in all the reports and required to understand the data from the reports.
Could be specific fields, closing activities, additional information to work and understand the reports.
This section represents the process with detail information for the application. Can include specific or special cases, complex logics , calculations, flows, among others.