We are currently outputting to CSV from the manual supplier invoices screen.
The invoices often have documents attached.
I would like the output CSV to contain a hyperlink to the attachment so user can select the link and open a click 2 run session to see the attachment.
Is that possible? If so.. how?
Best answer by pwlm
Hi
So you have supplier invoices with Document Attachments, you want to output a spreadsheet containing the supplier invoice data PLUS a column with a URL/hyperlink to the Document Management record(s) connected…
If I have understood correctly then I would propose a compromise:
Rather than a link to the document(s) include a link to the Manual Supplier Invoice - you could create a custom field to display this on screen and then using Output Channels would work.
I think Apps 10/Aurena/Excel you may be able to use OData feeds to do this but I am not sure if this provides native links back to application.
Does this help?
Pete
+16Hi
Do you want to add a hyper link of the csv file to a mail body ?
+31Hi
I am assuming you are using Output channels. Output Channels are mostly used to create output files using the data already seen in an Enterprise Explorer table window or a form window. The reason behind this is that the extracted data needs to be formatted in the client before converting into an output channel and that is a costly operation. Therefore I don’t think what you are trying to do is possible.
You can refer to the documentation regarding Output Channels here:
Hope this helps!
+11Hi
So you have supplier invoices with Document Attachments, you want to output a spreadsheet containing the supplier invoice data PLUS a column with a URL/hyperlink to the Document Management record(s) connected…
If I have understood correctly then I would propose a compromise:
Rather than a link to the document(s) include a link to the Manual Supplier Invoice - you could create a custom field to display this on screen and then using Output Channels would work.
I think Apps 10/Aurena/Excel you may be able to use OData feeds to do this but I am not sure if this provides native links back to application.
Does this help?
Pete
Thanks Pete, yep that is what I, trying to achieve.
Wondering,how would the custom field display the document hyperlink?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
