I would like to get the dimension values.

(0) Share

Report

Posted on by Dyavari Sandeep Yadav

132

"Main Table" which I created and then added one field i.e:Dimensions and gave a "dimension" table relation. Now I added one field in customer there I would like to get the dimension values that is based on Dimensions field value which is "Main Table"(What dimension you selected).

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (1)

Report

Hi DyavariS ,

Please define the TableRelation property in the new field of customer table and mention as per below.

Here in the Image, you can replace by your customer table "Main Table"

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

When you use dimensions in customized table in Business Central you should try to do it the same way that Microsoft do it in the base application.

Use dimension sets and manage them using the dimension management codeunit.

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report
Hi, if you want to show shortcut dimensions on the page, hope the following will help.

tableextension 50100 MyExtension extends Customer { fields { field(50103; "ZY ShortcutDim3Code"; Code[20]) { Caption = 'Shortcut Dimension 3 Code'; CaptionClass = '1,2,3'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(3)); DataClassification = CustomerContent; } } } pageextension 50100 MyExtension extends "Customer Card" { layout { addafter(Name) { field("ZY ShortcutDim3Code"; Rec."ZY ShortcutDim3Code") { ApplicationArea = All; } } } }

As mentioned by Inge, the processing of Dimension is very special in BC, it is recommended that you can refer to the standard code to customize.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No