on 10-17-2006 9:14 PM
I have a requirement to create adjusted plan versions for each month. For example Version 200- Original Budget, version 201 - January Budget, 202- February Budget and so on.. My question is will the adjusted versions 201 and 202 have the base version as 200 or as 201 and 202 respectively.
Please advise.
Regards
why do u need to use a different version for each month?
i use one version which is the actual value and then one
as plan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am sorry I do not yet understand how this is going to work. Could you please elaborate on it. How will the comparison be achieved in reporting if we do not maintain two different versions of data? For example I am running a report for the month of january. In the report I have one column for the original budget and one column for the adjusted budget. How do I achieve this if I do not maintain different versions? Also in PCA there are different plan versions maintained (0-Actual/Plan, 1-January Plan, 2-Feb Plan). When I run a rollup for the original budget I will use PCA version 0 but when I create a rollup for the adjusted budget version I use PCA version 1 for Jan and PCA version 2 for Feb. How will this be taken care of? Please advise.
Regards,
yes you would have different versions for plan and actual example while you are planning in 7ke1 you use version 1 and enter the budget for each g/l for all the months.
version 0 will be your actual values that you see in fbl3n
now when you create a report in report painter if you have two columns one for actual and one for budget, for the budget column you would choose version 1 and for the actual you use version 0
but you dont have version 1 for january 2 for february etc
hope this helps
Hi,
my 2-cents worth: Depending on the business needs and practices, some companies (like the ones I worked in previously) do keep >10 planned versions for each of the month. The reason for so many versions is more of to facilitate the rolling forecast, instead of performing operational ones on periodic basis.
If you're seriou about implementing this, there will be alot of version transfers running around on a monthly basis (depending on where you ultimately report the data out).
The key thing is to tie each of the versions to a month, or let the user freely define/enter their own version for the month.
Hope this helps.
Cheers,
Gimmo
Hello Gimmo,
Thank you very much for the advise. Just have a quick follow up question, in the various versions that you maintained earlier what was the base version you used. For example: if version 200 is for original budget and version 201 is for adjusted jan budget. Will we use 200 as the base version for 201?
Please advise,
Regards,
Pallavi
Hi,
This really has to depend on the business scenario.
1) In the example I had quoted, the versions are used for forecasting and hence it is like version 200 started off as the base version (eg at the start of the year, it contains 11 or 12 months of planned data), and when the next month arrived, version 201 will be copied from 200 and with 10 or 11 months of planned data, and this version 201 will in turn become the base version for the next version 202.... so on and so forth. So each of the current version will become the base of the next version since it is what the users are working on. There will have to have a procedure to make sure this turn of version is seamless to the users.
2) The current version will always be version 200, and versions 201, 202 can be the backup version for the various months. In this case the user is always working on 1 version, but the rest of the versions are always copied from version 200, after each month end.
I suggest you have a chat with your Finance users, and check on the current budget practice, the frequency of budget and accuracy of data to determine how the system should work around the current practice.
Hope this helps.
Cheers,
Gimmo
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.