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

Error while assigning new dimension value to custom table [investor]

(2) Share

Report

Posted on by Jinal P.

278

Hi Everyone,

Can anyone please help me with the following error? When I assign a new value to the Investor dimension, I encounter this issue. After the recent Microsoft updates, I started getting this error — it was working fine before

"Table ID must not be 60102 in Default Dimension Table ID='60102',No.='INV00134',Dimension Code=''

Please help me out

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Pallavi Phade 3,041 on at

Like (2)

Report

Error while assigning new dimension value to custom table [investor]

Namaste @Jinal P.

If you are inserting the data in default dimension table then there are three fields in Default Dimension Table . Ensure you have updated all three primary key fields

Seems in your cusotmization and as per error message "Dimension Code" is blank . Please check customization and add all values .

Warm Regards

Pallavi Phade

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 14,364 Super User 2025 Season 2 on at

Like (1)

Report

Error while assigning new dimension value to custom table [investor]

Hello,

The error occurs because Business Central now enforces stricter validation on the Default Dimension table after recent updates, preventing custom tables like your Investor table (ID 60102) from being assigned default dimensions.

Previously, this was allowed, but now only standard tables (e.g., Customer, Vendor, Item) are supported.

To fix this, you can either extend the validation logic via an AL event subscriber to include your custom table or handle dimensions through custom posting logic instead of default dimensions.

1 people found this reply helpful.

Was this reply helpful? Yes No
Jinal P. 278 on at

Like (1)

Report

Error while assigning new dimension value to custom table [investor]

Hi @Jainam M. Kothari

Could you please suggest which AL event subscriber I should use for a custom table, and explain the implementation steps? Additionally, can you please share the link to the Microsoft release notes detailing the recent restriction on default dimensions for custom tables.

Thank You

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 14,364 Super User 2025 Season 2 on at

Like (1)

Report

Error while assigning new dimension value to custom table [investor]

Hello @Jinal P.

you can create an AL event subscriber—commonly OnBeforeValidateTableID in the Default Dimension table—to skip validation for your custom table, or use OnBeforeInsertDefaultDim for more control.

This change is documented in Microsoft’s release notes on supported tables for default dimensions :https://learn.microsoft.com/en-us/dynamics365/business-central/application/base-application/table/microsoft.finance.dimension.default-dimension

1 people found this reply helpful.

Was this reply helpful? Yes No