1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to Filter Customized Report value?

Discussion in 'Tally Developer' started by manjari m, Nov 8, 2014.

    
  1. manjari m

    manjari m New Member


    Dear Experts.,

    I created one report for display all bills., This TDL works fine., but i want to filter particular Invoice using Ref.No., i have created one button for filter Invoice., but i don't know how to filter Invoice from sub form., please help me as soon as possible., Here i include my TDL as well as screenshot.,

    [​IMG]

    [#Menu:GatewayofTally]
    Add:Item:Invoice History:Display:Invoice History

    [Report:Invoice History]
    Form:Receivable Form
    Title:"INVOICE HISTORY"

    [Form:Receivable Form]
    Use:DSP Template
    Parts:Receivable Part
    Width:100% Screen
    Height:100% Screen
    Button:Invoice Btn
    Background:Light Lily White

    [Part:Receivable Part]
    Lines:Receivable Title,Receivable Line
    Bottom Line:Receivable Total Line
    Repeat:Receivable Line:InvoiceBill
    Total:Receivable Amount, Receivable BC, Receivable l30, Receivable l60, Receivable l90, Receivable G90
    Common Border:Yes
    Scroll:Vertical

    [Line:Receivable Title]
    Use:Receivable Line
    Local:Field:Default:Type:String
    Local:Field:Default:Align:Center
    Local:Field:Default:Style:Normal Bold
    Local:Field:Receivable Date:Set as:"Date"
    Local:Field:Receivable RefNo:Set as:"Ref No"
    Local:Field:Receivable Party:Set as:"Party Name"
    Local:Field:Receivable Amount:Set as:"Bill Amount"
    Border:Thin Top Bottom


    [Line:Receivable Total]
    Local : Field : Receivable Amount : Set as: $$Total:ReceivableAmount

    [Line:Receivable Line]
    Fields:Receivable Date, Receivable RefNo, Receivable Party, Receivable Amount

    [Field : Receivable Date]
    Use : Short Date Field
    Set As : $BillDate
    Align:Left
    Width:10

    [Field : Receivable RefNo]
    Use : Name Field
    Set As : $Name
    Align:Left
    Width:10

    [Field : Receivable Party]
    Use : Name Field
    Set As : $DSPAccName:Ledger:$Parent
    Align:Left
    Width:25

    [Field : Receivable Amount]
    Use : Amount Field
    Set As : $OpeningBalance
    Format : "CRDR"
    Align:Right
    Width:15

    [Line:Receivable Total Line]
    Use:Receivable Line
    Border:Full Thin Top
    Local : Field : Receivable Party : Set as: $$LocaleString:"Grand Total"
    Local : Field : Receivable Amount : Set as: $$Total:ReceivableAmount

    [Button:Invoice Btn]
    Key:Alt+I
    Action:Execute:Invoice Rpt
    Title:Find Invoice

    [Report:Invoice Rpt]
    Form:Invoice Frm
    Title:Find Invoice
    Filter:$Reference

    [Form:Invoice Frm]
    Part:Invoice Prt
    Add : On : Form Accept : yes :Message Box

    [Part:Invoice Prt]
    Line:Invoice Ln

    [Line:Invoice Ln]
    Field:Medium Prompt, Invoice Fld
    Local:Field:Medium Prompt:Set as:"Invoice No"

    [Field:Invoice Fld]
    Use:Name Field
    Width:50
    Border:Thin Box

    [Collection:Cleared]
    Type : Bills
    Cleared:Yes

    [Collection:UnCleard]
    Type:Bills
    Cleared:No

    [Collection:InvoiceBill]
    Collections:Cleared, Uncleard


    Thanks.,
     
    manjari m, Nov 8, 2014
    #1


  2. RIBU

    RIBU New Member


    Hi,

    Just add one filter in your collection.
    Eg : Filter : MyrefFilter

    [System : Formula]
    MyrefFilter : $Name = $$ReqObject:$Name

    TRY THIS.
     
    RIBU, Nov 10, 2014
    #2
    manjari m likes this.


  3. Maulik Patel

    Maulik Patel Active Member


    Dear Manjari M,

    Add following code to your code and try it
    Code:
    [Variable : MLK Invoice No]
Type : String

[System : Variable]
MLK Invoice No : ""

;; add following line in your field "Invoice Fld"
Modifies : MLK Invoice No.

;; In your report add following two lines
Variable : MLK Invoice No
Set : MLK Invoice No : ""


;;In your collection Add filter
Filter : MLK Invoice Filter

;; Define system formula
[System : Formula]
MLK Invoice Filter : $Name = ##MLKInvoiceNo
    ,

    Hope this will work.
     
    Maulik Patel, Nov 11, 2014
    #3
    gangstar and manjari m like this.


  4. manjari m

    manjari m New Member


    Thanks for your reply., I added your filter code to my main collection but it's not work.,
     
    manjari m, Nov 11, 2014
    #4


  5. manjari m

    manjari m New Member


    Thanks it's works.,
     
    manjari m, Nov 11, 2014
    #5


  6. sriprasad.06

    sriprasad.06 New Member


    [#Menu:GatewayofTally]
    Add:Item:Invoice History:Display:Invoice History

    [Report:Invoice History]
    Form:Receivable Form
    Title:"INVOICE HISTORY"

    [Form:Receivable Form]
    Use:DSP Template
    Parts:Receivable Part
    Width:100% Screen
    Height:100% Screen
    Button:VG FilterButton;Invoice Btn
    Background:Light Lily White

    [Part:Receivable Part]
    Lines:Receivable Title,Receivable Line
    Bottom Line:Receivable Total Line
    Repeat:Receivable Line:InvoiceBill
    Total:Receivable Amount, Receivable BC, Receivable l30, Receivable l60, Receivable l90, Receivable G90
    Common Border:Yes
    Scroll:Vertical

    [Line:Receivable Title]
    Use:Receivable Line
    Local:Field:Default:Type:String
    Local:Field:Default:Align:Center
    Local:Field:Default:Style:Normal Bold
    Local:Field:Receivable Date:Set as:"Date"
    Local:Field:Receivable RefNo:Set as:"Ref No"
    Local:Field:Receivable Party:Set as:"Party Name"
    Local:Field:Receivable Amount:Set as:"Bill Amount"
    Border:Thin Top Bottom


    [Line:Receivable Total]
    Local : Field : Receivable Amount : Set as: $$Total:ReceivableAmount

    [Line:Receivable Line]
    Fields:Receivable Date, Receivable RefNo, Receivable Party, Receivable Amount
    Empty:Not (##VGRefFilter=$Name or $$IsEmpty:##VGRefFilter )

    [Field : Receivable Date]
    Use : Short Date Field
    Set As : $BillDate
    Align:Left
    Width:10

    [Field : Receivable RefNo]
    Use : Name Field
    Set As : $Name
    Align:Left
    Width:10

    [Field : Receivable Party]
    Use : Name Field
    Set As : $DSPAccName:Ledger:$Parent
    Align:Left
    Width:25

    [Field : Receivable Amount]
    Use : Amount Field
    Set As : $OpeningBalance
    Format : "CRDR"
    Align:Right
    Width:15

    [Line:Receivable Total Line]
    Use:Receivable Line
    Border:Full Thin Top
    Local : Field : Receivable Party : Set as: $$LocaleString:"Grand Total"
    Local : Field : Receivable Amount : Set as: $$Total:ReceivableAmount

    ;[Button:Invoice Btn]
    ;Key:Alt+I
    ;Action:Execute:Invoice Rpt
    ;Title:Find Invoice
    ;
    ;[Report:Invoice Rpt]
    ;Form:Invoice Frm
    ;Title:Find Invoice
    ;Filter:$Reference
    ;
    ;[Form:Invoice Frm]
    ;Part:Invoice Prt
    ;Add : On : Form Accept : yes :Message Box
    ;
    ;[Part:Invoice Prt]
    ;Line:Invoice Ln
    ;
    ;[Line:Invoice Ln]
    ;Field:Medium Prompt, Invoice Fld
    ;Local:Field:Medium Prompt:Set as:"Invoice No"
    ;
    ;[Field:Invoice Fld]
    ;Use:Name Field
    ;Width:50
    ;Border:Thin Box

    [Collection:Cleared]
    Type : Bills
    Cleared:Yes

    [Collection:UnCleard]
    Type:Bills
    Cleared:No

    [Collection:InvoiceBill]
    Collections:Cleared, Uncleard



    ;;=================================== New Filter Option N.G.SRI PRASAD (VG TECHNOSOFT)===========================================;;

    [Button:VG FilterButton]
    Key: Alt+F
    Title:$$LocaleString:"Find Invoice"
    Action:Modify Variables:VGFilterRep
    [Report:VGFilterRep]
    Title:$$LocaleString:"Find Invoice"
    Form:VG OutStandFiltForm
    [Form:VG OutStandFiltForm]
    Part:VG OutStandFiltPert
    Vertical Align:Center
    Horizontal Align:Center
    Full Height:No
    Full Width:No
    Space Bottom:0.5% Screen
    Space Left:0.5% Screen
    Space Right:0.5% Screen
    Space Top:0.5% Screen
    [Part:VG OutStandFiltPert]
    Line: VG OutStandFiltTit,VG OutStandParty
    Border:Thin Box
    Space Bottom:0.5% Screen
    Space Left:0.5% Screen
    Space Right:0.5% Screen
    Space Top:0.5% Screen
    [Line:VG OutStandFiltTit]
    Field:Name Field
    Local: Field: Name Field: Info:"Find Invoice"
    Local: Field: Name Field: Align:Center
    Local: Field: Name Field: Full Width:Yes

    [Line:VG OutStandParty]
    Field:Medium Prompt,VG OutPartyWise
    Local: Field: Medium Prompt:Set as:"Ref No"
    Space Top:0.5% Screen
    Space Bottom:0.5% Screen
    [Field:VG OutPartyWise]
    Use: Name Field
    Variable: VGRefFilter
    Modifies: VGRefFilter
    Width :20% Screen

    [Variable:VGRefFilter]
    Type:String
    Persistent:Yes
    [System:Variable]
    VGRefFilter:""


    ;;=============================== Use The Below Button With Multiple filter at same form ============================
     
    sriprasad.06, Nov 19, 2014
    #6
    gangstar and manjari m like this.


  7. gangstar

    gangstar Member


    Thanks team, this filter has worked for me.
     
    gangstar, Mar 6, 2023
    #7


  8. Partha Mondal

    Partha Mondal Member


    Filter not working.



    [#Menu:GatewayofTally]
    Add:Item:Invoice History:Display:Invoice History

    [Report:Invoice History]
    Form:Receivable Form
    Title:"INVOICE HISTORY"
    Variable : MLK Invoice No
    Set : MLK Invoice No

    [Form:Receivable Form]
    Use:DSP Template
    Parts:Receivable Part
    Width:100% Screen
    Height:100% Screen
    Button:Invoice Btn
    Background:Light Lily White

    [Part:Receivable Part]
    Lines:Receivable Title,Receivable Line
    Bottom Line:Receivable Total Line
    Repeat:Receivable Line:InvoiceBill
    Total:Receivable Amount, Receivable BC, Receivable l30, Receivable l60, Receivable l90, Receivable G90
    Common Border:Yes
    Scroll:Vertical

    [Line:Receivable Title]
    Use:Receivable Line
    Local:Field:Default:Type:String
    Local:Field:Default:Align:Center
    Local:Field:Default:Style:Normal Bold
    Local:Field:Receivable Date:Set as:"Date"
    Local:Field:Receivable RefNo:Set as:"Ref No"
    Local:Field:Receivable Party:Set as:"Party Name"
    Local:Field:Receivable Amount:Set as:"Bill Amount"
    Border:Thin Top Bottom


    [Line:Receivable Total]
    Local : Field : Receivable Amount : Set as: $$Total:ReceivableAmount

    [Line:Receivable Line]
    Fields:Receivable Date, Receivable RefNo, Receivable Party, Receivable Amount

    [Field : Receivable Date]
    Use : Short Date Field
    Set As : $BillDate
    Align:Left
    Width:10

    [Field : Receivable RefNo]
    Use : Name Field
    Set As : $Name
    Align:Left
    Width:10

    [Field : Receivable Party]
    Use : Name Field
    Set As : $DSPAccName:Ledger:$Parent
    Align:Left
    Width:25

    [Field : Receivable Amount]
    Use : Amount Field
    Set As : $OpeningBalance
    Format : "CRDR"
    Align:Right
    Width:15

    [Line:Receivable Total Line]
    Use:Receivable Line
    Border:Full Thin Top
    Local : Field : Receivable Party : Set as: $$LocaleString:"Grand Total"
    Local : Field : Receivable Amount : Set as: $$Total:ReceivableAmount

    [Button:Invoice Btn]
    Key:Alt+I
    Action:Execute:Invoice Rpt
    Title:Find Invoice

    [Report:Invoice Rpt]
    Form:Invoice Frm
    Title:Find Invoice
    Filter:$Reference

    [Form:Invoice Frm]
    Part:Invoice Prt
    Add : On : Form Accept : yes :Message Box

    [Part:Invoice Prt]
    Line:Invoice Ln

    [Line:Invoice Ln]
    Field:Medium Prompt, Invoice Fld
    Local:Field:Medium Prompt:Set as:"Invoice No"

    [Field:Invoice Fld]
    Use:Name Field
    Width:50
    Border:Thin Box
    Modifies : MLK Invoice No

    [Collection:Cleared]
    Type : Bills
    Cleared:Yes

    [Collection:UnCleard]
    Type:Bills
    Cleared:No

    [Collection:InvoiceBill]
    Collections:Cleared, Uncleard
    Filter : MLK Invoice Filter

    ;; ADDED VAIRABLE ;;;

    [Variable : MLK Invoice No]
    Type : String

    [System : Variable]
    MLK Invoice No : ""

    [System : Formula]
    MLK Invoice Filter : $Name = ##MLKInvoiceNo
     
    Partha Mondal, Mar 12, 2023
    #8


Share This Page