HELP HELP HELP .....CHANGE CODE I WANT TO ADD ONLY PHONE NUMBER COLUMN IN THIS CODE

Discussion in 'Free Source Codes' started by SUSHIL SHARMA, Jul 31, 2020.

    
  1. SUSHIL SHARMA

    SUSHIL SHARMA Member


    [#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

    Background : LightBlue

    [Part : daybookhead]
    Line :daybookhead
    [Line :daybookhead]
    Field : Simple Field
    ;Local : Field : Simple Field : Set As : ". Coulmer Day Book on " + $$String:##SVCurrentDate

    Local : Field : Simple Field : Set As : " Coulmer Day Book on " + $$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 : "Voucher No"
    Local : Field : MyVchType : Set As : "Voucher Type"
    Local : Field : MEBNo : Set As : "Narration"
    Local : Field : MyVchAmount0 : Set As : "Contra"
    Local : Field : MyVchAmount : Set As : "Sales"
    Local : Field : MyVchAmount1 : Set As : "Receipt"
    Local : Field : MyVchAmount2 : Set As : "Payment"
    Local : Field : MyVchAmount3 : Set As : "Debit Note"
    Local : Field : MyVchAmount4 : Set As : "Credit Note"
    Local : Field : MyVchAmount5 : Set As : "Journal"
    Local : Field : MyVchAmount6 : Set As : "Purchase"
    Local :Field : Default : Style : Large Bold
    Local: Field: Default: Align: Center
    Local: Field: Default:Background: Green

    [Part :Column Day Book]
    Line : Column Day Book
    Repeat :Column Day Book :My Voucher Rep Collection
    tOTAL : MyVchAmount0,MyVchAmount,MyVchAmount1,MyVchAmount2,MyVchAmount3,MyVchAmount4,MyVchAmount5,MyVchAmount6
    Scroll : Vertical
    [Line :Column Day Book]
    Field :My Voucher Date,MyVoucherParty,MyVchNo,MyVchType,MEBNo

    Right Field : MyVchAmount0,MyVchAmount,MyVchAmount1,MyVchAmount2,MyVchAmount3,MyVchAmount4,MyVchAmount5,MyVchAmount6
    Option : Alter On Enter

    [Field :My Voucher Date]
    Use : Short Date Field
    Set As : $Date
    Border : Thin Right

    [Field : MyVoucherParty]

    Use : NAme Field
    Set As : $LedgerName
    Width : 35
    Border : Thin Right
    Alter : Voucher



    [Field : MyVchNo]
    Use : NAme Field
    Set As : $VoucherNumber
    Width : 18
    Border : Thin Right

    [Field : MyVchType]
    Use : Name Field
    Set As : $VoucherTypeName
    Border : Thin Right
    Width : 15
    [Field : MEBNo]
    Use : Name Field
    Set As : $Narration
    Width : 60
    Border : Thin Right
    Style : Normal
    Set Always : Yes

    [Field : MyVchAmount0]
    Use : Amount Field

    Set As :if $VoucherTypeName CONTAINS "Con" then $Amount else ""
    Format : "DrCr"
    Border : Thin Right
    [Field : MyVchAmount]
    Use : Amount Field

    Set As :if $VoucherTypeName CONTAINS "Sale" then $Amount else ""
    Format : "DrCr"
    Border : Thin Right
    [Field : MyVchAmount1]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "Rec" then $Amount else ""
    Border : Thin Right
    [Field : MyVchAmount2]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "pay" then $Amount else ""
    Border : Thin Right
    [Field : MyVchAmount3]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "deb" then $Amount else ""
    Border : Thin Right
    [Field : MyVchAmount4]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "Cre" then $Amount else ""
    Border : Thin Right
    [Field : MyVchAmount5]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "Jou" then $Amount else ""
    Border : Thin Right
    [Field : MyVchAmount6]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "Pur" then $Amount else ""
    [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:Background: Green
    Local: Field: Default: Type: String
    Local: Field: Default: Align: Center
    Local : Field : MyVoucherParty: Set As : "Total"
    Local : Field : MyVoucherParty: Color: Blue
    Local : Field : MyVchNo : Set As : "Day Book"
    Local : Field : MyVchNo: Color: Blue
    Local : Field : MyVchType : Set As : "Amount"
    Local : Field : MyVchType : Color: Blue
    Local : Field : MyVchAmount0 :Set As: $$Total:MyVchAmount0
    Local : Field : MyVchAmount : Set As : $$Total:MyVchAmount
    Local : Field : MyVchAmount1 : Set As : $$Total:MyVchAmount1
    Local : Field : MyVchAmount2 : Set As : $$Total:MyVchAmount2
    Local : Field : MyVchAmount3 : Set As : $$Total:MyVchAmount3
    Local : Field : MyVchAmount4 : Set As : $$Total:MyVchAmount4
    Local : Field : MyVchAmount5 : Set As : $$Total:MyVchAmount5
    Local : Field : MyVchAmount6 : Set As : $$Total:MyVchAmount6
    Border : Totals
     


  2. SUSHIL SHARMA

    SUSHIL SHARMA Member


    I HOPE ANY ONE HEPL ME I AM WAITING
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You have made a good TDL.....so what problem are you facing in adding one more column?
     


  4. SUSHIL SHARMA

    SUSHIL SHARMA Member


    ...THANKU FOR REPLY ME BUT I NEED THIS COLUMN BCOZ MY OWNER WANTES TO ME GIVE DAILY CUSTMER WITH PHON NUMBER SO I WANT TO NEED
     


  5. SUSHIL SHARMA

    SUSHIL SHARMA Member


    CA
    N YOU EDIT THIS CODE SIR PLZZ
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Have you seen a Daybook? Check the name column.... How will you extract the Phone Number?

    When there are entries of Journal, Rcpt or Pymnt with multiple Ledgernames.... which Ledger's phone number will you extract??
     


  7. SUSHIL SHARMA

    SUSHIL SHARMA Member


    sir aap ak baar coding kr do me apne aap used me le luga bcoz i know mujhe kiya chaiye or ku islye sir request hai kuch codeing kr do
     


Share This Page