web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to use budget models
Microsoft Dynamics AX (Archived)

How to use budget models

(0) ShareShare
ReportReport
Posted on by lally 2

Hi All , 

AX 2012 has the budget model functionality , standard AX has given some examples . But I am not sure about  how best we can use this functionality , So can you explain with some real examples.

Do we need to one budget model and under this all sub models or for one budget model for each sub model ?

Please explain with some real world examples.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to use budget models

    Hello lally,

    If you are budgeting not only on the ledger account level but also at the financial dimension level, I suppose that you have some financial dimensions from where you can retrieve your regions from. This does not necessarily require a separate financial dimension ("Region") but can be a customer or cost center financial dimension that are summarized into your regions. If you have this information included in your Budgeting lines you do not need to setup a separate budget model and sub-models for your regions.

    What I have done and seen in many applications is that customers try to hold the number of budget models small. Some separate it by year (e.g. budget model 2016, 2017, ... others do not even make this separation but simply specify a "corporate budget model". This is fine as long as all the information required - in your case your "region" - can be identified from the accounts and financial dimension values used for budgeting.

    Another aspect of making the setup this way is reporting. If you setup let's say annual budget models and Management Reporter reports to compare actual and budget data then you will notice that you have to modifiy the budget models setup over time. That is, you have to adjust all of your actual-budget reports, which can be quite cumbersome. The more budget models and sub-models you use, the more effort is required changing all those reports.

    Please also remember that you do also have to enter a budget code which gives you an additional Option to differentiate between your budgets. Yet, also here, try to keep it small and make use of the codes types that are there. That's what I would recommend.

    Hope this information helps.

    Best regards,

    Ludwig

  • lally Profile Picture
    lally 2 on at
    RE: How to use budget models

    I am really not sure how best we use these model codes and sub model codes .. Can you share your implementation experience ?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to use budget models

    Hello lally,

    Why do you need to separate purchase and sales budget models? Doesn't the budget register entry form allows making this separation by referring to the amount type (expense / revenue)?

    The sales regions (North/South) that you mention above, aren't they represented by some kind of financial dimensions setup and used in your system?

    Ludwig

  • lally Profile Picture
    lally 2 on at
    RE: Budget model

    That is how we normally divide the budget models , if I am wrong then what is the normal method to define the budget models .

     

    Please explain with an example by considering the real implementation experience.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Budget model

    Hello lally,

    I am wondering why you want to work with submodels this way and separate it into sales and purchase submodel?

    Ludwig

  • lally Profile Picture
    lally 2 on at
    RE: Budget model

    [quote user="André Arnaud de Calavon"]Your question was about the general use of budget models, not issues related to validations in AX[/quote]

    I agree with you and need to know the how best we can use these budget models in the implementation point of view .

    If i go with your words , Assume that client wants to create the budget models like Sales –          Submodel  - North Region and South Region

                                                                                                          Purchase      Submodel -  North Region and South Region

    Now the issue is these two budget models need to attach to the Budget cycles form  for the fiscal year 2015 ,

    Like    2015     - Sales

                2015   - Purchase

     but system throws Budget cycle FY2015 is already in use for budget cycle time span Fiscal. Select another budget cycle.

     

    Any idea ?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,399 Super User 2025 Season 2 on at
    RE: Budget model

    Hi Lally,

    Your question was about the general use of budget models, not issues related to validations in AX.

    I don't know what is currently setup in your environment, so I don't know what exactly is throwing the error.

  • lally Profile Picture
    lally 2 on at
    RE: Budget model

    [quote user="André Arnaud de Calavon"]It depends on the requirement of the company[/quote]

    Assume that client wants to create the budget models like Sales –          Submodel  - North Region and South Region

                                                                                                          Purchase      Submodel -  North Region and South Region

    Now the issue is these two budget models need to attach to the Budget cycles form  for the fiscal year 2015 ,

    Like    2015     - Sales

                2015   - Purchase

     but system throws Budget cycle FY2015 is already in use for budget cycle time span Fiscal. Select another budget cycle.

     

    Any idea ?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,399 Super User 2025 Season 2 on at
    RE: Budget model

    Hi Lally,

    It depends on the requirement of the company.

    You can do a setup for a total and create sub models per region.

    You can also create a budget model e.g. per year without sub models.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans