Filter Records in onLookUp Trigger

Business Central/NAV Developers Forum
1

Hello

I need to fetch data from item table and display it in Purchase Line No OnLookUp where it is filtered by vendor number from Item vendor Table(99) when i raise a Purchase Order.

2

Hi Murali,

U can use this code…Here PurchHeader - (38), ItemVend - (99) , Item -(27)

PurchHeader.SETRANGE(PurchHeader.“No.”,“Document No.”);

IF PurchHeader.FINDFIRST THEN BEGIN

ItemVend.SETRANGE(ItemVend.“Vendor No.”, PurchHeader.“Buy-from Vendor No.”);

Item.RESET;

IF ItemVend.FINDFIRST THEN REPEAT

Item.GET(ItemVend.“Item No.”);

Item.MARK :=TRUE;

UNTIL ItemVend.NEXT=0;

Item.MARKEDONLY:=TRUE;

IF (FORM.RUNMODAL(31,Item) = ACTION::LookupOK) THEN BEGIN

“No.”:=Item.“No.”;

VALIDATE(“No.”);

END;

END;

3

Thanq suresh for ur reply…

still its not filtering, instead displaying all item list

4

Sorry suresh its working perfectly…[:)]Thanq

5

I checked this … Working fine… Only Selected items are filtering

6

Sorry sorry ite working fine…Thanq