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

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

(7) Share

Report

Posted on by Jinal P.

300

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 (7)

Answers (0)

Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

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 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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. 300 on at

Like (4)

Report
Copy link

Link copied!

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 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

This error comes from custom code in an extension, not from standard BC.

Your Investor table (60102) is being blocked by a validation added in that extension — after the latest update the extension now throws:

> “Table ID must not be 60102…”

The issue is in custom code, not Business Central.

Search the extension for a validation on Default Dimension (table 352).

Remove/adjust that rule or ask the ISV to fix it.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Please have the developers debug this; it's clearly a problem caused by customization.

Thanks.

ZHU

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

Like (2)

Report
Copy link

Link copied!

Hi @OussamaSabbouh, @YUN ZHU

Below is my custom code: can you tell me what can cause the issue?

field(48; "Dimension Value Code"; Code[20])

{

Caption = 'Dimension Value Code';

trigger OnValidate()

Var

Dimension: Record Dimension;

DimensionValue: Record "Dimension Value";

DefaultDimension: Record "Default Dimension";

NoSeries: Codeunit "No. Series";

Owner_rec: Record Owners;

DimMgt: Codeunit DimensionManagement;

NewDimSetID: Integer;

DimSetEntry: Record "Dimension Set Entry";

begin

Rec.TestField("Dimension Code");

if Rec."Dimension Value Code" <> '' then begin

// if Dialog.Confirm(DimValueConfirmLbl, true, Rec."Dimension Value Code") then begin

Dimension.Reset();

Dimension.SetRange(Code, rec."Dimension Code");

if Dimension.FindFirst() then begin

// begin

DimensionValue.Init();

DimensionValue.Validate("Dimension Code", rec."Dimension Code");

DimensionValue.Validate(Code, Rec."Dimension Value Code");

DimensionValue.Validate(Name, DimensionValue.Code);

DimensionValue.Insert(true);

DefaultDimension.Init();

DefaultDimension.Validate("Table ID", Database::Owners);

DefaultDimension.Validate("No.", Rec.No);

DefaultDimension.Validate("Dimension Code", rec."Dimension Code");

if DimensionValue.Get(rec."Dimension Code", Rec."Dimension Value Code") then DefaultDimension.Validate("Dimension Value Code", DimensionValue.Code);

DefaultDimension.Insert(true);

end;

Was this reply helpful? Yes No