Dear all developer Please help me in the tdl , not working filter button function , Thanks in advance [#Menu: Gateway of Tally] Item : Receipt Register : Display :Receipt Register : NOT $$IsEmpty:$$SelectedCmps ;***************************************************************************************************** [#Part: VCH Narration] ;Add : line :Before : VCH NarrPrompt:vehnoreceipt add : part :Before : VCH DBLLINE Narration:EI Broker Name Option: EI Broker Name: @@IsReceipt [!part : EI Broker Name] Add : Line : At End : Broker Name Local : Field : Name Field : Skip : yes [Line : Broker Name] Field : Simple Prompt , Broker Name Local : Field : Simple Prompt : Set as : "Sales Man Name:" Local : Field : Simple Prompt : Width : 14 Local : Field : Simple Prompt : Color : Red Local : Field : Simple Prompt : Style : Normal Bold [Field : Broker Name] Use : Name Field Set as : $Parent:Ledger:$PartyLedgerName Width : 30 Storage : Broker Name ;Keys : Create ledger Skip : Yes [System:UDF] BrokerName : String : 4570 [Button:BtnBroker] Key : F5 Action : Execute : BrokerReportWise Title : Broker Wise Inactive: Not $EnableBroker:Company:##SVCurrentCompany [Report:BrokerReportWise] Form : BrokerReportWise [Form:BrokerReportWise] Part : BrokerReportWise Space Left : 2 mms Space Right : 2 mms [Part:BrokerReportWise] Line : BrokerReportWise [Line:BrokerReportWise] Field : Medium Prompt,BrokerReportWise Local : Field : Medium Prompt : Set as : "Select Broker Name:" Space Bottom : 2 mms [Field:BrokerReportWise] Use : Name Field Width : 20 Table : List of Broker, Not Applicable Show Table: Always SETAS:$BrokerNameUdf;$VALUE Variable : ACBroker Name Modify : ACBroker Name [Collection: List of Broker] Title : "List of Sales Man" Type : Group Child of : "Sales Man" Belongs To : Yes Variable : GroupName Report : CPL BillWise Report;EgREPORT Filter : IsDebtor;OnlyCplParty Align : Centre [System : Formula] IsDebtor : $$IsBelongsTo:$$GroupSundryDebtors OnlyCplParty: $$IsBelongsTo:$$GroupSundryDebtors AND Not $$IsEmpty:$ClosingBalance ;***************************************************************************************************** [Report : Receipt Register] Form : RecReg Family : "Outstandings" List Name : "Bill-wise Details" Variables : SV CurrentCompany, SVFromDate, SVToDate, SVSortMethod, LedgerName, SVBudget, SVVariance Variables : ExplodeFlag, IsForexReport Variable : DSPShowMonthly, DSPHasMultiLevel Variable : ShowDaysByBillDate Variable : ShowBillRange, IsBillWiseReport, IsLedgerReport, IsCCReport, IsVchTypeReport Variable : DSPNotScaleable, DSPHasColumnTotal, DSPAgeByDueDate Variable : AgeFrom, AgeTo, ShowReminders, ShowForex Variable : IsMultiPage, InNewPages, ShowBillType, IsGrpBillReport Repeat : AgeFrom, AgeTo Set : SV Sort Method : @@Default Set : DSPShowMonthly : No Set : ShowDaysByBillDate: No Set : IsBillWiseReport : Yes Set : IsLedgerReport : Yes Set : IsGrpBillReport : No Set : DSPHasMultiLevel : No Set : DSPNotScaleable : Yes Set : DSPHasColumnTotal : No Set : IsMultiPage : No Set : SVBudget : "" Set : SV From Date : $$MonthStart:##SVCurrentDate Set : SV To Date : $$MonthEnd:##SVCurrentDate Export : Yes Set : FilterBroker : "" [Form : RecReg] Use : CSCCNI Grp Trigger Rep Width : 100% Page Height : 100% Page BackGround : Light Sea Green Parts : RecBody Button : ExplodeFlag, ChangeDybkDate, ChangePeriod,Print Button,AgeWiseAnalysis, Buttons : F2 Change Period,BtnBroker Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumnsName [Part : RecBody] Lines : Rchqlineh, Rchqline Repeat : RChqLine : Rctvchs Totals : CASAmt, RFldAmt Scroll : Vertical Common border : Yes Bottom Line : RecBodyBLn Totals : CASAmt, RFldAmt [Line : RChqLineh] Fields : RFldsl, RFldDate, RFldhead Right Fields : CASAmt, RFldAmt, Local : Field : Default : Type : String Local : Field : Default : Align : Center Local : Field : RFldsl : Set as : "Vch No." Local : Field : RFldDate : Set as : "Date" Local : Field : RFldhead : Set as : " Party Name " Local : Field : CASAmt : Set as : "Cash Amount" Local : Field : RFldAmt : Set as : "Cheque Amount" Border : Column Titles [Line : RecBodyBLn] Use : RChqLine Local : Field : RFldsl : Set as : "" Local : Field : RFldDate : Set as : "" Local : Field : RFldDate : Type : String Local : Field : RFldhead : Set as : "Totals" Local : Field : CASAmt : Set as : $$Total:CASAmt Local : Field : RFldAmt : Set as : $$Total:RFldAmt Border : Totals [Line : RChqLine] Fields : RFldsl, RFldDate,RFldhead Right Fields : CASAmt,RFldAmt Option : AlterOnEnter : $$IsVoucher AND NOT $IsDeleted [Field : RFldsl] Use : Short Name Field Set as : $VoucherNumber Width : 7 Align : Right Alter : Voucher : $$IsVoucher AND NOT $IsDeleted ;;space Right : 2 Border : Thin Right Align : Center [Field : RFldDate] Use : Uni Date Field Set as : $Date Border : thin Right width : 10 [Field : RFldhead] Use : Name field Set as : $Ledgername Width : 15 Border : Thin left [Field : CASAmt] Use : Amount Field Set as : $Amount space Right : 1 Border : Thin left Inactive : @@IsBankLedPresent [Field : RFldAmt] Use : Amount Field Set as : $Amount space Right : 1 Border : Thin left Inactive : Not @@IsBankLedPresent [System : formula] Rctvchs : $$IsReceipt:$VoucherTypeName ;;and ChBkEntries : Not $LedgerName AND NOT $$IsDr:$Amount [Collection : Rctvchs] Collection : Rctvchsgb Collection : Rctvchsgbod [Collection : Rctvchsgb] Type : Vouchers : group Childof : $$groupbank Fetch : Narration, Ledger,Group, Date, DueDateOfPymt, Amount Filter : Rctvchs [Collection : Rctvchsgbod] Type : Vouchers : group Childof : $$GroupCash ;;$$GroupBankOD and Fetch : Narration, Ledger,Group, Date, DueDateOfPymt, Amount Filter : Rctvchs [System : Formula] AbcFilter : $$IsBelongsTo:$$GroupBank OR $$IsBelongsTo:$$GroupBankOD OR $$IsBelongsto:$$GroupCash IsBankLedger : ($$IsLedofGrp:$LedgerName:$$GroupBank Or $$IsLedofGrp:$LedgerName:$$GroupBankOD) IsBankLedPresent : $$FilterCount:AllLedgerEntries:IsBankLedger > 0
Sales man name is not working because it is written only for receipt voucher i.e., [#Part : VCH Narration] Option: EI Broker Name: @@IsReceipt remove that option line and it should work