Dear Sirs, I want a report where I can get all the cost center value against each expense and against each supplier as below : Vch No. Party Ledger Name Debit Amount Date Expense Ledger Credit Amount Cost Center Vch Type P-JV/Jan/001/2019 XYZ Company - 1 0 08/01/2019 VEHICLE REPAIRS AND MAITENANCE 50000 ABC 01 DE Purchase P-JV/Jan/002/2019 XYZ Company - 2 0 09/01/2019 VEHICLE REPAIRS AND MAITENANCE 25000 ABC 02 DE Purchase P-JV/Jan/002/2019 XYZ Company - 2 0 09/01/2019 Vehicle Permits & Licence 22000 ABC 02 DE Purchase P-JV/Jan/003/2019 XYZ Company - 2 0 18/01/2019 VEHICLE REPAIRS AND MAITENANCE 15000 ABC 02 DE Purchase P-JV/Jan/003/2019 XYZ Company - 2 0 18/01/2019 Vehicle Permits & Licence 10000 ABC 01 DE Purchase P-JV/Jan/004/2019 XYZ Company - 1 0 18/01/2019 VEHICLE REPAIRS AND MAITENANCE 10000 ABC 01 DE Purchase P-JV/Jan/004/2019 XYZ Company - 1 0 18/01/2019 VEHICLE REPAIRS AND MAITENANCE 10000 ABC 02 DE Purchase P-JV/Jan/004/2019 XYZ Company - 1 0 18/01/2019 VEHICLE REPAIRS AND MAITENANCE 10000 ABC 03 DE Purchase P-JV/Jan/004/2019 XYZ Company - 1 0 18/01/2019 VEHICLE REPAIRS AND MAITENANCE 10000 ABC 04 DE Purchase P-JV/Jan/004/2019 XYZ Company - 1 0 18/01/2019 Vehicle Permits & Licence 5000 ABC 03 DE Purchase I have modified one of the TDL I got from here, that gives report for single voucher only showing only for 1st Expense Ledger and 1st Cost Center, I would appreciate any guidance / hints to have above report. Thanks Sanjay My Code : ;**********************************************************; [#Menu : Gateway of Tally] Add : Item : Bank Payment : Display : Bank Payment Details [Report:Bank Payment Details] Form : Bank Payment Details Title : "Online Bank Payment Upload Details" [Form: Bank Payment Details] Use : DSP Template ;;;Its a pre defined report containing all the necessary keys, buttons, etc required for reporting purposes Parts :MB Company,Bank Account Details Tit, Bank Payment Part Delete : Page Break Add : Page Break : SatCl Page Break, SatOp Page Break Height : 100% screen ;;;defining height of form as 100% sccreen Width : 100% screen ;;;defining width of form as 100% sccreen Background : Light Yellow ;Very Light Blue ;;;Setting the background color of report to grey [Part:MB Company] Line: MB Company Name,MB Company Address Border: Thin Box [Line:MB Company Name] Field: Name Field Local: Field: Name Field: Set as: @@CmpMailName Local: Field: Name Field: Style:Large Bold Local: Field: Name Field: Align : Center Local: Field: Name Field: Full Width:Yes Space Top: 0.05 Local: Field: Name Field:color:geranium [Line:MB Company Address] Field: Name Field Local: Field: Name Field: Set as: $$FullList:CompanyAddress:$Address Local: Field: Name Field: Full Width: Yes Local: Field: Name Field: Style:O9 Local: Field: Name Field: Align : Center Local: Field: Name Field: Line:0 Local: Field: Name Field:color:Blue [Part : Bank Account Details Tit] Line :Bank Account DetailsDate [Line : Bank Account DetailsDate] Border:THIN BOTTOM LEFT RIGHT Space Top: 1% page Space Bottom: 1% page Field : Bank Account DetailFromdt,ToooField,Bank Account DetailTodt [Field : Bank Account DetailFromdt] Use : n Field Set as:$$LocaleString:"Ledger Statement For the period " + $$String:##SVFromDate Width : 58% Screen Align : RIGHT Style : LARGE BOLD Color:geranium [Field : ToooField] Use : Name Field Set as : "To" Width : 2% Screen Align : Center Style : Normal Color:geranium [Field : Bank Account DetailTodt] Use : Date Field Set as : ##SVToDate Width : 45% Screen Align : Left Style : LARGE BOLD Color:geranium [Part: Bank Payment Part] Lines : Bank Payment Title, Bank Payment Line, Repeat : Bank Payment Line : paymentColl ;;;line will repeat on the collection of the ledger CommonBorder: Yes Scroll : Vertical [Line : Bank Payment Title] Use : Bank Payment Line Local : Field : Default :Color : Black Local : Field : Default :Background : Dark Green Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Style : Arial Bold Local : Field : Default : Border : BlueBorderXThin Local : Field : Payment Vch Number : Set as : "Vch No." Local : Field : Payment Led Name : Set as : "Party Ledger Name" Local : Field : Payment Dr Amount : Set as : "Debit Amount" Local : Field : Payment Vch Date : Set as : "Date" Local : Field : Expense Ledger : Set as : "Expense Ledger" Local : Field : Payment Cr Amount : Set as : "Credit Amount" Local : Field : Cost Center Name : Set as : "Cost Center" Local : Field : Payment Vch Type : Set as : "Vch Type" Border : Thin Top Bottom [Line: Bank Payment Line] Fields : Payment Vch Number, Payment Led Name, Payment Dr Amount, Payment Vch Date, Expense Ledger, Payment Cr Amount, Cost Center Name, Payment Vch Type ;Repeat : Payment Led Name ;;;line will repeat on the collection of the ledger [Fieldayment Vch Date] Use : Short Date Field Set as : $Date Format : Short Date, Separator:"/" Border : Thin Right Style : TINY Width : 7% screen SPACE RIGHT : 1 SPACE LEFT : 1 Align : left [Fieldayment Vch Number] Use : Name Field Set as : $VoucherNumber Border : Thin Right Style : TINY Width :10% screen SPACE RIGHT : 1 SPACE LEFT : 1 Align : left Alter : Voucher [Fieldayment Led Name] Use : Name Field ;Set As : $AllLedgerEntries[Last].BankAllocations[1].PaymentFavouring Set As : $LedgerName ;Set As : $AllLedgerEntries.Categoryallocations.Costcentreallocations.Name Border : Thin Right Style : TINY Bold Width :35 SPACE RIGHT : 1 SPACE LEFT : 1 Align : left [Fieldayment Vch Type] Use : Name Field Set as : $VoucherTypeName Border : Thin Right Style : TINY Width :6% screen SPACE RIGHT: 1 SPACE LEFT: 1 Align : left [Fieldayment Dr Amount] Use : Number Field Set as : if not $$IsDr:$Amount then 0 else $Amount Format : "No Comma" Border : Thin Right Style : TINY Width :10% screen SPACE RIGHT: 1 SPACE LEFT: 1 Align : Right [Field:Cost Center Name] Use : Name Field Set as : $AllLedgerEntries[Last].Categoryallocations.Costcentreallocations.Name Border : Thin Right Style : TINY Width :10% screen SPACE RIGHT: 1 SPACE LEFT: 1 Align : Right [Field:Expense Ledger] Use : Name Field ;Set as : $AllLedgerEntries[Last].LedgerName Set as : $AllLedgerEntries[2].LedgerName Repeat Set As : $AllLedgerEntries[Last].LedgerName Border : Thin Right Style : TINY Width :10% screen SPACE RIGHT: 1 SPACE LEFT: 1 Align : Right [Fieldayment Cr Amount] Use : Number Field Set as : if $$IsDr:$Amount then 0 else $Amount Format : "No Comma" Border : Thin Right Style : TINY Width :10% screen SPACE RIGHT: 1 SPACE LEFT: 1 Align : Right ;**********************************************************; [CollectionaymentColl] Type : Voucher Child Of:$$VchTypeJournal OR $$VchTypePurchase ;;Payment Belongs To: Yes Fetch : *.* ;Fetch :AllledgerEntries.BankAllocations.INSTRUMENTNUMBER Fetch:AllLedgerEntries ;;.BankAllocations.BankersDate ;Fetch:AllLedgerEntries.BankAllocations.BankDetails Filter : PayFilter [System:Formulas] PayFilter:$$IsJournal:$VoucherTypeName OR $$IsPurchase:$VoucherTypeName ;**********************************************************; [Border : BlueBorderXThin] Top : Thin Bottom : Thin Right : Thin Left : Thin Color : "Blue" Print Fg: "Blue"
Hi Experts, please any suggestion will be highly appreciated, I need report on Cost Center and giving details of expense and supplier in same row for each and every cost center.
Hi Experts, please any suggestions if this is possible or not, as I am putting my much efforts, but of no any use, of course during that I get to learn something new.
