Importing master from excel to tally

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

 

Please check this file

 

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.

 

Please check file i run 4.61 its running .and give ur excel path.

 

thank You Much Please provide code Import Sales Thru Excel Format Attch Sheet Format

 

Again i getting same error

 

Dear sir

i am getting same error my problem was not solved.

 

Dear Admin

please solve this issue

 

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

 

please import address Field every one is help me

 

Hi SKumar

Find the attachment ant try this.

 

HI Murali

Find the attachment for Ledger import form Excel.

 

Thanks .Thanks mr.Lakesh

 

Billwise Ledger Master import tdl ?.Please help me

 

Dear Maniderik,
If you want this solutions i have devlope in VB.

Manish Patil

 

can u shere

 

I want to add one more coloum that is ID (alias)can you please help me...

 

i want to alter the ledger master details

 

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