Skip to main content



No record found.

Microsoft Dynamics SL forum

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.

  • 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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans