Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Project Budgeting reports monthly variance

(0) ShareShare
ReportReport
Posted on by

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
    16 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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

#1
Community Member Profile Picture

Community Member 136

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 102 Super User 2025 Season 1

#3
REUser Profile Picture

REUser 8

Featured topics

Product updates

Dynamics 365 release plans