Filter Not working

Discussion in 'Tally Developer' started by surendra19, Aug 11, 2019.

    
Tags:
  1. surendra19

    surendra19 Member


    Dear Experts,

    I want to print the Stock Item details from batch allocation in sale invoice, but the details are not filtering item wise. Here is tried code for your reference.

    [#Line: EXPINV InvDetails]

    Explode: Myexplodeline

    [Part: Myexplodeline]
    Line: myline1
    Repeat : myline1 : MyCollection10

    [Line: myline1]
    Field: Thanfld,Symbol1fld,Lengthfld,Symbol2fld,Qtyfld, StkItemfld

    [Field:Thanfld]
    Use: Name Field
    Set as:$TotThan
    Indent: 5
    Width: 8
    Style: Normal Italic

    [Field: Symbol1fld]
    Use: Name Field
    Set as:"x"
    Width: 4
    Style: Normal Italic

    [Field: Lengthfld]
    Use: Name Field
    Set as:$TotLength
    Width: 4
    Style: Normal Italic

    [Field: Symbol2fld]
    Use: Name Field
    Set as:"="
    Width: 4
    Style: Normal Italic

    [Field: Qtyfld]
    Use: Name Field
    Set as:$TotMtr
    ;Indent: 2
    Style: Normal Italic

    [Field: StkItemfld]
    Use: name field
    Set as: $$ExplodeOwner:$StockItemName
    Invisible: Yes



    [Collection:MyCollection10]
    Source Collection:..
    Walk:Inventory Entries,Batch Allocations
    Compute: TotThan :$VPack
    Compute: TotLength :$ItemBharti
    Compute: TotMtr :$BilledQty
    Compute:StName:$..StockItemName
    Filter:MyFilter

    [System:Formulae]
    MyFilter:$StName = #StkItemfld

    Requested to kindly help me in this regard.

    Thanks in Advance
     


  2. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Compute:StName:$..StockItemName

    Why two Dots.?
     


  3. surendra19

    surendra19 Member


    Jai Sir, I have used two dots to access the Stock Item Name from its Parent object, but its not working, please tell me where is mistake.
     


  4. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    $Name:Stockitem:$StockItemName
     


  5. surendra19

    surendra19 Member


    Jai Sir, now its filtering item wise detail properly, thank you very much for solution.

    Regards
     


Share This Page