Solved

Email Templates - is it possible to display NOTES inside the message of an email template?

  • 21 November 2023
  • 2 replies
  • 68 views

Userlevel 3
Badge

we have a business event setup to email individuals when they have expense receipts pending their approval. We utilize the ‘NOTES’ section inside specific expense receipts to annotate to users what is missing (cost code, copy of receipt, etc).

When the business event triggers it sends an email template that contains information about the receipt and links them to it. 

Is there a way I can have whatever information is entered into the NOTES section of that expense receipt to appear in that Email Template message body?

From my GI screen, Expense Receipt Approval, I can view the notes on each individual receipt.

Example of what I want to show up in the Email Template message -

 

Example of the email template and where we’d like this to reside -

 

icon

Best answer by darylbowman 21 November 2023, 17:26

View original

2 replies

Badge +11

You can expose NOTES to a GI, and since you’re using a GI as the basis for your email, I see no reason why you couldn’t.

 

  1. Join the PX.Data.Note table to the entity on *entity*.NoteID  Equals  Note.NoteID
  2. Expose the NoteText column to the GI
  3. Use the field in your email
Userlevel 3
Badge

Thank you @darylbowman I just wasn’t sure what table those Notes resided in as the Element Properties don’t quite reflect that. But that worked great.

Reply


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