Cost Center Report Supplier / Expense wise

Discussion in 'Requests' started by naijaind, Nov 30, 2019.

         
  1. naijaind

    naijaind Member


    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

    [Field:payment 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


    [Field:payment 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

    [Field:payment 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

    [Field:payment Vch Type]

    Use : Name Field
    Set as : $VoucherTypeName
    Border : Thin Right
    Style : TINY
    Width :6% screen
    SPACE RIGHT: 1
    SPACE LEFT: 1
    Align : left

    [Field:payment 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

    [Field:payment 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



    ;**********************************************************;
    [Collection:paymentColl]
    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"
     


  2. naijaind

    naijaind Member


    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.
     


  3. naijaind

    naijaind Member


    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.
     


Share This Page