Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

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

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
  • Actual vs Budget & Budget Analysis different actual amount to Budget control statistics
    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.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Actual vs Budget & Budget Analysis different actual amount to Budget control statistics
    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

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

Product updates

Dynamics 365 release plans