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...
Appearance of Notes...
 
Notifications
Clear all

Questions Appearance of Notes and Attachment action icons in query results

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Andy Katz 5 months ago
11 Posts
6 Users
8 Reactions
4,635 Views
RSS
Royce Lithgo
Posts: 557
 Royce Lithgo
Topic starter
October 2, 2018 8:10 pm
(@roycelithgo)
Honorable Member
Joined: 5 years ago

Some of my GIs automatically included icons for Attachments and Notes in the query results.

Example:

I didn't do anything in particular to make this happen - it is automatic.

Another GI of mine does not do this but I want it to. I want the notes from the Inventory Register (INRegister) table to appear in the query results. The GI is based off this table, but the Notes and Attachment columns do not show. What is it that controls whether Notes and Attachment action icons appear in query results?

10 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
October 8, 2018 2:35 pm
(@timrodman)
Famed Member
Joined: 10 years ago

I think uses the Object on the first line that you list on the RESULTS GRID tab.

In my example below, ARTran is the first line so if I view the inquiry, then click the NOTES icon and type something, it stores the note on the AR Invoice Line.

But if I move an ARInvoice line to the top and view the inquiry again, then click the NOTES icon and type something, it stores the note on the AR Invoice Header.

Reply
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 5 years ago

Honorable Member
Posts: 557
October 8, 2018 5:47 pm
Reply toTim RodmanTim Rodman

My query is based off INRegister and it is the first table in the results grid but notes are not showing for it. Issues, Receipts etc. are all saved in that table and notes are enterable on the relevant pages but doesn't seem like they can be viewed in Generic Inquiry.

Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
October 18, 2018 8:35 am
(@timrodman)
Famed Member
Joined: 10 years ago

Seems to be working ok for me. I entered a note on the Issues (IN302000) screen and it appears on my Generic Inquiry:

 

Here is the definition of my Generic Inquiry:

Reply
Royce Lithgo
Posts: 557
 Royce Lithgo
Topic starter
October 21, 2018 11:49 pm
(@roycelithgo)
Honorable Member
Joined: 5 years ago

Your query works for me too. But I have other queries that use INRegister and don't show the notes or attachment columns. 

I think I know why, when you add a field to the Grouping tab, it stops including the Notes and Attachments. Makes sense, but not obvious. 🙂

Reply
Wyatt.ERP and Adam Brunner reacted
Adam Brunner
 Adam Brunner
(@abrunner)
Joined: 5 years ago

Eminent Member
Posts: 14
November 12, 2020 4:28 pm
Reply toRoyce LithgoRoyce Lithgo

@roycelithgo good find! I was digging trying to figure out the same thing. You saved me a good amount of time.

Reply
Royce Lithgo reacted
Wyatt.ERP
 Wyatt.ERP
(@wyatt-erp)
Joined: 5 years ago

Estimable Member
Posts: 128
November 12, 2020 4:59 pm
Reply toRoyce LithgoRoyce Lithgo

@roycelithgo Ah-ha that grouping was it, what a bother!

Reply
Tim Rodman, Adam Brunner and Royce Lithgo reacted
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
October 25, 2018 8:24 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Ah, yes, that would make sense.

Reply
ddunn
Posts: 3
 ddunn
June 16, 2022 11:53 am
(@ddunn)
Active Member
Joined: 5 years ago

Just as an update for this thread, there is a dropdown in the summary area of the GI where you can indicate what record that the notes column should refer to:

image
Reply
Adam Brunner reacted
Royce Lithgo
 Royce Lithgo
(@roycelithgo)
Joined: 5 years ago

Honorable Member
Posts: 557
November 15, 2022 12:55 am
Reply toddunnddunn

@ddunn I finally got around to testing this and unfortunately still no notes when Grouping is enabled. I even tried including the relevant NoteID in the group fields but Notes (& Attachment) columns are suppressed.

Reply
Tim Rodman reacted
Andy Katz
Posts: 3
 Andy Katz
February 18, 2025 1:51 pm
(@akatz)
New Member
Joined: 6 months ago

@ddunn @roycelithgo Just a quick update on this: I just did this in 2024R2, copied an existing GI for appointments in service, mine did not include Notes or Attachments in the UI of the GI.

When I used the suggestion by @ddun on the Attach Notes To: in the header, it worked, even though two fields exist in the Grouping tab.

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,521 Topics
  • 10.9 K Posts
  • 12 Online
  • 2,321 Members
Our newest member: Courtney Wilder
Latest Post: Can UDFs be populated using an Import Scenario?
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.

‹›×

    ‹›×