Please give me example of AL Code to create Query Object that will give similar results as following simplified SQL Query. Basically need to lookup [Dimension Set Entry]Table to get Dimension values.
Select [No.], [Sell-to Customer No.], (Select [Dimension Value Code] from [Dimension Set Entry] where [Dimension Set ID] = [Sales Invoice Header].[Dimension Set ID] and [Dimension Code] = 'CUSTOMERGROUP') as [Customer Group], (Select [Dimension Value Code] from [Dimension Set Entry] where [Dimension Set ID] = [Sales Invoice Header].[Dimension Set ID] and [Dimension Code] = 'DEPARTMENT') as [Department] From [Sales Invoice Header]
Hi, Unfortunately, as far as I know, it is not possible to use Query to do what you see in the Excel table.
Because you mentioned Customer Group, Department is not a column in the table.
You can do the following:
Hope this helps.
Thanks.
ZHU
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
3,951
Share
Report
All responses (
Answers (
