Hoping someone could offer some guidance on how to best architect the following scenario in Enterprise Budgeting.
Finance will centrally budget for specific natural accounts (Insurance as an example). Naturally, the natural accounts exists across all cost centres which business units are responsible for.
We would like the business unit to see the expense but not modify.
We could create a protect rule to lock the natural account in all budget packs, however you can’t target specific budget packs – it applies to all and sundry – including a Finance specific budget pack.
One (seemingly long winded) solution is to create an “Insurance” budget worksheet and assign to the Finance user, with some smarts built to make it easy in input insurance amounts manually to each cost centre, or exporting/importing last years figures and then modifying amounts as necessary.
We are not licensed for ETL at present.
Is there a better way to approach this?
We have a similar situation to you (eg for Vehicle, Printing expenses, etc) and find it easiest to apply the relevant protection rule(s) in the Budget Model, update the Worksheet off-line then reload for any changes.
Another option is to hold your centrally budgeted natural accounts in a single Worksheet, create a copy of your existing Budget Pack Definition (perhaps named Business Unit use) in your Budget Model and apply a Row Customisation lock to the Worksheet in the copied Budget Pack Definition that holds the centrally budgeted natural accounts.
The original Budget Pack Definition Name (with no locks applied) can be assigned to central Finance users and the copied Budget Pack Definition Name can be assigned to Business Unit users under Budget Pack Maintenance.
Hope this is of some assistance.
Don’t know if it is too late since it is almost 10 months on since you posted however below are some additional suggestions.
Steve and yourself covered most of the options outside using a spreadsheet rule, but this can also be done by having two different budget models, one with protection rules for Non-Finance use and one for Finance central budgeting.
This means that Finance can do the entry on a budget tab so that they can see comparatives on the same screen (if that helps them come up with their numbers) and provides the flexibility to do phasing based on last year actuals for instance. This is not easily done in a budget worksheet (especially without ETL).
You must be logged in to reply to this topic.