Skip to Content
0
Former Member
Jun 05, 2005 at 03:28 AM

Manual Input of Budget Data

38 Views

Greetings fellow masters,

We need to generate group level reports of which some fields extracted via R/3 and some fields for manual input of data(Budget fields)

For example,

<u>Time/Periods</u>

Current Year(YTD) |

Previous Year(YTD) |

<b> 2005 YTD(Budget)</b> |

<b>2005 YTD(Budget)</b> |

<b>Y-on-Y (Growth)</b> |

<b> Mth actual(Variance)</b>

<u>Fields</u>

Operating Revenues

- Manpower Cost

- IT Maintainance

- Legal, Audit Fee

Operating EBITDA

- Depreciation

- Amortisation

Operating EBT

- Investment Income

Profit Before Tax

My question is, how do we get the end users to allow them to <b>manually key-in</b> the Budget data(on a monthly basis), so I can generate the report above(with the actual data as well as budget data)

Do I do this using the manual planning funtion via BW-BPS ? If yes, do I have to <b>create custom input screens</b> for the users ?

Certain fields will need to be <b>formulated</b> to produce the desired results, as well, hence how do we cater for this ?

Appreciate fellow guru's help, please...