Dear experts I am importing the ledger master from excel to tally. Here i am attaching the excel and tdl code for your reference. it was working fine in Tally ERP9 3.6 but in Tally ERP9 4.6 it shows error. 02a : Invalid number of steps, 02a: Action Execution Failed. kindly give me the solution. with regards skumar
Dear Mr.Prabhakaran In Tally ERP9 4.6 it shows the same error. 02a : Invalid number of steps, 02a: Action Execution Failed. kindly check it.
Hello Aldrin, I tried to import data using LedMaster.txt but it is importing only those ledger which is created under main group. I want to import ledger which created using sub-group. Also i want to import contact(along with tax details) details of ledger.
If you are using 64 bit machine then it wont import dreictly you need to install the 32 bit tally or need to copy the 32 bit files in tally folder
If you have the list of ledgers that you want to alter with the filed which needs to be updated in excel then it will be possible with customization. thanks! http://www.aaradhyaasolutions.in/
Hi Sir, I have used your TDL Code and im able import data, sir im unable to import State and Country Sir. Kindly help me to import Party Country and State name. Advance Thank Sir, Anbhu Selvam
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
Hi Lokesh 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
Hi sir, We are unable import Statename from excel. by using above attached code and Template. Kindly any please send me statename import corrected code. thanks, AnbhuSelvam