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 import question
Microsoft Dynamics AX (Archived)

Budget import question

(0) ShareShare
ReportReport
Posted on by SteveWhyte 583

I wav an excel workbook with 5 worksheets representing the budgets for 5 departments (Accounts, HR, Maintenance etc)

Each worksheet has columns for the account number, account description, as well as 12 additional columns representing each month (JAN-DEC)

Do I have to import each department separately and if so how do I identify/separate each month for each department?

I am using the Excel Add-in and the routine has no problem. I only need to know how to put my data together. I have been searching the net but not finding much at all.

Regards,

Steve

*This post is locked for comments

I have the same question (0)
  • SteveWhyte Profile Picture
    SteveWhyte 583 on at

    Thanks for your response Crispin:

    Are you saying that I should have 12 rows to represent each column or are you saying, for example, if I have 4 GL Accounts (in 4 rows) spread across 12 columns for each month, I should now have one column for the budget amounts and 48 rows (12 sets of 4 Account rows)?

    If not please clarify with an example...I would greatly appreciate it

    Steve

  • SteveWhyte Profile Picture
    SteveWhyte 583 on at

    Thanks Crispin....will test shortly

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Steve,

    Here is a blog post that details how to use the excel addin for budget uploads

    https://www.dynamics101.com/budget-register-entry-upload-excel-add-in-for-microsoft-dynamics-ax/

    This works fine as long as you do not have too many budgeting lines.

    If you plan to import more than 2000 budget lines then my experience is to either split the upload in multiple Excel document or to use the DIXF.

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans