News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to join TrvExpGues...

Microsoft Dynamics AX (Archived)

How to join TrvExpGuest table to the expense number?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi All,

I am hoping somebody can shed some light onto this for me.

We are using Dynamics AX 2012 R2 and I am trying to retrieve the expense details (which is not a problem) as well as the actual Attendees (Guests) but I am not able to locate a join.

Looking at AX (right click "personalize") on the Guests field I see that the actual relation is driven by some kind of a function

Would anybody be able to tell me how I can join the data from the TrvExpGuest table to the other expense claim data?

many thanks!

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: How to join TrvExpGuest table to the expense number?

Hi,

Maybe the following screenprint helps

Best regards,

Ludwig
Suggested answer

Satish Panwar 14,645 on at

Like (0)

Report

RE: How to join TrvExpGuest table to the expense number?

Hi M84AB1,

Expense report line and TrvExpGuest is linked through another table "TRVEXPTRANSGUEST". This table hold RecId from TrvExpGuest and TrvExpTrans table. So your join look something like this:

TrvExpGuest.RecId = TRVEXPTRANSGUEST.TrvExpGuest && TrvExpTrans.RecId = TRVEXPTRANSGUEST.TrvExpTrans

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans