MULTIPLE RECEIPT VOUCHER OF MULTIPLE ENTRIES OR SINGLE ENTRIES WITH MASTER

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

         
  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:

    SURENRA likes this.


  2. SURENRA

    SURENRA New Member


    Great sir ji,
     


  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
     


  4. pankaj971

    pankaj971 New Member


    downloading failed
     


  5. harbansh

    harbansh Active Member


    Send us email i will send you.
    hrharry20@gmail.com
     


  6. sirisetty balaji

    sirisetty balaji New Member


    downloading failed
     


  7. Jay kumar tailor

    Jay kumar tailor Active Member



  8. RAJESH BHANUSHALI

    RAJESH BHANUSHALI New Member



  9. Bindeshwar Kumar

    Bindeshwar Kumar New Member



  10. R.Raj

    R.Raj New Member


    Downloading failed...
     


  11. SANDY ACHE

    SANDY ACHE New Member



  12. Salasaran

    Salasaran New Member



  13. Salasaran

    Salasaran New Member



  14. Jay kumar tailor

    Jay kumar tailor Active Member



  15. SURESHKUMAR K

    SURESHKUMAR K New Member



  16. Sachin13mail

    Sachin13mail New Member



  17. Bipin Damania

    Bipin Damania Member



  18. sumamehtra

    sumamehtra New Member



  19. Eresh

    Eresh New Member



  20. udaya

    udaya Member



  21. sirisetty balaji

    sirisetty balaji New Member



Share This Page