How to display the creator email in Journal trxn PL

  • 14 February 2024
  • 1 reply

Userlevel 4

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 WillHowardOpenUni 19 February 2024, 02:42

View original

1 reply

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)




Added to results grid:


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


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