udiMagic Release Notes

Session Topic Writing XML tags to import Journal Vouchers from Excel sheet into Tally. Product : UDI Magic For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

UDIMagic v4.0 Release 1.3 now supports some new options in the UDIMagic.ini (configuration) file as shown underneath :- [Tally] ;;Specify the Tally version version=x.x.x.x [UDIMagic] ;;Specify this option if you need to import data into Multiple Companies MultipleCompanies=Yes Remarks:- 1) As we cannot programmatically get the Tally version/release, a new option has been kept in the udimagic.ini (configuration) file to specify the Tally version. Ex: 9.0.3.2 specifies that the Tally version is 9.0 and Release is 3.2 2) While importing data into Tally, the Masters with same name (i.e. same master) are skipped by UDIMagic, by default. However, when data is to be imported into multiple Companies, we may require one Master to be imported into more than one companies. In such cases, you need to specify the MultipleCompanies=Yes in the UDIMagic configuration file

The following sample Excel sheet format is now available for UDIMagic users :- Employee Master - For Payroll

Session Topic Writing XML tags to import Receipt Vouchers from a single Excel sheet into multiple Companies in Tally Product : UDI Magic For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Session Topic Writing XML tags to import StockItem Masters with multiple Godowns from Excel into Tally Product : UDI Magic For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Session Topic Writing XML tags to import StockItem Masters from Excel into Tally Product : UDI Magic For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Session Topic Writing XML tags to import Payment Vouchers from a single Excel sheet into Multiple Companies in Tally Product : UDI Magic For more details, refer http://www.rtslink.com/online-training-sessions/schedule.html

Shweta Softwares now provides live (real time) online training sessions to enable users to use its products more effectively and easily. The Online Training Sessions are :- i)  live...

Why the FREE Support period is only for 90 days and not 1 Year ? - Often Customers ask us this question. (PS: In most of the cases, the question is raised only after expiry of the 90 days). This post is an attempt to put forth our views on this subject matter. Shweta Softwares launched its products and  tools for Tally Integration in 2007. Since then (i.e. from the very first day), we have been following the same policy i.e. FREE Support Services with product sale for 90 days . After 90 days, the Customer must go for AMC if they need support services.This is mentioned clearly at our web-site http://www.rtslink.com/orderinfo.html On 18th March, 2011, an email was sent by Tally Solutions, Bangalore to all their Partners. This email contained some guidelines which we had put up at http://tdlplayground.blogspot.com/2011/03/guidelines-for-tally-customization.html . Even these guidelines clearly specify that to maintain code compatibility, the Customers must enter into AMC which i...

UDIMagic is now sold with "Money back guarantee". For more details, please refer MBG FAQs

UDIMagic v3.0 customers / users are requested to note that the support for UDIMagic v3.0 shall be discontinued from 1st April 2012 and there shall be no product enhancements in UDIMagic v3.0 thereafter. To avail technical support and product enhancements, users must upgrade to UDIMagic v4.0.

By default, now the UNICODE feature is disabled. You can enable or disable it using the SETTINGS button in UDIMagic.

Sympton Tally terminates / closes when data is being uploaded using UDIMagic v4.0 Solution Start UDIMagic and click on the Settings button (wizard 2ndscreen). Next, set the value for UNICODE to NO. Save the settings and retry importing data into Tally Product UDIMagic v4.0

UDIMagic - Support for uploading large data-sets from Excel to Tally In case of large data-size uploads, support shall be restricted to maximum of two times test-uploading of 10000 rows of data (per license) and if any data inconsistencies are found, ...

New Rates w.e.f. 7th Nov 2011 are available at http://www.rtslink.com/buy.html

UDIMagic supports a tag named COMPANYNAME which allows uploading of data to the specified Company. Example <COMPANYNAME COLUMNREFERENCE="A"/> Remarks:- The above tag is useful when you to need transfer data to more than one companies. For ex. you may have an excel sheet wherein some entries are to be uploaded to Company A in Tally, some entries to Company B and other entries to Company C in Tally. This is feasible using the COMPANYNAME tag

Here are sample files for importing data from Focus ERP Software to Tally 1) Sales Vouchers with Stock Items, Excise, VAT, Amortization of Expenses 2) Purchase Vouchers with Stock Items, Excise, VAT

The following sample Excel sheet format is now available for UDIMagic users :- Sales Vouchers for Ashok Leyland Dealers

Important Note Manual reset for UDIMagic license shall be restricted to maximum 4 times per annum and 10 times in total (life-time).This shall be applicable to all UDIMagic users.

In Windows XP, you can set permissions on files so that specific users can access it. However, in certain cases when you Right click on the file and select Properties , you may notice that the Security tab is missing. To get the Securities tab, follow the underneath steps :- 1. Open Windows Explorer, and choose Folder Options from the Tools menu. 2. On the View tab, scroll to the bottom of the Advanced Settings and Clear (click) the check box next to " Use Simple File Sharing ." 3. Click OK to apply the change, and you should now have a Security tab when viewing the properties of a file on an NTFS volume.

In certain Excel templates, we use a sheet for specifying some Settings. Generally, this sheet is named as SETTINGS. However, at times you may forget to include the Settings sheet. Here's the macro code to check for the Settings sheet and display a message if it is NOT found. 'Check if Sheet exists '===================== Dim sh As Worksheet, flg As Boolean For Each sh In Worksheets If sh.Name Like "Settings*" Then flg = True: Exit For Next If flg = True Then 'MsgBox "Found!" Else MsgBox "Error: Settings Sheet NOT Found! " +chr(13)+chr(13)+"A sheet named SETTINGS must exist in Excel file"+chr(13)+"Terminating application" Application.Quit End If

Here are sample files for importing data from Wings Software to Tally 1) Import Cash Vouchers from Wings Software to Tally Remarks:- Supports multiple Party ledgers in Receipt and Payment

The aforesaid error Date is Out of Range occurs if the voucher date is lesser than the Books beginning date given in the Tally Company. A typical situation wherein the aforesaid occurs is shown underneath :- a) The Books beginning date in Tally is 01/04/2011 b) The Voucher date in the Excel sheet is 09/01/2011 While importing data into Tally using UDIMagic, the error "Date 9-1-2011 is out of Range" appears. This is because the Voucher has DATE as 9-1-2011 (i.e. 9th January 2011) Remarks:- We  have found that the said problem generally arises in cases where the Excel data is generated from some 3rd party application. Though the data generated by that application may be in dd-mm-yyyy format, it appears as mm-dd-yyyy in the Excel sheet. To rectify this, use option "Start - Settings - Control Panel - Regional and Language Options" and set the option as "English (United Kingdom)" instead of "English (United States)".

Localhost Localhost (this computer) is the standard hostname given to the address of the loopback interface of the Computer. 127.0.0.1 127.0.0.1 is a special purpose address reserved for use on each computer and is conventionally the computer's loopback address. On modern systems, the Localhost as a hostname translates into 127.0.0.1 (IPv4 address). Generally, both Localhost and 127.0.0.1 can be used to access the local machine. However, if a Proxy Server is defined, then Localhost works fine, but 127.0.0.1 may create problems and may connect to the Proxy Server even though the option "Bypass proxy server for local addresses" is set on. By default only hostnames are checked when "Bypass proxy server for local addresses" is set on. For more information, refer http://support.microsoft.com/kb/262981

UDI-Magic v4.0 supports a new feature that allows you to specify whether Dependent Masters are to be created or not in Tally. Usage:- 1) Open the UDIMAGIC.INI (configuration file) in Notepad. 2) Add the lines as shown below :-         [UDIMAGIC]   CreateDependentMasters=No      ;;Remarks:-   ;;a) Must appear under section [UDIMAGIC]   ;;b) Yes means - Create Dependent Masters.    ;;c) No means - Do not create Dependent Masters. 3) Save the file and close Notepad. Remarks :- The aforesaid feature is useful in situations where initially you want to IMPORT data in a Blank New Company in Tally and the dependent Masters must be created (set CreateDependentMasters=Yes). Later on when you import data in your Original Company wherein Masters already exist, you can set it to No (CreateDependentMasters=No)

We are pleased to announce the launch of UDIMagic v4.0 UDIMagic v4.0 supports UNICODE. In simple words, it allows you to import multilingual data into Tally 9,Tally ERP 9 like data in Hindi, Gujarati, Arabic etc. For more information, visit http://www.rtslink.com/udimagic-unicode.html UDIMagic v3.0 users can upgrade to the UDIMagic v4.0. The upgradation charges are as follows depending upon the version :- Rs 1000/- Upgrade from UDIMagic v3.0 Light to UDIMagic v4.0 Light Rs 2000/- Upgrade from UDIMagic v3.0 Standard  to UDIMagic v4.0 Standard   Rs 4000/- Upgrade from UDIMagic v3.0 Professional to UDIMagic v4.0 Professional The above charges are for Single-User version. For Multi-user version, the charges will be 2.5 times that of the Single-user charges as shown above. Customers who have  purchased UDIMagic v3.0 on or after 01/07/2011 shall be provided upgrades free-of-charge

Here are sample files for importing data from Wings Software to Tally 1) Import Cash Vouchers from Wings Software to Tally 2) Import Sales Vouchers from Wings Software to Tally

In case, if you are using Excel 2010 or Excel 2007 and get the Ole Error 800A3EC while importing data into Tally using UDIMagic, then it is likely that VBA is NOT installed in your system. VBA macros in 2010, 2007 Prior to Excel 2007 you didn't need to install the Visual Basic Editor if you wanted to develop or run macros (VBA procedures). In Excel 2007, Excel 2010 you must specify that VBA be installed when you install Excel from the Office CD. See how to install Visual Basic for Application for Excel 2010 / 2007

Syntax Replace(cString , cFind , cReplaceWith) Example Replace(cString, "A","a") The above replaces all occurrences of  capital "A" with small "a" in the cString variable. Remarks:- The VBA Replace function is very useful for manipulating Excel data at runtime. In certain cases, where the Excel data is generated from 3rd party softwares, we faced certain issues. Example, the Amount was displayed in TEXT format and included comma separator like 1,50,000.00. We used the VBA Replace function to remove the commas and then convert the value to Numeric.

The following sample Excel sheet format is now available for UDIMagic users :- Financial Vouchers with Cost Category and Cost Centres

If you are using Excel 2007 or higher version and get the said error while importing data into Tally using UDIMagic, then it is likely due to Macros. Solution:- In Excel 2007, the default setting for Recalculation of formulas is AUTOMATIC. We need to change it to MANUAL initially before making changes in the Excel sheet at run-time and the reset it to the Automatic at the end. The following code is used to set the calculation to Manual :- 'Stop Recalculation Dim xlCalc As XlCalculation xlCalc = Application.Calculation Application.Calculation = xlCalculationManual On Error GoTo CalcBack The following code is used to reset the calculation setting to Automatic :- 'Recalculate Application.Calculation = xlCalculationAutomatic Exit Sub CalcBack: Application.Calculation = xlCalculationAutomatic

The following sample Excel sheets formats are now available for UDIMagic users :- 1) Sales Vouchers with StockItems and Multiple Sales Ledgers 2) Sales Vouchers without StockItems, with multilple VAT rates 3) Point of Sale vouchers with Sales Return, Cancelled vouchers 4) Purchase Vouchers with VAT and CST (Local Purchase and CST Purchase) 5) Purchase Vouchers with StockItems and multiple VAT rates 6) Purchase Vouchers without StockItems, with multiple VAT rates

Query On entering DATE in Excel, it is displayed as a number rather than Date. Solution 1) Select "Tools >> Options >> View" 2) Uncheck the option "Formulas"  which appears under the section "Window options".

The aforesaid error Failed to fetch Tally data appears if the Tally License Server and Tally Software both are running on the same Port. Solution :- 1) In Tally Software, press F12 and select option Advanced Confiuration 2) Next, set the Port to a different than the current Port, say 9001 or 9002. 3) Save it using Ctrl+A. The new Port settings will be visible in the Gateway of Tally. 4) Next, start UDIMagic and in the 2nd screen, click on the Settings button and set the Port as assigned in Tally Software in point 2. 5) Next, in UDIMagic 3rd screen, click on the "Test Connection" button to test connection with Tally Software.

Here's a sample Excel sheet format to add / create new VAT Classifications in Tally ERP 9, Tally 9, Tally 8.1, Tally 7.2, Tally 6.3 Download Excel sheet template for VAT Classifications in Tally

Sample Excel sheet template for JV with Cost Category and Cost Centres For other Excel to Tally templates, please refer http://www.rtslink.com/download-excel-sheets.html

BOM or Bill Of Materials in Tally, allows you to define a list of items for manufacturing a product. Here are two sample Excel sheet formats for importing StockItem Master with BOM (Bill of Material) into Tally Accounting Software using UDIMagic. Sample 1 - http://www.rtslink.com/excelfiles/stockitem-master-with-bom-sample-1.zip Sample 2 - http://www.rtslink.com/excelfiles/stockitem-master-with-bom-sample-2.zip

The OFFSET Excel formula is quite useful when we need to access the values of previous or next rows. Syntax =Offset(currentcell,row,cols) Example :  =Offset(A10,-1,0) Returns the value of Cell A9.

BUG: Tally ERP 9 Release 3.0 When you use the option "Gateway of Tally >>Price List" to enter Price Levels for an StockItem, if you specify the Rate in "Alternate Unit", the same is stored/saved but is NOT displayed when you once again modify/view it using the "Gateway of Tally >> Price List" option. It has been confirmed by Tally Solutions, Bangalore that the aforesaid problem is a bug in Tally ERP 9 Release 3.0

The aforesaid error NO ACCOUNTING INFO generally occurs while importing data into Tally Software, if the LEDGERNAME tag is missing or does not contain any ledger-name.

Here's a sample Template for Sales Vouchers with StockItems, VAT, Addl VAT. This format is based on requirement of a Landmark Honda Dealer. http://www.rtslink.com/excelfiles/sales-vouchers-with-items-with-vat-1004.zip

The XML parse error appears if you have NOT selected the XML tags file in UDIMagic. A screen snapshot of the error is given below:- Solution When you run UDIMagic, you will be prompted to select the following :- a) Data-type : Voucher or Master b) Excel file c) XML tags file   If you have download sample-templates from our site, please check whether the zip file contains XML-tags file.If it contains the xml-file, then you must specify the xml-file in the UDIMagic where you select the Excel sheet. Ensure that you tick the option Use separate file for XML tags. In brief If the zip-file downloaded from site www.rtslink.com/download-excel-sheets.html contains xml-file, then you must select it in the UDIMagic dialog box else not.

Recently, Tally Solutions, Bangalore has provided some useful guidelines for Tally Partners / Solution Providers. Complete text of the same is available at http://tdlplayground.blogspot.com/2011/03/guidelines-for-tally-customization.html Accordingly, it is requested of you to take note of the following :- 1) Free upgradations for UDIMagic Software shall be provided for a period of 90 days. Remarks:- a) This policy is being followed by Shweta Softwares from the very beginning. b) Minor upgrades are provided free-of-cost even after 90 days. 2) Support Services shall be provided for a period of 90 days. Remarks:- a) This policy is being followed by Shweta Softwares from the very beginning. b) After 90 days, Customers need to go for AMC which shall be appx 30% of the Software charges. Alternatively, support services can be availed on per-call (remote-support-call) basis also.

Convert String to Reference The INDIRECT worksheet function is a useful tool for creating cell or range references "on the fly", as a formula is evaluated, rather than "hard coding" them into the formula. In its simplest usage, the INDIRECT function allows you to put the address of one cell in another, and get data from the the first cell by referencing the second. For example, if cell A1 has the value "C3", then =INDIRECT(A1) will return the value in C3

Excel to Tally - Sample format for Sales Vouchers with multiple Sales Ledgers but without Items

Excel to Tally - Sample format for Sales Vouchers for FMCG distributors