Share
Reportif it is possible to do then please help me to archive this. Here I tried by assigning the same field value. But I am unable to get the value of a field that is from another table.
You’re offline. This is a read only version of the page.
186
if it is possible to do then please help me to archive this. Here I tried by assigning the same field value. But I am unable to get the value of a field that is from another table.
you can check the below code in page sales order subform where shortcut dimensions are shown on the basis of different dimensions values selected in GL setup.
field(ShortcutDimCode3; ShortcutDimCode[3])
{
ApplicationArea = Dimensions;
CaptionClass = '1,2,3';
TableRelation = "Dimension Value".Code WHERE("Global Dimension No." = CONST(3),
"Dimension Value Type" = CONST(Standard),
Blocked = CONST(false));
Visible = DimVisible3;
trigger OnValidate()
begin
ValidateShortcutDimension(3);
end;
}
to setup like the above one now you need to define the caption likewise in codeunit 343 "Dimension CaptionClass Mgmt" you can have a look on this codeunit it will give you better idea to achive custom caption.
Hi,
If you mean that you have another dimension which you are using in Business Central apart from Global Dimension 1 and 2 and you want to display the name Caption Dimension Code of dimension selected on Customer Card then you can use Caption Class by changing Last Value in Caption class 1,2,3 or 1,2,4 it will appear for the Dimension selected on General Ledger Setup.
and adding two fields in Table Extension
Is your organization anyhow is using more than 8 Dimension and you want to reflect 9th Dimension value is it the Case,?
Hi DyavariS ,
You please refer any matrix page in the system, for ex. Item by location, see the image below, please check this page in design mode, it will help you to understand how to change field caption dynamicaly.
Thanks.
Thanks for the reply @tanya kharbanda. Here I am doing the task on dimensions. There I Have to display the related values based upon the caption.
Hi,
Why would you want to change the field caption with the value of another table field?
Can you please elaborate more?
You can definitely assign the value of one field to another.
Thanks,
Tanya Kharbanda
Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has a verified answer.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (