Dear All Find 2B Marking while viewing Purchase Register, Day Book or Ledger Report 1) Select row, Press Alt + B Button & Set 2B Mark 2) Select Month & Year from List 3) Modifying Selected Vouchers 2B Mark Field 4) Display 2B Mark in Report 5) Add Sorting Method in F12 Configuration 6) Add in Alt + F12 Range to Filter 2B Marking... Hope you all will like this...
Please Guide me how to add Voucher Level UDF in Alt+F12 - Range to filter daybook/ledger entries as you shown in 2BMark-5.png I am trying for this from many days but not getting on for addling collection in filter form.
Search for Additional SORT options... post by @Jay kumar tailor Follow that line of code and insert your requirements.
Thanks for reply, but there is 243 files in sample TDL, I have loaded and checked but it is very hard to find. will you guide me in which file of sample TDL I will find the sample code for the same.
Check This [#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 : "BR NO." ;; Display name in Table Method Name : TB ;; Storage name in voucher CollectionSource : "" ;; current collection SecondaryObject : "" ;; as storage is at voucher MethodType : "String" ;; Storage type on basis of which you would get comparision operators [#Collection: Daybook Vouchers of Company] Fetch: TB [#Collection: Vouchers of Ledger] Fetch: TB
thanks for guidance Chandresh Gaur Sir, Now My Field name appears in Alt+F12 - Range, but report still not get filtered. !! i am using UDF named MyVehicleNo and this UDF is stored at voucher level - (extra column after stock item name). here is my code. [#Field: IFLT Method] Delete : Table Add : Table : MethodTable1 : #IFLTType != "" ;; we add our collection in tally's default field as table Storage : User Method Name [Collection: MethodTable1] ;; This is developer defined collection Use : MethodTable Object : ChequeNoObject [Object : ChequeNoObject] ;; our defined object UserMethodName : "Vehicle No." ;; Display name in Table Method Name : MyVehicleNo ;; Storage name in voucher CollectionSource : "" ;; current collection SecondaryObject : "" ;; as storage is at voucher MethodType : "String" ;; Storage type on basis of which you would get comparision operators [#Collection: Daybook Vouchers of Company] Fetch: MyVehicleNo [#Collection: Vouchers of Ledger] Fetch: MyVehicleNo Please guide me whats wrong with my code.
Display Name in Table shows but report not get filtered. Please help in this regards, I have also Posted my code in #13.
@Bipin Damania Sir, jay kumar tailor Sir and Pankaj Bhondle Sir, I am trying from last 3 weeks but did not getting any solutions for adding my UDF in Alt+F12 - Range. with your guidance, field name shows in IFLT Methods (Particulars) but Report did not get filtered. I have posted code on Reply #13. Requesting to to kindly guide me to solve this issue.