Bring Current UserID into RDD

Epicor ERP 10
,
1

I would like to be able for Current Epicor Session User email address to be available in SSRS Breaking/Routing.

OrderAck form is being emailed to a customer through SSRS Breaking/Routing.

If I can find a table to include in RDD that contains information about current session UserID, I can create a relationship of that table and UserFile table to get an email address.

Which table available for RDD contains this information and how can I link it with OrderHed?

I’ve tried SysAgent, SysRptLst, SysTask, and UserComp. Does not seem to be working.

CallContextClientData table can bring CurrentUserID into RDL but how do you make it available in Routing?

2

You should be able to use the UserComp table with the criteria DcdUderID = BAQ Constant and choose CurrentUserID. You can then link that to UserFile DcdUserID = DcdUserID and pull the EMailAddress field from UserFile

image
image972×366 14.4 KB

image
image997×290 10.8 KB

1 Like
3

You need to link on the UserFile or UserFileList to Calc_RptUserID

image
image1230×854 155 KB

1 Like
4

I believe they were asking about APR not a BAQ, but good info here :slight_smile:

5

I want this too. Have never yet been able to figure out a way to do it in a table based RDD.

6

If you pull it into the BAQ Report, you can then use a report style to break on it and email to it

7

Order ack is not a baq report.

8

I gave the answer as I just did this about 2 months ago for AR Form…

9

My reading comprehension is obviously not back from the weekend.

1 Like
10

I don’t know if that field exists in order ack rdd, interesting idea.

I’m not seeing it anywhere.

11

That’s a new trick for me. How do you get the Calc_RptUserID on the Customer Table?

12

It’s a black box, if Epicor hasn’t put it as part of the base rdd you can’t add it.

13

without that, Clint’s solution will not work

14

Exactly.

15

Should be able to use ChangedBy linked to UserFile.

16

That is not necessarily the same as the person printing it though. Can also use entered by. But sometimes that isn’t the requirement.

17

image
image791×530 53 KB

No such Links available

18

Agree I’m looking now to see if that information exists.

19

I found out that sometimes different people enter orders, and different contact the customer. that’s why I would like to have the current session user to get a copy of an order, not necessarily a person who entered it.

1 Like
20

this solution works perfectly in ARForm, Thank YOU!!! (that’s next on my list and it’s solved already :sparkler:
unfortunately it doesn’t work the same in OrderAck :worried:

1 Like