Skip to main content

Notifications

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 Upload Error
Microsoft Dynamics AX (Archived)

Budget Upload Error

(0) ShareShare
ReportReport
Posted on by Community Member

Hello All!

Please I'm uploading the budget using excel add-in and I'm getting this error message

Field 'Dimension values' must be filled in.Error found when validating record. Creation has been canceled.

Please help!

*This post is locked for comments

  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at
    RE: Budget Upload Error

    you can use data import and export module  , it is very simple in budget .

  • Community Member Profile Picture
    Community Member on at
    RE: Budget Upload Error

    Yes the main accounts are all correct. The entries are more or less than 1,500 lines per month.

  • Community Member Profile Picture
    Community Member on at
    RE: Budget Upload Error

    Hi,

    I encountered the same error as DammyT while uploading our budget using excel add-in. Same as her, I was doing copy & paste. I tried to manually type in some of the lines and it went through. The thing is, I have thousands of budget entries so this solution will not work for me. Is there any other solution to this error?

    Field 'Dimension values' must be filled in.Error found when validating record.Creation has been canceled.

  • Suggested answer
    RamK Profile Picture
    RamK 2,580 on at
    RE: Budget Upload Error

    In the past, we had issue with Copy & paste in Budget template.  We use to type the values or select it from the look-up to create new lines.  Try this approach to validate your configuration.  If it works, then the issue is with the copy

  • Community Member Profile Picture
    Community Member on at
    RE: Budget Upload Error

    Copy and Paste.

  • RamK Profile Picture
    RamK 2,580 on at
    RE: Budget Upload Error

    Are you typing the values or doing copy & paste...?

  • Community Member Profile Picture
    Community Member on at
    RE: Budget Upload Error

    @Ramk, thanks! But I've done that and there is nothing wrong with the AOS connection.

  • Suggested answer
    RamK Profile Picture
    RamK 2,580 on at
    RE: Budget Upload Error

    Hi DammyT, if you have multiple account structure, select the proper structure in excel -> Dynamics AX -> options ->Default account structure.  Check the AOS connection too

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans