• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

E9.2 UBE to Link new attachments to a PO

Mrdino

Member
We are looking at a 3rd party software for document management. Docs will get created that will need to be attached thru a batch UBE process to JDE PO's. Either the Header or detail.
We plan to incorporate the necessary keys in the pdf name so we know where to link them to such as PO# Type, Co etc..
Question is has anyone written a batch UBE that would read the F4311, (open PO lines), then go see if there is a new attachment (on some server somewhere - TBD) and if so, attach it to the F4311 or F4301 the same way you would manually do it thru the interactive app? Thanks in advance.
 

Abhishek Chhajer

Well Known Member
You can but you probably have to use URL and attach the specific directory path by creating record in media table.
Which document management we are looking at?
 
We are looking at a 3rd party software for document management. Docs will get created that will need to be attached thru a batch UBE process to JDE PO's. Either the Header or detail.
We plan to incorporate the necessary keys in the pdf name so we know where to link them to such as PO# Type, Co etc..
Question is has anyone written a batch UBE that would read the F4311, (open PO lines), then go see if there is a new attachment (on some server somewhere - TBD) and if so, attach it to the F4311 or F4301 the same way you would manually do it thru the interactive app? Thanks in advance.
Hi, I think Bottomline can help you out with your document management. Check them out.
 
Call Orchestrations From Excel – The Easy Way to Make the Orchestrator Work for You.

Larry_Jones

Legendary Poster
We do this but somewhat differently.
Wrote a relative simple VB script called ROBOATTACH that monitors different network file folders for scanned files (A/R Invoices, A/P Vouchers Invoices, Quality Documents, Packing Lists, ...).
The script creates an F00165 entry for each file found and moves the file to the appropriate Media Objects folder.
The only downside to this approach is that its the poor man's approach that relies (in most cases) on the user naming the file appropriately.
We only average 100-200 file attachments a day using this tool.
Not every file name needs to be touched - for example A/R Invoices are generated by BI Publisher and we modified the RD for that to output a file copy with the Invoice # as the name to a specific folder. No touch needed there.
So net, net it doesn't need a UBE or special APIs - just a Media Object Network folder, a matching P98MOQUE entry, insert a Type 5 F00165 record, and move the file to the folder.
 

Aarto

Reputable Poster
Howdy
Another approach is to set up Orchestration to list all files in a folder, tokenize the filenames to get the order type, order number, company keys and then move the file to media objects folder and add F00165 entry (adding to F00165 is quite simple by calling a REST API from orchestration. File handling (list directory, tokenize, move files to meda objects folder) need to be done as custom Groovy functions)
 
Top