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)

Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report

Hi,

Can you give me an example with screenshot to understand the problem in detail?

Thanks

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

Like (0)

Report

Sure, as you can see on pic, I have created an "Attachment" field. I'm trying to make it as flowfield so it can change to TRUE when a external document is been linked to order otherwise always show be FALSE.

If you have other ideas, I will be more than happy to heard them.

Thank you.

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

I would not be possible using the flowfield, you need to write code on the page.

OnAfterGetRecord Trigger.

RecRef.GETTABLE(Vendor);

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

IF RecordLink.FINDFIRST

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

Like (0)

Report

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
Suggested answer

ManishS 86 on at

Like (0)

Report

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
ManishS 86 on at

Like (0)

Report

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
spyroot 1,647 on at

Like (0)

Report

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
Suggested answer

Mouli Kaku 517 on at

Like (0)

Report

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

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

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