web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Projects/Forecasts - Category Group Vs Project Category

(0) ShareShare
ReportReport
Posted on by 122

Dear DAXperts,

My customer has a typical requirement.concern with standard AX forecast/budget functionalty.

His concern is why is Project Budget Balances reporting is limited to Project Categories that are budgeted and not all. They work with few hundreds of Categories and for that reason they see its impractical to define forecast/budget at each Category level, just for the sake Budget balances to cover all categories while reporting.

They either want me to check the possibility of removing the restriction; to display/report limited to budgeted categories and include "all" categories such that everything gets covered.

The other option they asked us to explore is the possibility of creating forecasts/budgets at Category group level, instead of Category.

I did my best in explaning the reason for current framework; Categories link to GL accounts and that way project budgeting can be extended to GL bvudgeting, along with validation groups feature. Indeed, accounting can be even setup at Category group level also.

They certainly look to me as GAP and am afarid to scope fordevelopment, as I want to be double sure on the framework boundary.

Your thoughts/views are much appreciated.

Regards,

Sree

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Sree,

    Why don't you use another form for your actual budget comparison?

    What I am thinking of is the cost control form, which allows you including the forecast models that have been used in the budgeting form.

    Here is an example where I budgeted 1999 on a specific cateogory and recorded actual costs on another one.

    probu.png

    In the budget control form you can't see the 'car audio' category line because there is no budget registered for this category but in the cost control form you can do that.

    Another alternative is using the Project Management cube that allows you to incorporate and analyze all categories that you want.

    Best regards,

    Ludwig

  • Sreekanthxlnc Profile Picture
    122 on at

    Hi Ludwig,

    The Project Budget balances view is something they are very fond of (more elaborate view on Original Budget/Revision Budget/Committed/Unapproved budget if any etc) along with the different layouts it support, especially the Category Group layout and want to leverage on it than the const control.

    On your suggestion to use Project Management Cube, I need to explore it before I can comment any on its exact usability to the context.

    One more question:

    Why AX do not include actuals on the project in Budget balance report, even for cases where no budget is defined against that category? If AX Budget balances display other categories where actuals get posted that are outside the scope of initial budget, that also helps. Is this something the Cube data helps?

    Regards,

    Sree

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Sree,

    Another alternative that came to my mind is the following:

    1. Create your project plan in the WBS form.

    2. Copy your plan from the WBS form to the project budget form.

    3. Post your transactions on categories that do not have a budget recorded

    4. Open the tracking form in the control tab to see your original Budgeted costs and the actual posted amounts.

    The tracking forms provide you a similar view on actual and budgeted costs as the budget form and I believe that this might be an acceptable alternative.

    Would be great if you could test this and let us know whether this alternative Control form resolves your issue.

    Best regards,

    Ludwig

  • Sreekanthxlnc Profile Picture
    122 on at

    Hi Ludwig,

    While I can test the option for you, but this as workaround does not suit my customer, as they dont work with quotations/WBS. Their projects are largely internal. Keep you posted with my testing though.

    Please think through if any other work around out of the box/limited modification. While I investigate more into Cube which sounds a workable option for now

    Regards,

    Sree

  • Sreekanthxlnc Profile Picture
    122 on at

    Hi Ludwig,

    Finally my customer is ok to leverage the Cost Control feature than Project Budget Balances view, as there is no additional cost to him in using this.

    Regards,

    Sree

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans