Microsoft Dynamics NAV (Archived)

SetRange

(0) Share

Report

Posted on by jsshivalik

3,099

In the below Code how SetFilter works. Do i need to define SLine as Array or it will work perfectly.

Sale Invoice Line - OnAfterGetRecord()
Qty := 0;

SILine.SETFILTER("Document No.",'%1',"No.");
SILine.SETFILTER(SILine."Posting Date" , '<%1' , AsDate);
IF SILine.FINDFIRST THEN REPEAT
Qty += SILine.Quantity;
UNTIL SILine.NEXT=0;

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

You need to define SILine as local or global variable. Array concept is different and no need here.

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report

Hi,

SlLine will be a global or local variable of type-record (table name).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

....except that in this example you are filtering the field Document No. in the SILine-variable that you have created on the field No. in the Sales Invoice Line itself (which stands for the Item No., G/L: account No., Resource No,).

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

ok. Can u please tell me in my case how SetFilter will work. I have defined it as Global

Thanks

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

what do you mean by how setfilter will work?

Was this reply helpful? Yes No
Verified answer

Tina Menezes 2,582 on at

Like (1)

Report

Hi,

1. SILine.SETFILTER("Document No.",'%1',"No.");

The above line basically filters out and selects those records where the 'Document no' of sales invoice line is equal to the 'No' of your next table which I assume is your header table.

2. SILine.SETFILTER(SILine."Posting Date" , '<%1' , AsDate);

Here Setfilter filters out and selects those records where the sales invoice line 'Posting date' is less than your field 'AsDate'.

Was this reply helpful? Yes No