I made this tdl with help of Admin.Pls give Your Valuable Advice for Improvement of this code. [#Menu: Gateway Of Tally] Add : Item : Cleared And Uncleared Bills: Display: Cleared And Uncleared Bills [Report : Cleared And Uncleared Bills] Variable : SVFromDate, SVToDate Set : SVfromDate : ##SVDate Set : SVToDate : ##SVCurrentDate Form : Cleared And Uncleared Bills [Form : Cleared And Uncleared Bills] Parts : DSp Company Name, DSP Company Address Height : 100% Screen Width : 100% Screen BackGround : Light Yellow Space Top : If $$InPrintMode Then 0.5 Else 0 inches Button : PrintButton, ExportButton,F2 ChangePeriod Part : Cleared And Uncleared Bills Local : Part: DSP Company Address : invisible : No [Part : Cleared And Uncleared Bills] Parts: Cleared Bills, Uncleared Bills [Part : Cleared Bills] Space Bottom : 0.2 inch Line : Cleared BillsHead1,Cleared BillsHead2,Cleared Bills Repeat : Cleared Bills : List of Cleared Bills Border: Thin Box Scroll : Both Common Border : Yes Float : Yes [Line : Cleared BillsHead1] Space Bottom : 0.2 inch Border: Full Thin Bottom Use:Cleared BillsHead2 Local : Field : Date2 : Set as: "" Local : Field : Ref1 : Set as: "" Local : Field : Party1 : Set as:"List of Cleared Bills" Local : Field : Amount1 : Set as: "" [Line : Cleared BillsHead2] Border: Full Thin Bottom Field : Cleared BillsHead2 [Field : Cleared BillsHead2] Fieldsate2,Ref1,Party1,Amount1 [Field : Date2] Use : NameField Set as : "Bill Date" Style :Normal Bold [Field : Ref1] Use : NameField Set as : "Ref No." Style :Normal Bold [Field : Party1] Use : NameField Set as : "Party Name" Style :Normal Bold [Field : Amount1] Use : NameField Set as : "Bill Amount" Style :Normal Bold Align:Right [Part : Uncleared Bills] Space Bottom : 0.2 inch Line :UnCleared BillsHead1,UnCleared BillsHead2, Uncleared Bills Repeat : Uncleared Bills : List of Uncleared Bills Border: Thin Box Scroll : Both Common Border : Yes Float : Yes [Line : UnCleared BillsHead1] Space Bottom : 0.2 inch Border: Full Thin Bottom Use : UnCleared BillsHead2 Local : Field : Date3 : Set as: "" Local : Field : Ref2 : Set as: "" Local : Field : Party2 : Set as:"List of UnCleared Bills" Local : Field : Amount2 : Set as: "" Local : Field : Amount3 : Set as: "" [Line : UnCleared BillsHead2] Border: Full Thin Bottom Field : UnCleared BillsHead2 [Field : UnCleared BillsHead2] Fieldsate3,Ref2,Party2,Amount2,Amount3 [Field : Date3] Use : NameField Set as : "Bill Date" Style :Normal Bold [Field : Ref2] Use : NameField Set as : "Ref No." Style :Normal Bold [Field : Party2] Use : NameField Set as : "Party Name" Style :Normal Bold [Field : Amount2] Use : NameField Set as : "Op Bill Amount" Style :Normal Bold Align:Right [Field : Amount3] Use : NameField Set as : "Cl Bill Amount" Style :Normal Bold [Line : Cleared Bills] Field : Cleared Bills [Field : Cleared Bills] Fields : BILLDate1, BILLRef1, BILLParty1,BILLOp1 [Field: BILLDate1] Use : UniDateField Set as : $BillDate Style : Normal Bold Border: Thin Right [Field: BILLRef1] Use : ShortNameField Set as : $Name Width : 12 Style : Normal Border: Thin Right [Field: BILLParty1] Use : NameField Set as : $DSPAccName:Ledger:$Parent Border: Thin Right [Field: BILLOp1] Use : AmountField Type : Amount Set as : $OpeningBalance Style : Normal Bold Align : Right [Line : Uncleared Bills] Field : Uncleared Bills [Field : Uncleared Bills] Fields : BILLDate2, BILLRef2, BILLParty2,BILLOp2,BILLCl2 [Field: BILLDate2] Use : UniDateField Set as : $BillDate Style : Normal Bold Border: Thin Right [Field: BILLRef2] Use : ShortNameField Set as : $Name Width : 12 Style : Normal Border: Thin Right [Field: BILLParty2] Use : NameField Set as : $DSPAccName:Ledger:$Parent Border: Thin Right [Field: BILLOp2] Use : AmountField Type : Amount Set as : $OpeningBalance Style : Normal Border: Thin Right [Field: BILLCl2] Use : AmountField Type : Amount Set as : $ClosingBalance [Collection: List of Cleared Bills] Type : Bill Child Of : $$GroupSundryDebtors OR $$GroupSundryCreditors Belongs To : Yes Cleared : Yes [Collection: List of UnCleared Bills] Type : Bill Child Of : $$GroupSundryDebtors OR $$GroupSundryCreditors Belongs To : Yes Cleared : No
Great job Mr. Satam If possible Please put party filter and sort option for party wise preview and download
great code and efforts , Please do it if possible to keep clear date for PDC record also put voucher type for clarity rest code is fantastic
Dear Sattam Sir, I have also this kind of Form for updating some information, but not able to get this templet print or export option, both the buttons are enabled, but still Ctrl+E is not available, plz help. and one more help required to get multiple voucher types for Templet, but not sucessessful to get multiple voucher type for Report /Form below is the code: ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;MULTI VOUCHER UPDATE;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Collection : GST2AK] Type : Ledger Type : Vouchers : VoucherTypes Child Of : "Purchase" ;"Purchase" ;OR "Debit Note" '"PURCHASE" Belongs To : Yes here i am able to get purchase vouchers but not able to get Debit Note Vouchers... How to rectify the code to get both the type of vouchers to be displayed in the Form..
No no Mr. Sajid this is too much. Here are too many member cum developer like Mr. Admin,Amit Kamdar Ji (Admin) ,Devendar Ji (Garima),Jay kumar Tailor ji,Pankaj Ji,Bipin Ji they have much knowledge and depth in tdl than me. Specially Mr.Amit Kamdar and Devendra Ji they both are the God of tdl. I am not a developer tdl is my passion and I tried to do something in tdl when I being free. I am very much thank full to this platform whatever I learnt about tdl all from this forum.
Dear Sattamji, You have already been promoted to a much higher level, with your growth and self help efforts. I would appreciate that we help and aid others in gaining knowledge, which is the true purpose of this forum, rather than giving out free codes.