Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Budget on balance shee...
Finance | Project Operations, Human Resources, ...
Answered

Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

(0) ShareShare
ReportReport
Posted on by Zeeshan Niazi 5

i have a query regarding budgeting module of ax. actually i configured budget control of balance sheet accounts and you are better aware that Dr and Cr entry in these accounts happens frequently.

so the scenario is:- i made a budget of asset account e.g 50,000 US but if some one pass credit entry of any previous debit entry then system add the amount of credit entry in budget fund available column. e.g if i do Cr entry of 1000 US of that particular asset account system will show me 51,000 US budget fund available.  how could i tackle this? your response will be highly appreciated.

Thank You

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

    Hi Zeeshan Niazi,

    Thanks for the confirmation.

    I had a look at LCS and found the following hint/note from MS:

    Solution 3391305Unable to configure budget control on fixed assets

    https://fix.lcs.dynamics.com/Issue/Details?bugId=3391305&dbType=0&qc=68b58c68a9797ec8d42b384eaeba6db07de51d6cd8affafbeb725b107901d388

    There is currently a limitation on that and you would have to modify this behavior. 

    Best regards, 

    Ludwig

  • Zeeshan Niazi Profile Picture
    Zeeshan Niazi 5 on at
    RE: Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

    Yes i already tested this. when i scrap, the amount is adding back in budget fund available column.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

    Hi Zeeshan,

    Got your point.

    Your worry is whether or not a sale/scrap transaction put the sales/scrap amount back on top of the budget recorded, right?

    In my opinion that is not the case because the budget register entries separate entries via the amount type.

    To be absolutely sure I would recommend that you quickly test this in your demo machine.

    Simply post an acquisition, depreciation and then scrap the asset in a demo/test environment.

    Thereafter, double check your budget amount left.

    Best regards,

    Ludwig

  • Zeeshan Niazi Profile Picture
    Zeeshan Niazi 5 on at
    RE: Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

    let me take your example:

    when i dispose of this asset so it will CR the acquisition account and it will reflect in Budget fund available column and increase the amount of that column.

    this i want to know it it correct behave in this case with respect to budget?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

    Hi Zeeshan Niazi,

    Many thanks for your update.

    Is your question related to fixed assets?

    Here you usually have an acquisition transaction that you post as follows:

    DR: Acquisition account

    CR: Accounts payable summary account

    Amount: $1000

    Then you post the depreciation as follows:

    DR: Depreciation expense

    CR: Accumulated depreciation

    Amount: $100

    The net balance of your fixed asset is $1000-$100 = $900.

    The 'trick' here is that the acquisition and the accumulated depreciation are recorded on separate accounts, which does thus not mess up your budget amounts.

    Does that example make sense to you?

    Do you have a similar fixed asset related scenario or something related?

    Best regards,

    Ludwig

  • Zeeshan Niazi Profile Picture
    Zeeshan Niazi 5 on at
    RE: Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

    Thankz for Reply.

    But its not exactly what i am looking for. Let me clear you.

    You made a budget of any balance sheet account. say 1000 US. When you post actual entry e.g DR 100 US the budget fund available column will show you 900 US remaining.

    But you know balance sheet account is a mixture of DR and CR entry. When i make CR entry in any asset account e.g 100 US it will add back in Budget fund available actually which is misleading. This thing ok for P&L Accounts but for balance sheet accounts its just misguiding. so this thing i want to know how could i tackle?  any customization hint ?

    Thank You

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Budget on balance sheet account and credit entry in those accounts is increasing the budget fund available.

    Hello Zeeshan Niazi,

    Here are some posts that illustrate what to look out for when budgeting on balance sheet accounts, such as for example for fixed assets.

    dynamicsax-fico.com/.../

    Is that what you are looking for?

    Best regards,

    Ludwig

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans