Column wise Day Book

Discussion in 'Tally Developer' started by imranlhr, Jan 9, 2020.

    
  1. imranlhr

    imranlhr Member


    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
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     


Share This Page