Skip to main content
Solved

Files column not showing up in GI when grouping results


We have a GI for contracts that just links the SO and SOLine tables. Earlier this week we were able to see file attachments alongside each line item, but now it has totally disappeared. I have found that when I disable grouping the attachments show again. It only started doing this today and I have no idea what is causing it. 

Best answer by ak68

I did it this way - not perfect but at least you can filter

 

View original
Did this topic help you find an answer to your question?

3 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • November 5, 2021

Hi @eney,

Be sure to specify which of the data access classes to use for attachments.  For example if your GI includes SOOrder and SOOrderLine, you can specify if the attachments should be on the header or the detail record. 

If the Attach Notes To field is set to Not Applicable then the file attachment selector will not be available.  The Attach Notes dropdown option is new to 2021 R1.  

That being said, I don’t think that attachments will work on a GI that also has grouping.  The documents are attached based on the NoteID field for a specific record, and with grouping the row is not a unique record.

Hope that helps!

Laura 


darylbowman
Captain II
Forum|alt.badge.img+13

I was attempting to do this very thing and concluded that it is not possible as well. Then, while trying to solve a different problem, accidentally stumbled upon a way to make it happen. My GI is grouped by InventoryItem.InventoryID and I was trying to enable notes/files for InventoryItem, but couldn’t. When accidentally grouping by InventoryItem.InventoryCD as well, it DOES allow notes/files.

Not having worked with this more, I can’t generalize this to other GIs, but I would expect it has something to do with grouping by the natural key / CD field. 


  • Freshman II
  • 1 reply
  • Answer
  • December 10, 2024

I did it this way - not perfect but at least you can filter

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings