184
I want to create query to get the customer and its default dimension, I just can not figure out how I can link them using the tableID I tried to create a variable to get the tableNo but it does not accept variables in the dataitemLink property.
Is there any way i can do this ?
Thanks for your answer, I solved it like this
dataitem(Default_Dimension; "Default Dimension")
{
DataItemLink = "No." = Customers."No.";
DataItemTableFilter = "Table ID" = const(18); // here
column(Dimension_Code; "Dimension Code") { }
column(Dimension_Value_Code; "Dimension Value Code") { }
column(No_; "No.") { }
}
is it good?
The best way to solve this is to use the DimensionManagement codeunit. That codeunit have function where you can send in the dimension set ID from the customer and get a dimension set as a return value.
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
Share
Report
All responses (
Answers (