How to create a hperlink for attached documents in sales orders?

(0) Share

Report

Posted on by manish.yadav

1,865

Dear Experts,

Is there any possibility to save a hperlink for attached documents in sales orders, and send it to its next documents(Production Order) for further reference. Because we don't want to share the sales order to production department, only want to share the attached "EXCEL Sheet".

7674.test01.png

*This post is locked for comments

All responses (8)

Answers (0)

manish.yadav 1,865 on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

As per my screen shot I have added a link in my sales order. How can I display it in report.

To resolve it, i have develop the new report, and add the data item...but there is no effect.
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

Variable with type RecordRef
manish.yadav 1,865 on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

Here what is "RecRef"....
manish.yadav 1,865 on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

We are using the Incoming Documents Utility but my requirement is I want to show the attached file in production order related to its Sales Order.
Suggested answer

GDP 272 on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

If you are using NAV 2016 then you can also use Incoming Documents Utility.
manish.yadav 1,865 on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

Let me try. i will give you the feedback asap.
Suggested answer

Andrey Baludin 3,941 on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

Hi!

You can get record link next way:

SalesHeader.GET("Document Type", "No.");

If SalesHeader.HASLINKS THEN BEGIN

RecRef.GETTABLE(SalesHeader);

RecordLink.SETFILTER("Record ID", FORMAT(RecRef.RECORDID));

If RecordLink.FINDFIRST then

RecURL := RecordLink.URL1;

END;

Record Link is a table 2000000068

After that pass RecURL to your report
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (0)

Report

RE: How to create a hperlink for attached documents in sales orders?

This is stored in Record Link table. You need to write custom code for transferring that data.