AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
Attaching Notes in ...
 
Notifications
Clear all

#AcumaticaTnT Attaching Notes in a Generic Inquiry

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Julie Baker 4 months ago
9 Posts
6 Users
6 Reactions
2,694 Views
RSS
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
Topic starter
February 18, 2021 1:56 am
(@timrodman)
Famed Member
Joined: 10 years ago

I'm going through the Acumatica 2021 R1 Release Notes.

There is a new field called Attach Notes To on the Generic Inquiries (SM208000) screen:

image

 

This allows you to control what entity the note gets attached to when you click the note icon in the Generic Inquiry:

image

John Rubidge reacted
8 Replies
Royce Lithgo
Posts: 557
 Royce Lithgo
February 22, 2021 6:54 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

Good news. Wonder if this works when you use aggregates and groups. 


Reply
Tim Rodman reacted
Victoria Johnson
Posts: 1
 Victoria Johnson
February 16, 2023 2:09 am
(@victoria-johnson)
New Member
Joined: 4 years ago

This is great! ... but, when adding the GI to a dashboard widget, the notes get stripped away. ? ? That's what I need, a way to add the notes to the Data Table widget.  Any suggestions? 


Reply
Royce Lithgo
Posts: 557
 Royce Lithgo
February 16, 2023 5:15 pm
(@roycelithgo)
Honorable Member
Joined: 6 years ago

You can add the note text as a result column on your GI and display it on the Data Table widget.


Reply
Tim Rodman reacted
Julie Baker
Posts: 3
 Julie Baker
July 9, 2025 5:11 pm
(@jbaker)
New Member
Joined: 12 months ago

Came across this thread while attempting to add Notes from the upper right corner of the Projects screen to my GI. It appears I have done as instructed (see screenshot), but no data appears in the GI results. If I'm missing something or need to link to another table using NoteID, please advise. Thank you!

 

ProjectSummaryGI

 


Reply
alconroy
 alconroy
(@alconroy)
Joined: 4 years ago

Eminent Member
Posts: 32
July 11, 2025 5:23 am
Reply toJulie BakerJulie Baker

@jbaker they should appear to the left of the results beside attachments

image

Reply
Julie Baker
Posts: 3
 Julie Baker
July 14, 2025 8:49 pm
(@jbaker)
New Member
Joined: 12 months ago

Like @victoria-johnson, while seeing that a note exists could be useful I mainly want to include the notes in a GI used in a dashboard widget or even to export to Excel. Per @roycelithgo this should be possible: You can add the note text as a result column on your GI and display it on the Data Table widget.

I tried to do this using =[PMProject.NoteText] in the data field of my GI, but it comes up blank. If it is indeed possible to include the text (even truncated if there is a limitation), please share the exact field value I should use, or the table I should add to the GI to pull that data--it's been a challenge figuring out where that data is stored. Thank you!


Reply
Anne Trockman
 Anne Trockman
(@anne-r-trockman)
Joined: 6 years ago

Active Member
Posts: 7
July 15, 2025 12:27 pm
Reply toJulie BakerJulie Baker

@jbaker - we have done this successfully by adding the Px.Data.Note table to the GI. Perhaps it's the join or the relationship to the fields that is not correct. 

Relation: Parent Table: PMProject, Child Table: Px.Data.Note. Inner Join. Relation = noteID is the parent and child field for both.

Then on the GI Results Grid, add Note as the object and Note Text as the field. 

Our "Attach notes to" at the top of the GI is empty... we aren't using that field.

 


Reply
Tony McCormick and Julie Baker reacted
Julie Baker
 Julie Baker
(@jbaker)
Joined: 12 months ago

New Member
Posts: 3
July 15, 2025 3:24 pm
Reply toAnne TrockmanAnne Trockman
Julie Baker

@anne-r-trockman That worked-thank you very much!


Reply
Anne Trockman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 37 Online
  • 2,412 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×