What is Field Name (NOT TITLE FIELD) in Default Invoice Print For - Invoice No., Dated, Delivery Note, Mode/Terms of Payment etc. at top right Thanks
Dear Sir, While executing following code it shows error Function:'importfromexcel' label 10 : invalid number of steps Function:'importfromexcel' label 10 : action execution failed Pls. suggest the errors in code [#Menu:Gateway of Tally] Add : Item: Before: @@Locquit:"Import from Excel" : Call :Importfromexcel [Function:Importfromexcel] Variable : Totalentries : Number 00 : Set : Totalentries : $$NumItems:Extallycollection 10 : Start Progress : Totalentries : "Ledgers creation": "Importing ledgers in" :##SVcurrentcompany 20 : Walk Collection:Extallycollection 30 : New Object: Ledger 40 : Set Value:Name :$_1 50 : Set Valuearent :$_2 60 : Set Value:mailingname :$_1 70 : Set Value:State Name :$_6 80 : Set Value:Ledger phone :$_7 90 : Set Value:Ledger fax:$_8 100 : Set Value:email : $_9 110 : Insert Collection Object:address 120 : Set Value:address :$_3+","+$_4 130 : Set Target : .. 140 : Insert Collection Object:address 150 : Set Value:address :$_5 160 : Set Target: .. 170 : Create Target 180 : Show Progress : ##count 190 : Increment : Count 200 :End Walk 210 :End Progress 220 : Msg Box:"STATUS" :"Ledgers from excel imported successfully" [Collection:Extallycollection] ODBC:"DRIVER={MICROSOFT EXCEL DRIVER (*.XLS,*.XLSX,*.XLSM,*.XLSB)};DBQ=d:\narendra\LEDGER.XLSX" SQL: "SELECT*FROM(LEDGERS$)"
Invalid Steps means Collection Not Gathered Step 1 [Collection:Extallycollection] ODBC:"DRIVER={MICROSOFT EXCEL DRIVER (*.XLS,*.XLSX,*.XLSM,*.XLSB)};DBQ=d:\narendra\LEDGER.XLSX" SQL: "SELECT*FROM [LEDGERS$]" Step 2 Check Whther The Filename n sheetname are correct , wthether available in the specified path Step 3 Check the Bitness whether 32 bit or 64 bi Make sure Windows OS , Tally, MS Office are in same bitness
Invalid Steps means Collection Not Gathered Step 1 [Collection:Extallycollection] ODBC:"DRIVER={MICROSOFT EXCEL DRIVER (*.XLS,*.XLSX,*.XLSM,*.XLSB)};DBQ=d:\narendra\LEDGER.XLSX" SQL: "SELECT * FROM [LEDGERS$]" use square Brackets Step 2 Check Whther The Filename n sheetname are correct , wthether available in the specified path Step 3 Check the Bitness whether 32 bit or 64 bi Make sure Windows OS , Tally, MS Office are in same bitness
I am looking for help.... Need to have multiple email addresses and contacts for all sundry debtors and creditors along with Contact Name, Number, Designation and email ID. Also All the email Ids should be listed while using mailing option in Tally. Can you Please Help SIR?
I ran the above code and I am getting the following two errors: 1. FUNCTION: 'ImportFromExcel' LABEL: 10 : Invalid number of steps 2. FUNCTION: 'ImportFromExcel' LABEL: 10 : Action execution failed! The function basically tries to read the data from the excel file called Import.xls. I have googled these two errors and I found some suggestions: The OS + Tally + Microsoft Office should all be either 32 bit or 64 bit. The excel file name extension should be xls instead of xlsx. I have a 64 bit system and I have checked to make sure that both Office and Tally are 64 bit. Also, my file extension is .xls. Any other ideas as to why this might not be working? excel tally