web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Import budget with multiple dimensions

(0) ShareShare
ReportReport
Posted on by 15

Hi,

Is there a way to import one excel file with a budget with multiple dimensions (Cost centers) and not one by one? 

Any one else has this issue? 

Thanks,

Sara

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    We are doing this every year. When you create Budget Template in Excel on Top Row you will see all Dim Category. Then in each line you can select multiple value for each Dim Category. Then populate months for that value. 

    The trick is to create one line per Dim Value. 

    I hope this help 

    pastedimage1642089260139v1.png

    pastedimage1642089355456v2.png

  • saraengberg Profile Picture
    15 on at

    Hi MahGah,

    This was exactly what I was looking for, thanks alot for your help!

    Kind regards,

    Sara

  • Amanda Last Profile Picture
    10 on at

    Hi, this looks like a very helpful answer but I can't see that our format gives us that column as an option.  I'm asking our support team for help and this doesn't seem to be standard

  • Amanda Last Profile Picture
    10 on at

    Sara, did you manage to do this?  I can't see that our format has the right columns

  • saraengberg Profile Picture
    15 on at

    Hi Amanda,

    I added the column manually and then add the titel of the dimension, in our case avdelning code. See picture below. 

    Hope this helps!

    pastedimage1672663943083v1.png

    /Sara

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans