Link between smmActivities table and CustTrans table

(2) Share

Report

Posted on by CN-16071711-0

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!

All responses (2)

Answers (0)

CN-16071711-0 6 on at

Like (0)

Report

Link between smmActivities table and CustTrans table

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)
GirishS 27,825 Moderator on at

Like (0)

Report

Link between smmActivities table and CustTrans table

Hi,

Have you tried joining the tables like below.

CustTrans

CustTable

SmmActivityParentLinkTable

SmmActivities.

Thanks,

Girish S.