Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Customer Forecast Reporting from Dynamics AX

Posted on by Microsoft Employee

Where do you get a report of Customer Forecast information?   Forecast vs Actual for Sales Orders?

*This post is locked for comments

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Forecast Reporting from Dynamics AX

    Hello Tina,

    Thank your for this update.

    One possiblity to make the actual - forecast comparison is the following:

    1. In the inventory module identify the periodic forecast functionality that allows you transferring the forecast quantities and values to the budgeting module

    2. Select the sales budget to ledger function, which shifts your forecast to a budget model.

    3. Once the budget is transferred you can use the standard budgeting module controls to run the actual - forecast/budget comparisons.

    An alternative is the use of BI tools where you can do the actual budget comparison.

    I am not sure whether the standard BI cubes for AX2012 include all the necessary measure but it is worth giving it a try.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Customer Forecast Reporting from Dynamics AX

    It is a "Customer Forecast" under the Customer Card, then the Forecast Tab.    It is not a Budget.    The purpose is to record the Customer demand by Item so that it can be used for Production and Inventory Planning.   However, we also want to use it to measure the customer's actual order volumes against their anticipated, or forecasted order volumes.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Forecast Reporting from Dynamics AX

    Hello Tina,

    The main question is what you understand under 'forecast' and how you report your forecast values.

    If a forecast is a budget in the budgeting module then you can use the standard budgeting forms to compare actual and budget (forecast) values.

    Can you provide some additional information on how and where you record your forecast values?

    Many thanks and best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans