How to Apply filter in Coll Table

Discussion in 'Free Source Codes' started by Rishi kumar, Feb 6, 2024.

    
  1. Rishi kumar

    Rishi kumar Member


    Dear Expert,
    I have created some Fields in Memo Vch Like ; AwbBill and others
    i have made entry in memo vch and allotted awb bill :1 to Customer A like wise I made 20 entry and awb bill 1 to 10 allotted to Customer A and 11 to 20 to Customer B.
    after That i have created a Coll Table. code is below.
    this table is working fine ,no problem
    [Collection: AWB List Coll]
    Title:Title:"List Of AWB"
    Type: VOUCHERs:VoucherType
    Child Of:$$VchTypeMemo
    Belongs To:Yes
    Fetch:AWBILLNO,AWBILLDate,SectorCode,Sector,Shipper,FlightDte,Dest,Pack,pcs,Weight,BookedWt,CAmount,NETWORK
    Format:$AWBILLNO,15
    Format:$AWBILLDate,10
    Format:$Dest,15
    Format:$Weight,10
    Format:$CAmount,10
    Format:$NETWORK,15

    I have attached is table in sales Vch (Acc Invoice ) on particular field.after selection of Party Ledger Name( Customer A , Customer B)
    this Table shows all 20 AwbBill , I want when i select Customer A then show only those AwbBill allotted to Customer A and like wise for customer B.
    Second If I select awb bill 1 in entry and saved then in second entry AWbBill dont show.
    pls advice

    Thanks & Regards
    Rishi
     


  2. vishnu joshi

    vishnu joshi Member


    ;Add Filter

    [System : Formula]
    CurrPartyName : #PartyNameField=$PartyLedgerName

    ;PartyNameField is Your Selection party field name
     


  3. Rishi kumar

    Rishi kumar Member


    Thanks
    Pls say how to do second one filter .

    Thanks
    Rishi
     


  4. vishnu joshi

    vishnu joshi Member


    ;Add new filter same like this

    add:filter:Filter1,Filter2
     


  5. Rishi kumar

    Rishi kumar Member


    Dear
    I am asking second filter formula.
    Formula me Kya likhe.

    Jo awbbill used ho gya ho vo list me show na ho.
     


  6. vishnu joshi

    vishnu joshi Member


    wo kaha use huaa hai ye kaise pata hoga...
     


  7. Rishi kumar

    Rishi kumar Member


    Suppose
    Two udf hai.
    Udf1 udf 2
    Udf 1 vo udf hai jo coll table me hai.
    Fomate: udf1 ( list of all AWB bills)

    Second udf vo hai jahan hun show table kar ke awbbill save karte hai.
    Ab jo awbbill no udf1 or udf2 dono me ho vo awb bill list se hat jaye...
    I think Mai samjha paya hun
     


  8. Rajat Agarwal

    Rajat Agarwal Member


    Filter ka formula mei kya code diya hai
     


  9. Rishi kumar

    Rishi kumar Member


    [
    [ sys: formula]
    Awbfilter: $shipper=#EI CONSIGNEE

    YE DIYA KAAM HO GAYA...
     
    Vineet Jindal and Rajat Agarwal like this.


Share This Page