Using Below code, i am not successful, i don't know, what is wrong., plz guid. ;;================================================= [#Field: IFLT Method] Delete : Table Add : Table : MethodTable1 : #IFLTType != "" ;; we add our collection in tally's default field as table [Collection: MethodTable1] ;; This is developer defined collection Use : MethodTable Object : ChequeNoObject [Object : ChequeNoObject] ;; our defined object UserMethodName : "Cheque No" ;; Display name in Table Method Name : DueDateOfPymt ;; Storage name in voucher CollectionSource : Vouchers of Ledger ;; current collection SecondaryObject : JLChequeNo ;; as storage is at voucher MethodType : "Number" ;; Storage type on basis of which you would get comparision operators ;;==================================================
Hi , Please follow one more Method. Add a Button In The Day Book Report. In That U Execute A Report Where you will select the Cheque No. To Get all The Cheque No Which You have Entered in Vouchers Of Payment Or Receipt Or Contra. Construct a collection To Get All The Cheque No and Display In Table. Later You Add the Filter in DayBook by Comparing The Variable Which You Have Declared In The Button Report. NOTE : Folow this Instruction If you still didnt Get Please Post The Code Of The Cheque Nos You Are Storing. i will give you the Solution for it.
Thanks for your reply, and sorry for late. But still i am didnt get, understood, so posting code of the cheque nos i am storing. [Field : JLChequeNo] Use : Name Field Set as : $LastDueDateOfPymt Storage : DueDateOfPymt Invisible : (Not $$IsReceipt:##SVVoucherType) And (Not $$IsPayment:##SVVoucherType) And (Not $$IsContra:##SVVoucherType) Set Always : Yes Inactive : Not @@IsBankLedPresent
Dear Sir, I have created my own UDF in voucher and filter in DayBook. I have filter only "Daybook Vouchers of Company" Collection. You may add it Filter vouchers of Company, Modified vouchers of company etc. Please find the below code Its may useful for you, Code Start ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara ;; Om Muruga : Om Shridi Sai Baba ;; Cheque No Field in Contra, receipt and payment [#Part: DBL LineNarration] Add: Option: PK RcptPymtContra: (@@IsReceipt or @@IsContra or @@IsPayment) [!Part: PK RcptPymtContra] Add: Line: Before: VCH NarrPrompt: PK RcptPymtContra [Line: PK RcptPymtContra] Field: Medium Prompt, PK ChNo Local: Field: Medium Prompt: Setas: "Cheque No.:" [Field: PK ChNo] Use: Name Field Storage: PKChNo [System: UDF] PKChNo: String: 101 ;; Table to Filter in DayBook [#Form: DayBook] Add: Button: PK DB FilButton [#Report: DayBook] Add: Set: PKChNoVar: $$SysName:NotApplicable [Button: PK DB FilButton] Title: "Cheque No." Key:Alt+9 Action: Alter: PK DB Form [Report: PK DB Form] Form: PK DB Form [Form: PK DB Form] Part: PK DB Form NoConfirm: Yes [Part: PK DB Form] Line: PK DB Form [Line: PK DB Form] Field: Medium Prompt, PK DB Field Local: Field: Medium Prompt: Setas: "Select Ch. No:" [Field: PK DB Field] Use: Name Field Modifies: PKChNoVar Table: PKChqNoTable, NotApplicable ShowTable: Always [Variable: PKChNoVar] Type: String [System: Variable] PKChNoVar: "" [Collection: PKChqNoTable] Type: Voucher Filter: PKRcptPayContra Fetch: PKChNo Format: $PKChNo, 20 Title: "List of Cheque No" [System: Formula] PKRcptPayContra: ($$IsReceipt:$VoucherTypeName or $$IsPayment:$VoucherTypeName or $$IsContra:$VoucherTypeName) PKChqNoFilter: If ##PKChNoVar = $$SysName:NotApplicable then True else $PKChNo = ##PKChNoVar [#Collection: Daybook Vouchers of Company] Add: Fetch: PKChNo Add: Filter: PKChqNoFilter ;; Code End ;; End of List
If we want to filter it without adding any filter button, means to filter using tally default method, by coding with IFLT Method any one know? plz. update, thanks
I am trying to filter by Ledger Name... I am not getting it. whats wrong in this code [#Form: DayBook] Add: Button: BnPButton [#Report: DayBook] Add: Set: VarLedgerName: $$SysName:NotApplicable [Button: BnPButton] Title: "Batch Wise Report" Key:Alt+9 Action: Alter: BnPForm [Report: BnPForm] Form: BnPForm [Form: BnPForm] Part: BnPForm NoConfirm: Yes [Part: BnPForm] Line: BnPForm [Line: BnPForm] Field: Medium Prompt, BnPLedgerField Local: Field: Medium Prompt: Set as: "Select Party :" [Field: BnPLedgerField] Use: Name Field Modifies: VarLedgerName Table: Ledger, NotApplicable ShowTable: Always [Variable: VarLedgerName] Type: String [System: Variable] VarLedgerName: "" [System: Formula] PartyLedgerNameFilter: If ##VarLedgerName = $$SysName:NotApplicable then True else $PARTYLEDGERNAME = ##VarLedgerName [#Collection: Daybook Vouchers of Company] Add: Filter: PartyLedgerNameFilter
Sir, how can set user enterd by/altered by filter ?? [#Report: Day Book] Variable : SearchUser : String Set : SearchUser :"" [#Form: Day Book] Button : ExplodeFlag, ChangeDybkDate, ChangePeriod, ChangeCompany, DYBK ChgVchType, Direct Columnar, DYBK Extract, DSPShowGP, Userwise [Button :Userwise] Key : Alt+U Title : "User Wise" Action : Alter : SearchUser [Report : SearchUser] Form : SearchUser [Form : SearchUser] Part : SearchUser [Part : SearchUser] Line : SearchUser [Line : SearchUser] Field : Medium Prompt,SearchUser Local : Field : Medium Prompt : Info : "User Name" [Field : SearchUser] Use : Name Field Variable : SearchUser Modifies : SearchUser
Sir / Madam I need to filter the BasicFinalDestination.Its not working.Kindly anyone fix this problem [#Collection:MethodTable] Object:VchDestination [Object:VchDestination] UserMethodName:"Destination" Method Name:"BasicFinalDestination" CollectionSource:"" SecondaryObject:"" MethodType:"String" [#Collectionaybook Vouchers of Company] Add:Fetch:BasicFinalDestination
[#Collection : Daybook Vouchers of Company] Fetch:BasicFinalDestination Compute : FinalDest : $BasicFinalDestination
Filter is not working for old tally [#Form: DayBook] Add: Button: BnPButton [#Report: DayBook] Add: Set: VarLedgerName: $$SysName:NotApplicable [Button: BnPButton] Title: "Party Name" Key:Alt+9 Action: Alter: BnPForm [Report: BnPForm] Form: BnPForm Set : VarLedgerName : " " Use : Day Book [Form: BnPForm] Part: BnPForm NoConfirm: Yes [Part: BnPForm] Line: BnPForm [Line: BnPForm] Field: Medium Prompt, BnPLedgerField Local: Field: Medium Prompt: Set as: "Select Party :" [Field: BnPLedgerField] Use: Name Field Table: Ledger, NotApplicable ShowTable: Always Variable : VarLedgerName Modifies : VarLedgerName [Variable: VarLedgerName] Type: String [System: Variable] VarLedgerName: " " [Collection:BnPForm] Title : "List of PartyName" Type : Vouchers Belongs To : Yes Format : $PartyLedgerName,25 Filter : PartyLedgerNameFilter [System: Formula] PartyLedgerNameFilter: If ##VarLedgerName = $$SysName:NotApplicable then True else $PartyLedgerName = ##VarLedgerName [#Collection: Daybook Vouchers of Company] Add: Filter: PartyLedgerNameFilter