Skip to main content
Answer

How to display the creator email in Journal trxn PL

  • February 14, 2024
  • 1 reply
  • 43 views

Forum|alt.badge.img

Hello All,

I have been trying to display the email accounts of the users who have created a Journal Entry/Journal Transactions. I am not able to do. I tried to create joins between Batch & BAccount and then between BAccount & Contact and then making Contact.Email visible in the Gi but this displays the email id of the particular branches instead of the creators who created the record. How can I achieve this?

 

Thanks in advance.

Best answer by WillH

Hi @Harry ,

Have you tried using the “CreatedBy” from the Batch to join to the Users table?

(It comes up as an option using Add Related Table)

 

Joined:
 

 

Added to results grid:

 

If you’re trying to audit user activity then you’d usually be looking to join to Users, not BAccount.

1 reply

WillH
Varsity III
Forum|alt.badge.img+3
  • Varsity III
  • Answer
  • February 19, 2024

Hi @Harry ,

Have you tried using the “CreatedBy” from the Batch to join to the Users table?

(It comes up as an option using Add Related Table)

 

Joined:
 

 

Added to results grid:

 

If you’re trying to audit user activity then you’d usually be looking to join to Users, not BAccount.