Skip to main content
Solved

How to display the creator email in Journal trxn PL

  • February 14, 2024
  • 1 reply
  • 31 views

Forum|alt.badge.img
  • Semi-Pro II
  • 252 replies

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.

View original
Did this topic help you find an answer to your question?

1 reply

WillH
Varsity II
Forum|alt.badge.img+1
  • Varsity II
  • 58 replies
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings