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., [#Menu:GatewayofTally] Add:Item:Invoice Historyisplay:Invoice History [Report:Invoice History] Form:Receivable Form Title:"INVOICE HISTORY" [Form:Receivable Form] UseSP 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:Fieldefault:Type:String Local:Fieldefault:Align:Center Local:Fieldefault: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.,
Hi, Just add one filter in your collection. Eg : Filter : MyrefFilter [System : Formula] MyrefFilter : $Name = $$ReqObject:$Name TRY THIS.
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.
[#Menu:GatewayofTally] Add:Item:Invoice Historyisplay:Invoice History [Report:Invoice History] Form:Receivable Form Title:"INVOICE HISTORY" [Form:Receivable Form] UseSP 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:Fieldefault:Type:String Local:Fieldefault:Align:Center Local:Fieldefault: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 ============================
Filter not working. [#Menu:GatewayofTally] Add:Item:Invoice Historyisplay:Invoice History [Report:Invoice History] Form:Receivable Form Title:"INVOICE HISTORY" Variable : MLK Invoice No Set : MLK Invoice No [Form:Receivable Form] UseSP 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:Fieldefault:Type:String Local:Fieldefault:Align:Center Local:Fieldefault: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