In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Appearance of Notes and Attachment action icons in query results
Some of my GIs automatically included icons for Attachments and Notes in the query results.
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?
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.
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:
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. 🙂
Ah, yes, that would make sense.
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: