Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Project Budgeting reports monthly variance

Posted on by Microsoft Employee

Hello all,

I am trying to get these project budget reports to show monthly variance between budget and actuals. For some reason it will only show me a cumulative year to day. Is there a way to only see the monthly actuals and variance pre built into these reports? Specifically project task analysis, budget reports and project recap reports?

Thanks a bunch.

*This post is locked for comments

  • Verified answer
    Erich Strelow F Profile Picture
    Erich Strelow F 1,642 on at
    RE: Project Budgeting reports monthly variance

    You probably already checked out the Enable Budget History option in project setup.

    This option means that SL will start to populate the PJBHSSUM and PJBHSROL. These two tables record the budget as was known up to each period. Sadly, they are not consumed by any report whatsoever, they are provided as a DIY tool for by-period budget reporting.

    As for the actuals, a big part of the reports are either project-to-date or year-to-date based, but there are some with month-to-date values. Check the PAPSI00 Project Summary Inquiry. If you did populate a monthly budget, it should give you the month-to-date variance.

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