web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Link between smmActivi...
Finance | Project Operations, Human Resources, ...
Unanswered

Link between smmActivities table and CustTrans table

(2) ShareShare
ReportReport
Posted on by CN-16071711-0 6
Hello,
 
I am attempting to build a report that shows smmactivities based on customer account and also based on invoice. 
 
I was able to connect the activity to the customer account by the following:
1. smmactivities.activitynumber > smmactivitiesparentlink.activitynumber
2. smmactivitiesparentlink.refrecid > custtable.recid
 
However, I am not able to find a link to the custtrans table. I have read forums that the state the SmmActivityParentLinkTable.RefRecId column is related to the CustTrans.recid column. However, this method does not pull the correct invoice into view.
 
Any help that you can provide is appreciated!
I have the same question (0)
  • GirishS Profile Picture
    GirishS 27,843 Moderator on at
    Hi,
     
    Have you tried joining the tables like below.
    CustTrans
    CustTable
    SmmActivityParentLinkTable
    SmmActivities.
     
    Thanks,
    Girish S.
  • CN-16071711-0 Profile Picture
    CN-16071711-0 6 on at
    Thanks for the reply.
     
    Yes, I have tried to find a connection but the only ones I can find are below. 
    1. smmactivities.activitynumber > smmactivitiesparentlink.activitynumber
    2. smmactivitiesparentlink.refrecid > custtable.recid
    3.custtable.accountnum > custtrans.accountnum (which does not tie it to the specific invoice, only the customer acccount number)
     

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 692

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 532 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 478

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans