Dear All Experts, Thanks for this wonderful plate form, Sir, i am a new learner. i just download a day book column wise and amend it according to my needs. Sir, i need a code to show cost center and cost category in column base day book. i shall be thankful if anyone helps me in this matter. Code: [#Menu : Gateway of Tally] Item : Column Day Book : Display : Column Day Book [Report : Column Day Book] Form :Column Day Book Variable : SVFromDate,SVToDate Set : SVFromDate : ##SVCurrentDate Set : SVToDate : ##SVCurrentDate [Form :Column Day Book] Part :daybookhead,daybookhead1, Column Day Book ;;,daybookhead2 bottom Part : daybookbottam Button : Change Period,Print Button,Export Button,FilterButton,GRPVCH Configure [Part : daybookhead] Line :daybookhead [Line :daybookhead] Field : Simple Field ;Local : Field : Simple Field : Set As : ". on " + $$String:##SVCurrentDate Local : Field : Simple Field : Set As : " From " + $$String:##SVFromDate +" to " + $$String:##SVToDate Local : Field : Simple Field : Style : Normal bold Local : Field : Simple Field : Align : Centre [Part : daybookhead1] Use : Column Day Book Delete : Repeat Delete : Scroll Border : ColumnTitles Local : Field : Default : Type : string Local : Field : My Voucher Date : Set As : "Date" Local : Field : MyVoucherParty: Set As : "Particular" Local : Field : MyVchNo : Set As : "V No." Local : Field : MyVchType : Set As : "Type" Local : Field : MEBNo : Set As : "Narration" Local : Field : MyVchAmount6 : Set As : "Purchase" Local : Field : MyVchAmount5 : Set As : "Journal" Local : Field : MyVchAmount2 : Set As : "Payment" Local :Field : Default : Style : Normal Local: Field: Default: Align: Center [Part :Column Day Book] Line : Column Day Book Repeat :Column Day Book :My Voucher Rep Collection Total : MyVchAmount2,MyVchAmount5,MyVchAmount6 Scroll : Vertical [Line :Column Day Book] Field :My Voucher Date,MyVoucherParty,MyVchNo,MyVchType,MEBNo Right Field : MyVchAmount6,MyVchAmount5,MyVchAmount2 Option : Alter On Enter [Field :My Voucher Date] Use : Short Date Field Set As : $Date Width:9 Border : Thin Right [Field : MyVoucherParty] Use : Name Field Set As : $LedgerName Width : 38 Border : Thin Right Alter : Voucher [Field : MyVchNo] Use : NAme Field Set As : $VoucherNumber Width : 8 Border : Thin Right [Field : MyVchType] Use : Name Field Set As : $VoucherTypeName Border : Thin Right Width : 10 [Field : MEBNo] Use : Name Field Set As : $Narration Width : 60 Border : Thin Right Style : Normal Set Always : Yes [Field : MyVchAmount6] Use : Amount Field Set As :if $VoucherTypeName CONTAINS "Pur" then $Amount else "" Border : Thin Right [Field : MyVchAmount5] Use : Amount Field Set As :if $VoucherTypeName CONTAINS "Jou" then $Amount else "" Border : Thin Right [Field : MyVchAmount2] Use : Amount Field Set As :if $VoucherTypeName CONTAINS "pay" then $Amount else "" Border : Thin Right [Collection : My Voucher Rep Collection] Type : Vouchers Fetch : Date,Amount,VoucherTypeName,PArtyLedgerName,VoucherNumber,Narration */ [Part: daybookbottam] Lines : daybookTotalLine [Line: daybookTotalLine] Use : Column Day Book Local: Field: Default : Style : Small Bold Local: Field: Default: Type: String Local: Field: Default: Align: Center Local : Field : MyVoucherParty: Set As : "Total" Local : Field : MyVchAmount6 : Set As : $$Total:MyVchAmount6 Local : Field : MyVchAmount5 : Set As : $$Total:MyVchAmount5 Local : Field : MyVchAmount2 : Set As : $$Total:MyVchAmount2 Border : Totals
Dear Imran, I suggest that you gain more experience by doing other things and learn about collections. The solution to above is a complicated one and you will need more exposure to TDL before trying it. e.g. --- a Cash payment voucher with 3 or 4 debits of expenses...all 3/4 expense item has been allocated a Cost Centre. In this scenario, how will you display multiple cost centres for one single entry in a columnar format. Your requirement envisages lots of tweaks and walk through the accounting and inventory entries.