Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Import Budget register...
Finance forum
Suggested answer

Import Budget register entries/split them by month

Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • SouravDam Profile Picture
    SouravDam 11,721 on at
    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

  • 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Jim Ji Profile Picture
    Jim Ji on at
    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

  • Suggested answer
    SouravDam Profile Picture
    SouravDam 11,721 on at
    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.

    4643.JPG

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans