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

(0) Share

Report

Posted on by Zeeshan Niazi

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

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Zeeshan Niazi 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Zeeshan Niazi 5 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Zeeshan Niazi 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Solution 3391305Unable to configure budget control on fixed assets

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

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

Solution 3391305Unable to configure budget control on fixed assets

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates