Options

Table Filter

schoolkidschoolkid Member Posts: 103
Hi,

I have a field in the Vendor Table called Type where it has values Stock and Non Stock.

on the purchase order form i want to show only vendors with type Stock and on the invoice form it should show vendors with Non Stock values only..i gave a filter on the buy from vendor field in Purchase lines tables..but it seems not to work ?

can you please tell me how i can acheive this with filters ?

Thanks in advance

Comments

  • Options
    vijay_gvijay_g Member Posts: 884
    The lookup on "Buy form vendor No." happens with table relation set to vendor if you want to lookup with filter on order and invoice then you have to lookup it by code.
    if Rec."Document Type" = "Document Type"::order then begin
       Vend.SETRANGE(Type,Vend.Type::stock);
       form.runmodal(0,vend)...............
       .............................................
    end else 
    if Rec."Document Type" = "Document Type"::invoice then begin
       Vend.SETRANGE(Type,Vend.Type::Nonstock);
       ............................................................
    end;
    
  • Options
    schoolkidschoolkid Member Posts: 103
    thanks a lot for the help i got it Solved.....
Sign In or Register to comment.