Questions Generic Inquiry - Sorting if files are attached

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

Hi Royce,

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?

Thanks!

-Matt

Try joining from PX.Objects.PO.POOrder to PX.Data.NoteDoc on POOrder.NoteID=NoteDoc.NoteID.

Then join from PX.Data.NoteDoc to PX.SM.UploadFile on NoteDoc.FileID=UploadFile.FileID.

The file name should be in UploadFile.Name. You can use a formula if you only want the stuff after the \

That did it! Thanks Tim!!

Any sage words on how I could have figured that out?

@timrodman

Hello Tim

Could you please advise what the formula would be to use to achieve this: "You can use a formula if you only want the stuff after the \"?

Thanks. 

I was thinking something like this:

=Substring([UploadFile.Name],InStr([UploadFile.Name],'\\')+1,100)