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

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Actual vs Budget & Budget Analysis different actual amount to Budget control statistics

(1) ShareShare
ReportReport
Posted on by 3
Hi All,
 
I am having a problem with budget checking on a purchase order, where the budget available amount does not take into account actual expenditure.
 
Transaction:
Total Budget: $30 000
Entries already posted to the main account: $6 000
Purchase Order: $28 000
Budget check performed = Budget check OK
This is incorrect, and the budget check should calculate an overbudget amount of $4 000.
 
The PO is a source document selected for budget control.
The $6 000 transaction was posted using a daily journal, which is not a source document applicable to budget control. However, I would still expect the budget funds available calculation to take the actual amount already posted in account?
 
The environment was recently upgraded, and this new feature: Only track amounts in the budget funds available calculation is now on by default. Could this be the cause, or is there any other reason this could be occurring?
 
The budget inquiries also differ on the total column:
Budget analysis inquiry:
  • Budget $30 000
  • Actual expenditure: $6 000
Actual versus budget inquiry:
  • Budget $30 000
  • Actual expenditure: $6 000
Budget control statistics:
  • Budget funds available: $30 000
  • Actual expenditure: $0
I have the same question (1)
  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on at
    Hi,
    The issue you are experiencing with budget checking in the system appears to be related to the way actual expenditures are taken into account in the budget funds available calculations. The documentation states that if the "Track only amounts in budget funds available calculation" feature is enabled, some budget control configuration options must have specific settings for the feature to work properly. These options are selected or cleared on the Budget Available Funds tab of the Define Budget Control Parameters page. Screenshot showing the settings required for the available budget funding feature.


    Best Regards,
    Hana
  • Community member Profile Picture
    3 on at
    Hi Hana,
     
    I do have the following selected for Budget funds available:
    Budget funds available = (Original budget + Budget revisions) - (Actual expenditures + Budget reservations for encumbrances + Budget reservations for pre-encumbrances)
     
    My issue is that the "Actual expenditures" portion is only taking into account transactions when they are posted using documents selected for budget control, so the total budgeted funds available amount is incorrect.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans