Generic Inquiry - Sorting if files are attached
I'm trying to pull the attachment name into the PO GI (PO3010PL).
I found attachments in this table - PX.SM.UploadFileWithIDSelector - which has a convenient NoteID field.
However, this NoteID field is not the same as the NoteID used in PX.Objects.PO.POOrder.
Any ideas on how to join?
If you're looking to join to PX.SM.UploadFileWithIDSelector, I think you should be using FileID and not NoteID. NoteID should be for attaching Notes to File Attachments (hence the Note Icon when you access the File Maintenance screen).
Also, as multiple files can be attached to source documents, there must be another table linking the source documents to the records in PX.SM.UploadFileWithIDSelector
Thanks for the follow up. The only field that looks like a mapping key in PX.SM.UploadFileWithIDSelector is UploadFileWithIDSelector_NoteID. I don't see anything called FileID and in PX.Objects.PO.POOrder, there is only noteID for mapping.
We're in 17R2 if that matters.
The only other way I can see the system linking these if not through the UploadFileWithIDSelector_NoteID field, is the file field which looks like this -
"Purchase Orders (RO S1810024)\Ebay Invoice.pdf"
Are there any good ways to tie these in to a GI for purchase orders?