Solved

How to display the creator email in Journal trxn PL

  • 14 February 2024
  • 1 reply
  • 28 views
H
Rank
Userlevel 4
Badge

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.

icon

Best answer by WillHowardOpenUni 19 February 2024, 02:42

View original

1 reply

W
Rank

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


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved