Link feature on NAV 2013

(0) Share

Report

Posted on by spyroot

1,647

Hello Folks,

Is there a way to show end user when a document (SO, PO, etc.) have a file attached on same page? At this point, end users must click the link button to find out if attachment exist or not.

I try to create a flowfield variable but I can't find the way to associate the Purchase table with the Record Link Table 2000000068.

Any suggestions are more than welcome.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

spyroot 1,647 on at

Like (0)

Report

RE: Link feature on NAV 2013

That works!!!

You made my day, thank you so much.

Was this reply helpful? Yes No
Verified answer

ManishS 86 on at

Like (0)

Report

RE: Link feature on NAV 2013

Instead of RecRef.GETTABLE(PurchHdr) write RecRef.GETTABLE(Rec);

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (0)

Report

RE: Link feature on NAV 2013

Thank you Mouli for the help, but on my scenario I'm trying to use the link feature located on top ribbon that comes with NAV2013. The code you provide may not work.

Was this reply helpful? Yes No
Suggested answer

Mouli Kaku 517 on at

Like (0)

Report

RE: Link feature on NAV 2013

Hi Alex,

This is my working Code

Sales Shipment Header - OnAfterGetRecord()

IF NOT "Sales Shipment Header".HasPoDRecordLink THEN BEGIN

PoDFilepath := "S&RSetup"."Network Save Folder Path" + 'PoDs\' + "Sales Shipment Header"."No." + '.pdf';

IF EXISTS(PoDFilepath) THEN BEGIN

"Sales Shipment Header".ADDLINK(PoDFilepath,'POD');

LinkCount += 1;

END;

END;

HasPoDRecordLink() : Boolean

IF NOT HASLINKS THEN

EXIT(FALSE);

RecordRef.GETTABLE(Rec);

RedId := RecordRef.RECORDID;

RecordLink.SETRANGE("Record ID", RedId);

RecordLink.SETRANGE(Description,'POD');

EXIT(NOT RecordLink.ISEMPTY);

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (0)

Report

RE: Link feature on NAV 2013

I'm getting below error under EXIT(FALSE) with your suggestion, sorry

Was this reply helpful? Yes No
Suggested answer

Mouli Kaku 517 on at

Like (0)

Report

RE: Link feature on NAV 2013

Try This

HasPoDRecordLink() : Boolean

IF NOT HASLINKS THEN

EXIT(FALSE);

RecordRef.GETTABLE(Rec);

RedId := RecordRef.RECORDID;

RecordLink.SETRANGE("Record ID", RedId);

RecordLink.SETRANGE(Description,'POD');

EXIT(NOT RecordLink.ISEMPTY);

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (0)

Report

RE: Link feature on NAV 2013

Manish,

Something I'm missing because still not working for me. Below is the code I wrote as suggested on purchase header PAGE and not on table:

here are my global variables:

Link exist on purchase order:

Dynamic field is not behaving as suppose to :(

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: Link feature on NAV 2013

You need to write code OnAfterGetRecord of purchase header table.

Rather than passing a local variable of purchase header pass Rec (Current record).

Was this reply helpful? Yes No
Suggested answer

ManishS 86 on at

Like (0)

Report

RE: Link feature on NAV 2013

I tried this and working.

Attachment := FALSE;

RecRef.GETTABLE(PurchaseHeader);

RecordLink.SETRANGE("Record ID",RecRef.RECORDID);

RecordLink.SETRANGE(RecordLink.Type,RecordLink.Type::Link);

IF RecordLink.FINDFIRST THEN

Attachment := TRUE;

Was this reply helpful? Yes No
spyroot 1,647 on at

Like (0)

Report

RE: Link feature on NAV 2013

Manish,

The table should be purchase header and not vendor table right?

Even that way is not working. What I'm missing?

I have declared below variables:

This is the code

RecRef.GETTABLE(PurchHdr);

RecordLink.SETRANGE("Record ID",RecRef.RECORDID);

IF RecordLink.FINDFIRST then

"attachment box" := TRUE

ELSE

"attachment box" := FALSE;

Was this reply helpful? Yes No