Skip to main content

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.

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