1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

MULTIPLE RECEIPT VOUCHER OF MULTIPLE ENTRIES OR SINGLE ENTRIES WITH MASTER

Discussion in 'Free Source Codes' started by harbansh, Oct 15, 2016.

    
Tags:
Page 1 of 2
  1. harbansh

    harbansh Active Member


    Dear all,
    Through this you can import Multiple entries or Single entries of Receipt voucher from excel to tally through xml file.
    Payment
    Step 1 : Fill template as per describe in template
    Step 2 : goto ledger sheet and click on unique ledger import
    Step 3 : Give a proper group of ledger and generate ledger import xml file from second button
    Step 4 : Then go to tally import ledger form above generate xml file.
    Step 5 : after that goto 1 sheet and generate Receipt vouchers xml file.
    Step 6 : Now again goto tally and import vouchers from above generated xml file.
    Task complete

    For any query M.n. 9152953646 Email : hrharry20@gmail.com

    if you don't want to create ledger you can skip step 2 to 4 (if ledger is already created in company)

    See the video of my previous post of payment multiple entries

     

    Attached Files:

    harbansh, Oct 15, 2016
    #1
    yugal agarwal and SURENRA like this.


  2. SURENRA

    SURENRA New Member


    Great sir ji,
     
    SURENRA, Oct 19, 2016
    #2


  3. anbhuselvan

    anbhuselvan Member



    Hello Sir,

    Sir, im using your code, but im unable to import State from Excel.
    When i import the master im getting below error: Kindly help me sir.

    FUNCTION: 'ImportLedgerMaster' LABEL: 09 : State 'Tamil Nadu' does not exist!


    i have enclosed TDL and Excel sheet. Kindly check and reply me sir.

    It's really good help for me.

    Thanks,
    AnbhuSelvam



    [#Menu : GateWay of Tally]

    Key Item : Ledger Master Import : K : Execute : NS Ledgermaster Import





    [Report : NS Ledgermaster Import] ;; Auto Report

    Form : NS Ledgermaster Import
    Title : $$LocaleString:"Ledger Master Import"
    Auto : Yes

    [Form: NS Ledgermaster Import]

    No Confirm : Yes
    Space Top : 1
    Space Left : 1
    Space Right : 1
    Space Bottom : 1
    Option : Small Size Form
    Full Width : No
    Full Height : No
    Vertical Align : Centre
    Parts : NS Ledgermaster Import Title, NS Ledgermaster Import Details
    On : Form Accept : Yes : CALL : ImportLedgerMaster


    Local : Field : NS Import FileName : Modifies : NS SVExcelPath : Yes
    Local : Field : NS Import FileName : Variable : NS SVExcelPath
    Local : Line : NS Voucher Imports : Local : Field : Form Sub Title : Info : $$LocaleString:"Ledger Master Import"


    [Part: NS Ledgermaster Import Title]

    Lines : NS Ledgermaster Imports, NS Ledgermaster Imports Info

    [Line: NS Ledgermaster Imports]

    Fields : Form Sub Title
    Space Bottom : 0.25
    Local : Field : Form Sub Title : Info : $$LocaleString:"Ledger Master Import"

    [Line: NS Ledgermaster Imports Info]

    Field : Simple Field
    Space Bottom : 0.75
    Local : Field : Simple Field : Info : $$LocaleString:"(Only Tally (XLS) Format is Supported)"
    Local : Field : Simple Field : Full Width : Yes
    Local : Field : Simple Field : Align : Centre

    [Part: NS Ledgermaster Import Details]

    Lines : NS Import FileName

    [Line: NS Import FileName]

    Field : Medium Prompt, NS Import FileName , TEST1
    Local : Field : Medium Prompt : Info : $$LocaleString:"Import File Name (XLS) :"

    [Field: NS Import FileName]

    Use : Name Field
    Width : @@NarrWidth
    Set as : "D:\TDL path\Gotom Work Import_APR2017\ledmaster_Country.xls"
    Full Width : Yes

    [Field : TEST1]
    Use : Name Field
    Table : NS LedgermasterCollimport
    Show Table : Always



    [Variable: NS SVExcelPath]

    Type : String
    Default : ""
    Persist : Yes

    [System: Variable]

    NS SVExcelPath : ""
    [System: Formula]

    NSExcelFilePath : ##NSSVExcelPath



    [Collection : NS LedgermasterColl]
    ODBC : "Driver={Microsoft Excel Driver (*.xls)};DBQ= " + @@NSExcelFilePath
    SQL : "Select * from [Sheet1$]"
    SQLObject : NS Ledgermaster Object
    Client Only : Yes

    [Object : NS Ledgermaster Object]

    NSLedName : $_1
    NSLedParent : $_2
    NSLedOpBal : $_3
    NSLedAdd1 : $_4
    NSLedAdd2 : $_5
    ;08d : SET VALUE : CountryName : $NSLedCountryName
    NSLedCountryName : $_6
    NSLedState : $_7
    NSLedPincode : $_8
    ;
    NSLedCont : $_9
    NSLedPh : $_10
    NSLedFax : $_11
    NSLedEmail : $_12
    ;
    NSLedPan : $_13
    NSLedTIN : $_14
    NSLedCST : $_15





    [Collection : NS LedgermasterCollimport]
    Source Collection : NS LedgermasterColl

    Compute : NSLedName : $_1
    Compute : NSLedParent : $_2
    Compute : NSLedOpBal : $_3
    Compute : NSLedAdd1 : $_4
    Compute : NSLedAdd2 : $_5
    ;08d : SET VALUE : CountryName : $NSLedCountryName
    Compute : NSLedCountryName : $_6
    Compute : NSLedState : $_7

    Compute : NSLedPincode : $$number:$_8
    ;
    Compute : NSLedCont : $_9
    Compute : NSLedPh : $_10
    Compute : NSLedFax : $_11
    Compute : NSLedEmail : $_12
    ;
    Compute : NSLedPan : $_13
    Compute : NSLedTIN : $_14
    Compute : NSLedCST : $_15



    Format : $NSLedName
    Format : $NSLedPh









    [Function: ImportLedgerMaster]
    ;; Procedural Block
    Variable : Counter : Number

    ;; Definition Block
    01 : SET FILE LOG ON
    02 : SET : Counter : 0
    02a : START PROGRESS : ($$NumItems:NSLedgermasterCollimport) : "Ledger Import" : @@CmpMailName : "Importing Ledgers..."

    03 : WALK COLLECTION : NSLedgermasterCollimport

    04 : NEW OBJECT : Ledger
    06 : SET VALUE : Name : $NSLedName
    07 : SET VALUE : Parent : $NSLedParent
    08 : SET VALUE : OpeningBalance : $NSLedOpBal

    08a : Insert Collection Object : ADDRESS
    08a1 : If:NOT $$isempty:$NSLedAdd1
    08a2 : SET VALUE : Address : $NSLedAdd1
    08a3 : END IF
    08a4 : Set Target:..

    08b : Insert Collection Object : ADDRESS
    08b1 : If:NOT $$isempty:$NSLedAdd2
    08b2 : SET VALUE : Address : $NSLedAdd2
    08b3 : END IF
    08b4 : Set Target:..
    08d : SET VALUE : CountryName : $NSLedCountryName
    08d1 : SET VALUE : StateName : $NSLedState
    08e : SET VALUE : Pincode : $NSLedPincode

    08f : SET VALUE : LedgerContact : $NSLedCont
    08g : SET VALUE : LedgerPhone : $NSLedPh
    08h : SET VALUE : LedgerFax : $NSLedFax
    08i : SET VALUE : Email : $NSLedEmail
    ;
    09A : SET VALUE : IncomeTaxNumber : $NSLedPan
    09B : SET VALUE : VATTINNUMBER : $NSLedTIN
    09C : SET VALUE : InterStateSTNumber : $NSLedCST

    09 : CREATE TARGET
    10 : INCREMENT : Counter
    10a : SHOW PROGRESS : ##Counter
    11 : END WALK
    11a : END PROGRESS
    12 : MSGBOX: "Status" :"Ledger Master Imported \n successfully!!! "
    ;;12 : MSGBOX: "Status" : @@Nstotledmaster + " Created Successfully!! "
    13 : SET FILE LOG OFF
    14 : RETURN



    [System: Formula]
    Nstotledmaster : $$numitems:NSLedgermasterCollimport
     
    anbhuselvan, Apr 20, 2017
    #3


  4. pankaj971

    pankaj971 New Member


    downloading failed
     
    pankaj971, Jun 7, 2017
    #4


  5. harbansh

    harbansh Active Member


    Send us email i will send you.
    hrharry20@gmail.com
     
    harbansh, Jun 7, 2017
    #5
    SURENRA likes this.


  6. sirisetty balaji

    sirisetty balaji Member


    downloading failed
     
    sirisetty balaji, Jun 9, 2017
    #6


  7. Jay kumar tailor

    Jay kumar tailor Well-Known Member

    Jay kumar tailor, Aug 27, 2017
    #7


  8. RAJESH BHANUSHALI

    RAJESH BHANUSHALI Member

    RAJESH BHANUSHALI, Apr 4, 2018
    #8


  9. Bindeshwar Kumar

    Bindeshwar Kumar New Member

    Bindeshwar Kumar, Apr 5, 2018
    #9


  10. R.Raj

    R.Raj New Member


    Downloading failed...
     
    R.Raj, Apr 10, 2018
    #10


  11. SANDY ACHE

    SANDY ACHE New Member

    SANDY ACHE, May 13, 2018
    #11


  12. Salasaran

    Salasaran New Member

    Salasaran, May 15, 2018
    #12


  13. Salasaran

    Salasaran New Member

    Salasaran, May 15, 2018
    #13


  14. Jay kumar tailor

    Jay kumar tailor Well-Known Member

    Jay kumar tailor, May 25, 2018
    #14


  15. SURESHKUMAR K

    SURESHKUMAR K New Member

    SURESHKUMAR K, May 31, 2018
    #15


  16. Sachin13mail

    Sachin13mail New Member

    Sachin13mail, Aug 7, 2019
    #16


  17. Bipin Damania

    Bipin Damania Active Member

    Bipin Damania, Aug 7, 2019
    #17


  18. sumamehtra

    sumamehtra Member

    sumamehtra, Aug 21, 2019
    #18


  19. Eresh

    Eresh New Member

    Eresh, Aug 21, 2019
    #19


  20. udaya

    udaya Active Member

    udaya, Aug 22, 2019
    #20


  21. sirisetty balaji

    sirisetty balaji Member

    sirisetty balaji, Aug 22, 2019
    #21


  22. SURESHKUMAR K

    SURESHKUMAR K New Member

    SURESHKUMAR K, Oct 6, 2019
    #22


  23. anish

    anish Member


    downloading failed ! Please send me on email anishajmera@gmail.com
     
    anish, Feb 1, 2020
    #23


  24. sanskruti

    sanskruti Member

    sanskruti, Feb 25, 2020
    #24


  25. Frz

    Frz Member


    frzroks@gmail.com
     
    Frz, Feb 26, 2020
    #25


Page 1 of 2

Share This Page