Small and medium business | Business Central, N...

Dimension value missing error in Budget

(7) Share

Report

Posted on by STP

541

Hi all,

I'm creating a budget in BC, I only wanna use dimension for some ledger accounts, some are not.

I exported the excel template, and populated the dimension values for some ledger account, e.g. Expense and Sales account, and leave it as blank for other ledger accounts, e.g. Asset.

When I imported it into BC, I have below error message. When I populated the dimension values for all ledger accounts, there are no such error.

Is it possible to load budget in this case? I only wanna some budgets with dimension, some are not.

In COA, I didn't set any mandatory rules for dimension.

Thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

Like (3)

Report

Don't import empty values from Excel. If You don't want to import this, then just delete the line/column from Excel, otherwise it imports a value that is empty and it is not the same as empty specially if there is a formula or something.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (3)

Report

Could you validate the dimension value you try to import are put in correctly? If so, try to turn off the validate flag on your configuration package and try again.

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,190 Super User 2025 Season 2 on at

Like (3)

Report

Hello,
When exporting the budget, do I select any dimension?

When exporting the budget, it only carries amounts. When you load it, you should define budget by dimensions.

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (3)

Report

Hi

You can analyze dividing budgets, into some with accounts with dimensions and others that do not.Or use a generic dimension that specifies a value equivalent to empty or none.

Best

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (2)

Report

Hi, hopefully the following discussion can give you some hints.

Budget Import Error

https://community.dynamics.com/forums/thread/details/?threadid=6f77133c-30e6-ee11-904d-00224827eb85

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (4)

Report

Hello @STP,

Yes, it is possible to load a budget with dimensions for only some G/L accounts in Business Central. However, the error you’re seeing occurs because the dimension column in your Excel import contains blank values (i.e., empty strings), which BC tries to validate as actual dimension values. To fix this, ensure that dimension columns are completely blank (no spaces or invisible characters) for accounts where you don’t want to use dimensions. This tells BC to ignore the dimension for those lines instead of trying to validate a missing value.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (2)

Report

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-troubleshooting-correcting-dimensions

✅ Mark this as the verified answer if it helps.

Was this reply helpful? Yes No