Attachments

Epicor ERP 10
1

image
image.png161×935 11.5 KB
Our attachments are no longer sorted by group all of a sudden. It seems the setup is correct. We are not sure what the issue may be. Any help would be greatly appreciated. Thank you!

2

Did anything change? Do you have a customization on this form? Does it happen for all tree view nodes for any attachments?

3

Thanks for your response. :slight_smile: Nothing has changed it literally happened out of nowhere. We store the same attachments in many forms. We do not have a customization for this. It does happen for all tree view forms for any attachments.

4

Can I ask how they used to be sorted?

From what I can tell, the sorting of both the tree view is handled by the column Ice.XFileAttach.XFileRefNum in ascending order. In the attachment view, this number will be titled “Reference No”.
image

I would be curious if yours are also sorting in ascending, descending, or some other order. Can you let me know what order they are sorting in on the Reference No column in the attachments view?

5

image
image.png222×761 4.64 KB
image
image.png335×699 4.48 KB
We have document types that we set up in document type maintnence. Our tree veiw used to sort the documents by category. So all images would be in a folder together and the same goes for all the CIR, CSR’s ect and we have it set up this way because we have so many different model numbers and the images ect are different.

6

Can you tell me if your Ice.XFileAttch table IX_XfileAttch_Keys index properties looks like mine?

image
image.png911×664 41.1 KB

Also this one on Ice.XFileRef PK_XFileRef index properties:

image
image.png911×632 54.3 KB

7

2_LI (2)
2_LI (2).jpg1002×616 119 KB
1_LI
1_LI.jpg1002×616 78.8 KB

8

This is what ours looks like. Since we need then grouped could you recommend what we may need to do? Thank you. :slight_smile: