News and Announcements icon

Dynamics 365 CommunityForums Finance forum How to get the desired...

Finance forum

Answered

How to get the desired Channel (SalesTable) field lookup in view?

(0) Share

Report

Report

Posted on by Harshal Jain

162

Hi ,

Due to certain requirements I have put the SalesTable and RetailChannelTable with inner join in a view. This view I am using in query.

I am trying to get this channel name in my view lookup.

But when I use my view in query, it only gives the rec-id in the lookup. Any way I can get the name(highlighted column) in my lookup.

Categories:

Development / Customization / SDK

All responses Img

All responses (3)

Answers Img

Answers (1)

Harshal Jain 162 on at

Like (0)

Report

How to get the desired Channel (SalesTable) field lookup in view?

I got the field but the lookup is not coming. In view i can see the values but in filter query there is no lookup. ALso the OperatingUnitId field in RetailChannel field is reference rec id but in filter query the plus sign is there, but no lookup comes. Can you help?
Hana Xue Microsoft Employee on at

Like (0)

Report

How to get the desired Channel (SalesTable) field lookup in view?

Hi,
It seems that you have solved the problem yourself, and thank you for sharing.
Hana
Verified answer

Harshal Jain 162 on at

Like (0)

Report

How to get the desired Channel (SalesTable) field lookup in view?

Got the ans to this. I added OMOperatingUnit table with inner join to RetailChannelTable and got the channel Name

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2

Martin Dráb 227,996 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans