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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Budget Analysis has do...
Microsoft Dynamics AX (Archived)

Budget Analysis has double record in PO confirmation and Product Receipt

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

I have an issue regarding the budget analysis report - in the budgeting module.

Currently I set up the ledger to be posted when product receipt is created.

Thus it will make the expense will be posted when product receipt and then it will be reversed and posted with the actual value when invoiced is created.

However the report in budget analysis acted improperly. 

It will record the PO confirmation as encumbrances, and then post actual value when product receipt without reducing the value from confirmation. This makes double record in the budget consumption (encumbrances + actual transaction). Although the encumbrances will be reversed when invoice is posted.

Is there any way to avoid this behavior?

Thanks in advance.

Best Regards,

M.H.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Khaled Alloud Profile Picture
    Khaled Alloud 3,658 on at

    Dear M. Hasan,

    If i understood well, you have made AX to post to Budget when creating the receipt, right?

    However, we run Budget in this way:

    - PR would post to pre-encumbrance

    - PO - > encumbrance

    - invoice would reflect to actual

    I think it is wrong for the receipt to post to Budget, you should fix the Budget Dimension under Financial dimensions for the product receipt.

    regards,

  • Community Member Profile Picture
    Community Member on at

    Hi Kaled,

    Yes I understand that usually we will post the actual expense in Invoice. Which also align with the budget control report. But, in budget analysis report it act with different behavior. Since I set the parameter to post the ledger in product receipt transaction, Thus when I post the product receipt there will be actual expenses generated which is captured in the budget analysis report.

    For summary the differences are as below:

    Transaction Budget Control Encumbrances Budget Control Actual Budget Analysis Encumbrances Budget Analysis Actual
    PO 10.000 10.000
    Receipt (4.000) 10.000 10.000 4.000

    Invoice

    (4.000)

    		  6.000 4.000 6.000 4.000

    As you can see when there is product receipt transaction the budget will be consumed higher than the total PO. Which will cause incorrect information. And this issue will not only be occurred if we activate the posting ledger in product receipt. Because normally in the end of period, we will post the accrued expenses for the good/service that we have receipt although it has not been invoiced yet.

    Do you have any case like this before?

    Regards,

    M.H.

  • Khaled Alloud Profile Picture
    Khaled Alloud 3,658 on at

    Hello,

    What is the currency of the PO and the currency used by the user accessing to AX?

    Can you please attach screen shots from AX about Budget Control statistics report (Pre, encumbrance, and actual windows)

    Thank you,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans