1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

BANK ACCOUNT DETAILS REGISTER

Discussion in 'Free Source Codes' started by sattam, Feb 17, 2016.

    
  1. sattam

    sattam Active Member


    I have made this code with help of admin sir.But print button is not working.Can any body help me?
     

    Attached Files:

    sattam, Feb 17, 2016
    #1


  2. Ajeet Jain

    Ajeet Jain Member


    Find Correct Code
     

    Attached Files:

    Ajeet Jain, Feb 17, 2016
    #2


  3. sattam

    sattam Active Member


    Sir print Button Not working for this report.Tally.exe not responding.
     
    sattam, Feb 17, 2016
    #3


  4. Ajeet Jain

    Ajeet Jain Member


    Which Version u r using?
     
    Ajeet Jain, Feb 17, 2016
    #4


  5. Ajeet Jain

    Ajeet Jain Member


    Find Corrected Code for Release version above 5.0
     

    Attached Files:

    Ajeet Jain, Feb 17, 2016
    #5


  6. sattam

    sattam Active Member


    Sir I use old version rel 1.1
     
    sattam, Feb 17, 2016
    #6


  7. mpal2311

    mpal2311 Active Member


    Great.
     
    mpal2311, Feb 18, 2016
    #7


  8. sattam

    sattam Active Member


    Sir print button not working.pls help me.Tally.exe not responding.
     
    sattam, Feb 18, 2016
    #8


  9. sattam

    sattam Active Member


    Can anybody help me?
     
    sattam, Feb 18, 2016
    #9


  10. Ajeet Jain

    Ajeet Jain Member


    install the latest version
     
    Ajeet Jain, Feb 18, 2016
    #10


  11. sattam

    sattam Active Member


    Can anybody help me? what is the error of this code? print button is not working.
     
    sattam, Feb 20, 2016
    #11


  12. sattam

    sattam Active Member


    Sir pls help me
     
    sattam, Feb 20, 2016
    #12


  13. llwhiteflowerll

    llwhiteflowerll New Member


    Please provide code here, becasue txt file is not getting download, its giving error Thanks

     
    llwhiteflowerll, Mar 13, 2016
    #13


  14. sattam

    sattam Active Member


    ;;TDL Developed by Sattam Chakraborty

    [#Part: MST LED Explode Bank]
    Add: Lines:IFSCno,MICRno,AccountHolder1st,AccountHolder2nd

    [Line: IFSCno]
    Field: Long Prompt,IFSCno
    Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
    Local: Field: Long Prompt: Set as: "IFSC CODE NO"

    [Line: MICRno]
    Field: Long Prompt,MICRno
    Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
    Local: Field: Long Prompt: Set as: "MICR CODE NO"

    [Line: AccountHolder1st]
    Field: Long Prompt,AccountHolder1st
    Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
    Local: Field: Long Prompt: Set as: "1ST ACCOUNT HOLDER'S NAME"

    [Line: AccountHolder2nd]
    Field: Long Prompt,AccountHolder2nd
    Local : Field : Default : Inactive : Not ($$IsBelongsTo:$$GroupBank)
    Local: Field: Long Prompt: Set as: "2ND ACCOUNT HOLDER'S NAME"

    [Field : IFSCno]
    use : Name Field
    Storage : IFSC


    [Field : MICRno]
    Use : Name Field
    Storage :MICR

    [Field : AccountHolder1st]
    use : Name Field
    Storage :AccountHolder1st

    [Field : AccountHolder2nd]
    use : Name Field
    Storage :AccountHolder2nd



    [System : UDF]

    IFSC : String : 1001
    MICR: String : 1002
    AccountHolder1st : String : 1003
    AccountHolder2nd : String : 1004



    [#Menu : Gateway of Tally]

    Add : Item : Bank Account Details : Display : Bank Account Details

    [Report : Bank Account Details]


    Use : DSP Template
    Variable : SVFromDate, SVToDate
    Set : SVfromDate : ##SVDate
    Set : SVToDate : ##SVCurrentDate
    Form : Bank Account Details Form


    [Form : Bank Account Details Form]
    Parts : DSp Company Name, DSP Company Address
    Use : DSP Template
    Delete : Page Break
    Add : Page Break : SatCl Page Break, SatOp Page Break
    Height : 100% Screen
    Width : 100% Screen
    BackGround : Light Yellow
    Space Top : If $$InPrintMode Then 0.5 Else 0 inches
    Button : PrintButton,ExportButton,F2 ChangePeriod
    Parts : Bank Account Details Tit,Bank Account Details Report
    Local : Part: DSP Company Address : invisible : No

    [Part : SatCl Page Break]
    Lines : SatCont Line
    Float: Yes
    Vertical : Yes

    [Line : SatCont Line]
    Field : SatCont Field

    [Field : SatCont Field]

    Set as : "Continued....."
    Full Width : Yes
    Align : Right

    [Part :SatOp Page Break]
    Parts: DSP OpCompanyName, DSP OpReportTitle
    Vertical: Yes
    Part: SatOpPart

    [Part: SatOpPart]
    Line: SatOp Page Break
    Common Border: Yes
    Float: Yes

    [Line: SatOp Page Break]
    Use: Bank Account DetailscolumnTitles
    Fields: Serial No1., Bankname, Opbal, Depamt, Witamt, Clbal, Accno, Nameone, Nametwo, Ifsc,Micr,Brnch
    Local: Field: Default: Border:Thin Left right


    [Part : Bank Account Details Tit]

    Space Bottom : 0.2 inch
    Line : Bank Account Details Tit Line,Bank Account DetailsDate


    [Line : Bank Account Details Tit Line]

    Field : Bank Account Details Tit Field

    [Field : Bank Account Details Tit Field]

    Use : Name Field
    Set as : "BANK ACCOUNT DETAILS REGISTER"
    Align : Center
    Full Width : Yes
    Style : Large Bold

    [Line : Bank Account DetailsDate]

    Space Top: 1% page
    Field : Bank Account DetailFromdt,ToooField,Bank Account DetailTodt

    [Field : Bank Account DetailFromdt]

    Use : Date Field
    Set as : ##SVfromDate
    Width : 45% Screen
    Align : Center
    Style : Normal

    [Field : ToooField]

    Use : Name Field
    Set as : "To"
    Width : 4% Screen
    Align : Center
    Style : Normal

    [Field : Bank Account DetailTodt]

    Use : Date Field
    Set as : ##SVToDate
    Width : 45% Screen
    Align : Center
    Style : Normal


    [Part : Bank Account Details Report]

    Line : Bank Account DetailscolumnTitles,Bank Account DetailsInfo
    Repeat : Bank Account DetailsInfo : SKCcollection

    Scroll : Both
    Common Border : Yes
    Float : Yes

    Bottom Line:SatCOlTotals
    Total :Opbal, Depamt, Witamt, Clbal

    [Line : Bank Account DetailscolumnTitles]

    Border : Column Titles

    Fields : Serial No1., Bankname, Opbal, Depamt, Witamt, Clbal, Accno, Nameone, Nametwo, Ifsc,Micr,Brnch

    Local : Field : SerialNo1. : Set as : "SNo."
    Local : Field : SerialNo1. : Line : 0
    Local : Field : Bankname : Set as : "Bank Name"
    Local : Field : Bankname : Line : 0
    Local : Field : Opbal : Set as : "Opening Balance"
    Local : Field : Depamt : Set as : "Deposit Amt"
    Local : Field : Witamt : Set as : "Withdrawn Amt"
    Local : Field : Clbal : Set as : "Closing Balance"
    Local : Field : Accno : Set as : "Account No."
    Local : Field : Nameone : Set as : "1st Account Name"
    Local : Field : Nametwo : Set as : "2nd Account Name"
    Local : Field : Ifsc : Set as : "IFSC Code"
    Local : Field : Micr : Set as : "MICR Code"
    Local : Field : Brnch : Set as : "Branch"

    Local : Field : Default : Type : String
    Local : Field : Default : Style : Normal Bold
    Local : Field : Default : Align : Center


    [Line : Bank Account DetailsInfo]

    Fields : Serial No1., Bankname, Opbal, Depamt, Witamt, Clbal, Accno, Nameone, Nametwo, Ifsc,Micr,Brnch
    Border : Thin Bottom
    Local : Field : Default : Color : "Black"


    [Line: SatCOlTotals]

    Use : Bank Account DetailscolumnTitles

    Local : Field : SerialNo1. : Set as: ""
    Local : Field : Bankname : Set as: "Grand Total"
    Local : Field : Opbal : Set as: $$Total:Opbal
    Local : Field : Depamt : Set as: $$Total:Depamt
    Local : Field : Witamt : Set as: $$Total:Witamt
    Local : Field : Clbal : Set as: $$Total:Clbal
    Local : Field : Accno : Set as: ""
    Local : Field : Nameone : Set as: ""
    Local : Field : Nametwo : Set as: ""
    Local : Field : Ifsc : Set as: ""
    Local : Field : Micr : Set as: ""
    Local : Field : Brnch : Set as: ""

    [Field : SerialNo1.]

    Use : Number Field
    Set as : $$Line
    Width : 3% Screen
    Style : Normal
    Align : Center
    Border : Thin Left

    [Field : Bankname]

    Use : Name Field
    Set as : $Name
    Width : 18% Screen
    Style : Normal
    Border : Thin Left

    [Field : Opbal]

    Use : Amount Field
    Set as : $BSOpening
    Width : 8% Screen
    Style : Normal
    Border : Thin Left

    [Field : Depamt]

    Use : Amount Field
    Set as : $BSDebits
    Width : 8% Screen
    Style : Normal
    Border : Thin Left

    [Field : Witamt]

    Use : Amount Field
    Set as : $BSCredits
    Width : 8% Screen
    Style : Normal
    Border : Thin Left

    [Field : Clbal]

    Use : Amount Field
    Set as : $BSClosing
    Width : 8% Screen
    Style : Normal
    Border : Thin Left


    [Field :Accno]

    Use : Short Name Field
    Set as : $BankDetails
    Width : 10% Screen
    Style : Normal
    Border : Thin Left



    [Field : Nameone]

    Use : Name Field
    Set as : $AccountHolder1st
    Width : 10% Screen
    Style : Normal
    Border : Thin Left



    [Field : Nametwo]

    Use : Name Field
    Set as : $AccountHolder2nd
    Width : 8% Screen
    Style : Normal
    Align : Center
    Border : Thin Left



    [Field : Ifsc]

    Use : Name Field
    Set as : $IFSC
    Width : 7% Screen
    Style : Normal
    Border : Thin Left

    [Field : Micr]

    Use : Name Field
    Set as : $MICR
    Width : 6% Screen
    Style : Normal
    Border : Thin Left

    [Field :Brnch]

    Use : Name Field
    Set as : $BankBranchName
    Width : 6% Screen
    Style : Normal
    Border : Thin Left Right




    [Collection : SKCcollection]

    Type : Ledger
    Child Of : $$GroupBank
    Filter : SKCFilter
    Belongs To : Yes

    [System : Formula]
    SKCFilter : $OpeningBalance > 0 OR $BSDebits > 0





    ;; EOF
     
    sattam, Mar 14, 2016
    #14


  15. llwhiteflowerll

    llwhiteflowerll New Member


    its working fine

    just remove this field

    /*[Field : Bankname]

    Use : Name Field
    Set as : $Name
    Width : 18% Screen
    Style : Normal
    Border : Thin Left
    */
     
    llwhiteflowerll, Mar 26, 2016
    #15


Share This Page