Finance | Project Operations, Human Resources, ...

Import Budget register entries/split them by month

(0) Share

Report

Posted on by Community Member

Dear all

A company does their budgeting by year. When I import their budget register entries into the system I would like to automatically split them into 12 months. Is there a way to achieve this, either by using the excel add-in or data management? I would like to achieve this without changing the original excel file.

I know that you could use the "allocate across periods" function in the "Budget register entry" table, but D365 forces you to do this line by line.
Another solution I thought of was to import the budget into a Budgetplan and split the lines using a workflow. That would be easy enough. But there must be another, more straight forward way.

Does anybody have an idea or encountered a similar request?

Thank you & best regards
Urs

I have the same question (0)

All responses (10)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Hi Urs,

Personally, I would split up the data in the original file that is uploaded.

Why would you upload something that needs further manipulation in D365FO?

Doesn't this mean a kind of double work?

In my opinion it is probably the easiest and fastest making this monthly-allocation directly in the Excel upload file.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Hi Ludwig

Thanks for your answer. But actually, this did not answer my question.

"Why would you upload something that needs further manipulation in D365FO?

Doesn't this mean a kind of double work?"

In contrary, it would streamline the process for the customer and eliminate a potential source of error. Since the customer creates yearly budgets it would be safer and faster if there would be a possibility to split it in the system (also, I heard that it was possible to do that back in 2012).

Therefore I keep this thread open. Does anybody know a simple way to achieve that in D365FO?

Kind regards

Urs

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Hello Urs,

Another option would be using Azure functions for doing the import and data manipulation in one step.

A friend of mine posted a video here (dynamicsax-fico.com/.../) and put his project on GitHub.

Yet, even though this process can do what you are looking for in an automated fashion, you will probably need some technical help for that.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Import Budget register entries/split them by month

You can set the budget cycle as per below where system will set each period separately.

Once this is set, you can upload your budget balances in budget register entry form for each month through either by excel add-ins or data management. Which means; it will be segregated on monthly basis at the time of upload itself.

Regards,
Sourav

Was this reply helpful? Yes No
Jim Ji on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Hello, basically you have two possible options:

As Ludwig suggested, development a funtion to help you split the yearly budget entry.

As Sourav mentioned, set the budget cycle for monthly repetition

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Hello Sourav

Thank you for your answer. I tested your solution, but it did not work. Could you please provide some more details about your setup? Did you test it/did it work in your environment?

Kind regards

Urs

Was this reply helpful? Yes No
AshokKumarGuptaEga on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Hello Urs,

Is is possible to raise a support incident so that we can investigate the issue by comparing the behavior in AX2012 & D365. And if found to be working in AX2012, we can have our development team to re-look into the issue.

Thanks & Regards

Ashok Kumar Gupta Ega

Was this reply helpful? Yes No
SouravDam 11,730 on at

Like (0)

Report

RE: Import Budget register entries/split them by month

You can first set the budget cycle based on number of periods as explained before.

Once this is done; you have to generate budget plan for every month from "Generate budget plan from general ledgers". Which means, you are segregating budget plan month wise itself.

Now once the budget plans are approved for each month and final budget plan is created; then you can generate budget register entries from the final budget plan itself which is already segregated month wise.

Hope this clarifies.

Regards,
Sourav

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Hi Sourav

I do not see a benefit in your solution/just makes the case I described more complicated.
As stated in my inital post, I would like to achieve this without using budgetplans:

"Another solution I thought of was to import the budget into a Budgetplan and split the lines using a workflow. That would be easy enough. But there must be another, more straight forward way."

Also, let me clarify a few things here for future readers. It is pretty straight forward to generate a yearly budgetplan and allocate it across periods/months. To allocate your finalized budgetplan across periods, you add such a step in your Budgeting > Setup > Budget planning > Budget planning configuration > Allocation schedules. There you use the allocation method "Allocate across periods" and use a period key as defined in General ledger > Ledger setup > Period allocation categories (not budget cycles).

Kind regards

Urs

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Import Budget register entries/split them by month

Ludwig, thank you for this Idea. Although I will not pursue it, it was a good and informed response.

Was this reply helpful? Yes No