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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Issue with Project Budget Balances - Puchase Requisitions shows in both Consumed and Commitments

(5) ShareShare
ReportReport
Posted on by 10

Hello experts,

I’m experiencing an issue with the Project Budget Balances in Dynamics 365 Finance and Operations.

When I create a Purchase Requisition (PR) and it gets approved, the system records the amount in both the Consumed Budget and the Commitments columns.

However, based on the standard behavior, once a PR is approved, the amount should only appear under Commitments, not Consumed Budget. This causes the Remaining Budget to be incorrect.

Example:

I have an Original Budget of 1,000 for the Travel Project Category.
I create a PR for 1,000, and once it is approved, the system shows:
  • Consumed: 1,000
  • Commitments: 1,000
    This should not happen. Normally, only Commitments should be updated at this stage.
    Could you please help me understand why this is happening and how to fix it?

Thank you!

Screenshot 2025-05-19 142750.png
I have the same question (2)
  • Suggested answer
    SajeedMullaji Profile Picture
    840 on at

    @CU21051339-0 
    this is a budget control configuration issue rather than a bug. the double-counting happens because purchase requisitions are mapped as a source document for both commitments and consumed budget simultaneously in your budget control setup.

    three steps to fix it:

    first go to budgeting → setup → budget control → budget control configuration → documents and journals section. check if purchase requisitions is selected as a source document for consumed budget — if it is, uncheck it. prs should only update commitments at approval stage. consumed should only update when the vendor invoice is posted as an actual cost.

    second go to project management and accounting → setup → project management and accounting parameters → budgeting tab. verify the budget control settings are not forcing an immediate actual update on pr approval.

    third if you are using encumbrance accounting ensure prs are mapped as pre-encumbrances and pos as encumbrances. if both are mapped to the same ledger staging the system reports prs as consumption.

    if you already have erroneous consumed balances showing — run the budget control statistics or budget transaction detail report to identify the orphaned budget transactions, then use a budget adjustment journal to credit the consumed amount back. do not edit these values directly in sql — always use the standard budget register entry or budget adjustment journal.

    hope that helps — feel free to mark as verified if it resolves the issue.

  • Suggested answer
    Deepak Agarwal Profile Picture
    9,277 Super User 2026 Season 2 on at

    Yes you are right, system should show only commitments amount while once transaction (PR) posted it should appear in consumed. 

    By any chance is there any customization or bespoke configuration done around this process to post project transaction at the time of PR approval. I would also check with a procurement category is mapped with project. 

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 330 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 310

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 242 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans