udiMagic Release Notes

The following new feature have been  incorporated in udiMagic v11 Release 1.4: Data Validation Alerts udiMagic now supports  data-validation alerts . The data validation feature checks and validates the excel data prior to importing it into Tally ERP software and displays warnings if incorrect data is found in the Excel file. How it works? Excel data is validated against a pre-defined set of rules which are specified in the XML tags. An alert is displayed on screen or logged into file, if any of the the rules are voilated. Presently, alerts have been included in the following templates : 1. Vouchers-V11-Sales-Purchase-With-Stockitems-Basic.xls 2. Vouchers-V11-Sales-Purchase-With-Stockitems-Advanced.xls The following checks have been currently kept : 1.  VoucherType Name [Column B] Must contain a valid [predefined] Tally voucher-type. An alert message will be displayed if the Excel sheet contains incorrect voucher-type. 2. State Name   [Column...

The following new features have been  incorporated in udiMagic v11 Release 1.3: Data Grouping or GroupBy udiMagic now supports data-grouping . This feature makes it possible to automatically  import summarized data into Tally ERP. Here's an example : SOURCE : Excel Sheet extract - Sales with StockItems As you can see, the Item 1 appears 3 times and Item 2 appears twice in the given data. Now, here's how this data will be imported into Tally when groupby is enabled. DESTINATION : Tally screen - After importing data using udiMagic  As you can see, the Item 1 and Item 2 quantity and value are now grouped. i.e. Item 1 (3 + 2 + 5 = 10 Nos) Item 2 (4 + 6 = 10 Nos) Remarks 1. The Data-Grouping feature is now supported by the template "Vouchers-Sales-Purchase-with-StockItems-Advanced.xls" 2. A new field / column GroupBy has been added.  3. A sample Sales entry with GroupBy set as Yes has been included in the said Standard templat...

The aforesaid error may appear while importing data from Excel to Tally in the following situations : Case 1 The Company Name in Tally ERP contains special characters viz Linefeed [#13] and carriage return [#10] at the end of Company Name . To check whether the Company Name is correct or not, please follow the underneath steps : Open your Company in Tally ERP Press Ctrl+F3 to select the "Company Info"  Next, select the option " Alter " In the Company alteration screen, press END-key while in the the Company Name field. If there is space between the last character and the cursor (as shown in this snapshot), press BACKSPACE to remove the special characters at the end of Company Name and save it. Solution ALTER the Company and remove the special characters (blank spaces) if any from the end of the Company Name.  Case 2 The Company Name in Tally ERP contains & (i.e. ampersand sign). Example, the Company Name is "ABC & Co" ...

The following changes have been done : udiMagic v11 Release 1.2 1. In the udiMagic screen " Create a Custom Custom ", the grid HEIGHT for Standard Excel and User Excel template has now been increased for better user experience. 2. The Tally to Tally feature (separately available) is now compatible with the latest Tally ERP. udiMagic v11 Release 1.1 1. In some of the Standard templates, the "DataFromRow" and "MappingRow" was incorrectly specified. This has now been corrected / fixed. Those using  udiMagic v11 Release 1.0  are advised to upgrade to the latest udiMagic release.

We are pleased to announce the launch of udiMagic v11. The details are as follows : TEMPLATE MODIFICATIONs The following templates now support multi-currency feature : 1. Vouchers-V11-Bank-statement.xls 2. Vouchers-V11-Bank-statement-Single-Column-Dr-Cr.xls 3. Vouchers-V11-Financial-Transactions-Single-line-entry-Basic.xls 4. Vouchers-V11-Financial-Transactions-Single-line-entry-Advanced.xls

TEMPLATE Modifications  1. Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls NEW COLUMNs Column I  - PARENT DR. LEDGER (Specify the Parent Group name for Debit Ledger) Column K - PARENT CR. LEDGER (Specify the Parent Group name for Credit Ledger) Remarks a. These newly added columns are optional. b. However, for Bank entries you must specify the Parent Group Name as "Bank Accounts" for the Bank entries to be reflected in Bank Reconciliation Statement. 2. Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls Remarks For Bank entries you must specify the Parent Group Name as "Bank Accounts" for the bank entries to get reflected in Bank Reconciliation Statement. 3.  Vouchers-V10-Horizontal-Sales-Without-Stockitems.xls Old Formula in Column AC =SUM(AF6:IV6) New ARRAY Formula in Column AC (Press Ctrl + Shift + Enter for Array Formula) =SUM(ROUND(AF6:IV6,2)) In the Column AC, we have now used Array Formula instead of s...

The template "Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls" now includes additional columns for Cost Category and Cost Centre for the Party ledger. TEMPLATE : Vouchers-V10-Sales-Purchase-with-StockItems-Advanced.xls NEW COLUMNS 1. Cost Category (Columns L) 2. Cost Centre (Columns M) The following fixes / corrections have been done in udiMagic v10 Release 2.2 XML Parse error The aforesaid error is displayed while importing the template Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls when the  CompanyName in Tally contains Ampersand Sign (&) . This problem has now been resolved. PS: Those using the older versions of udiMagic can set / enable the option "Disable Fetch Objects" in udiMagic settings to resolve the issue. Invalid USB drive details When activating with USB flash drive, invalid details are shown in certain cases. This problem has now been resolved. New setting option in udiMagic Settings screen A new option ...

SQL Statement with named parameters You can use named parameters :FromDate and :ToDate in your SQL Query to provide input for the fields "From Date" and "To Date" in udiMagic for uploading data from SQL Server to Tally ERP. How to use parameters in SQL query? Here's a sample SQL SELECT query that shows how to use the :FromDate and :ToDate named parameters SELECT field1, field2, fldDate FROM table WHERE table.fldDate>=:FromDate AND table.fldDate<=:ToDate Instead of hard-coding the period (from and to dates) in SQL-query, we have used 2 named parameters viz :FromDate and :ToDate. The values for these parameters are assigned at runtime based on the period you enter in the udiMagic screen. Remarks 1. In udiMagic screen, you must specify the FromDate and ToDate in dd/mm/yyyy format only. 2. The date format of SQL server  or your system may be different (ex: yyyy-mm-dd). However, udiMagic automatically sets the date format internally and hence the...

The following fixes / corrections have been done in udiMagic v10 Release 2.1 Error: Could not set SVCURRENTCOMPANY to (name) An error "Could not set SVCurrentCompany to (name) " is displayed when the CompanyName in Tally contains Ampersand Sign (&) and data is not imported into Tally. This problem has now been resolved. Slow speed issue when ReferenceStyle is set to xlR1C1 The ReferenceStyle is now automatically set to xlA1, if it is xlR1C1. Alternatively, it can be changed using the MS-Excel option "File | Options | Formulas | R1C1 reference style" New setting option in udiMagic Settings screen A new option "Disable SSL" is now included in the udiMagic Settings. This is kept for backward compatibility and is to be used / ticked if "Socket Error 10060" occurs while activating the udiMagic license.

Kerala Flood Cess Kerala state has introduced a new cess named "Kerala Flood Cess" on goods and services w.e.f 01/08/2019. This is a State Cess and is levied on intra-state supplies made by taxable persons (Regular Dealers) to consumers and unregistered dealers. The template "Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls" now includes additional columns which support the new Kerala Flood Cess / State Cess. TEMPLATE : Vouchers-V10-Sales-Purchase-with-StockItems-Advanced.xls NEW COLUMNS 1. State Cess Rate (Columns CW, CX) 2. Addl State Cess Rate(Columns CY, CZ) 3. State Cess ledger (Column DG) 4. Addl State Cess Ledger (Column DH) 5. Tax Classification at Voucher level (Column EM) A sample entry has also been provided in the aforesaid template. Important Notes The aforesaid feature viz. Kerala Flood Cess works only for: a) Kerala State b) Sale to Unregistered dealer or consumer c) Sale date is 01/08/2019 or higher All registered dealer...

How to resolve the error HTTP 406 Not Acceptable? While activating the udiMagic license, if you get the error HTTP 406 Not Acceptable ,  please follow the instructions given underneath. For udiMagic v7.0 and higher versions 1. Download and install the latest release of udiMagic for which you are eligible. 2. Next, activate the udiMagic license using the "Licensing" button in the 2nd screen. Remarks To get the download link, visit  https://www.rtslink.com/customer/forgot/ and enter your udiMagic Serial Number. The download link will be sent to your email id registered with us. For udiMagic v6.0 and lower versions  Please write to us by email to resolve the HTTP 406 Not Acceptable error.

Importing FOREX entries in Tally Some excel templates provided with udiMagic software contain a column to specify the CURRENCY. Here's how you can use these templates for importing FOREX as well as BASE currency transactions in Tally ERP. 1. Keep the CURRENCY column blank, if you want to upload a voucher in base currency. 2. For FOREX entries, specify the CURRENCY name or symbol in the currency column. Please note that the there must be NO space  in the Currency symbol. Valid Currency Symbol : USD Invalid Currency Symbol :  US Dollar Important Note 1. The symbol "US Dollar" has a space and hence is invalid . 2. It is advised that you manually create the Currencies in Tally ERP before importing the FOREX entries. 3. The Currency Symbol must be  ASCII character(s). Example: Don't use the Indian Rupee symbol which is a Unicode symbol; instead use "INR" or "Rs" as the Currency Symbol. 4. Tally ERP does NOT allow spaces in the Currency Sym...

How to convert udiMagic Perpetual license to Subscription license? To convert your udiMagic Perpetual license to Subscription license, follow the underneath steps : 1. Log in into the Customer dashboard [ https://www.rtslink.com/customer/ ] using your Serial and Key. 2. Next, select the tab " License Mgmt " 3. Next, click the " Buy Now " button under the Panel " Conversion from Perpetual to Subscription License " 4. Upon successful payment, your Perpetual license is converted to Subscription license. NOTE Subscription licenses are less expensive than Perpetual licenses and are cost-effective option. 

Entries missing in Tally Bank Reconciliation Problem description When we import the Bank payment or receipt entries with transaction-type as "e-Fund transfer" in Tally, these entries are not shown in the Bank Reconciliation statement. Solution In the transaction type column in the Excel sheet, specify "Same bank transfer" or "Inter bank transfer" instead of "e-Fund transfer" and then retry import the XLS into Tally.

Excel Template Modifications Compound Unit in StockItem Master Template : Master-StockitemMaster.xls Description : This template now includes new fields/columns for specifying "Compound Unit" details viz "First Unit, Conversion Factor, Second Unit" Multi-line Address in Employee Master Template : Master-Employee.xls Description : This template now includes additional columns to specify the Employee Address. Template fixes Template : Vouchers-V10-Journal-with-multiple-references.xls Description : The "IsCostCentreOn" feature is NOT enabled automatically for the newly created ledgers. This bug has been now rectified.

The Customer dashboard now includes a new option : Renewal udiMagic users can now Renew their Subscription based licenses using this option and avail additional benefits. Renewal of subscription has to be done on or before the expiry of the existing subscription period. Users can login into the Customer dashboard using the underneath link : https://www.rtslink.com/customer/

Different methods to import Excel data in Tally There are several ways to import excel data in Tally using udiMagic software. Watch the videos (links given at bottom) to know more. 1. Copy/paste data in Standard template You can put your data in the Standard templates using copy/paste or can manually enter it. However, this may be tedious if the data is voluminous. STEPS Copy/paste from your Excel file into the Standard template Import data from Standard template into Tally ERP 2. Mapping (in Standard Excel template) In this case, you once map the columns in the Standard EXCEL template. Next, the data is copied from your Excel sheet to the Standard template with a single click. You can then import data from the Standard template into Tally using udiMagic.  STEPS Map the columns in Standard template Transfer data from your Excel file into Standard template with a single click Import data from Standard Excel template into Tally ERP See Video (English) :...

Symptoms When you double-click an icon or file name for a Microsoft Excel workbook, Excel starts but displays a blank screen where you expect the file to appear. Resolution Please refer this link to resolve the issue: https://support.microsoft.com/en-in/help/2994633/excel-how-to-troubleshoot-excel-opening-blank-when-you-double-click-a Alternatively,  restart your system and then try opening the Excel file. Notes: The above occasionally happens when you import data from Excel to Tally ERP.

Excel Template Modifications 1. Mapping feature The following templates support the NEW MAPPING feature: Vouchers-V10-Journal-with-multiple-references.xls Vouchers-V10-Payroll-Attendance.xls Vouchers-V10-Physical-Stock-Journal.xls Vouchers-V10-Receipts-and-Payments-with-multiple-references.xls Vouchers-V10-Stock-Journal.xls See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI

Fix : How to fix the error ST Category 'Not applicable' does not exists in Tally ERP 9 Applicable to :  Branch to HO utility (Old users only) Steps to resolve the issue In Gateway of Tally, press F11 and select the option "Statutory & Taxation". Enable the option "Enable Service Tax" and set the option "Define service category and tax details as masters" to Yes. Press Ctrl+A to save the configuration. Next, from Gateway of Tally, select option "Accounts Info >> Statutory Info >> Service Categories". Next, select the option "Create" and specify the Name as "Not applicable" and press Ctrl+A to save the Service Tax Category. Next, disable the "Enable Service Tax" option in "Gateway of  Tally >> F11 >> Statutory & Taxation".

Excel Template Modifications 1. Mapping feature The following templates support the NEW MAPPING feature: Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls Vouchers-V10-Horizontal-Financial-Transactions.xls Vouchers-V10-Horizontal-Purchase-Without-Stockitems.xls Vouchers-V10-Horizontal-Sales-Without-Stockitems.xls See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI 2. New Fields - BANK NAME, BRANCH NAME, IFSC CODE The following templates now include new fields / columns for specifying "Bank details"  viz Bank Name, Branch Name, IFSC Code : Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls

Excel Template Modifications 1. Mapping feature The following templates support the NEW MAPPING feature: Master-LedgerMaster.xls Master-StockItemMaster.xls Vouchers-V10-Financial-Transactions-Basic.xls Vouchers-V10-Financial-Transactions-Advanced.xls Vouchers-V10-Sales-Purchase-Without-Stockitems-Basic.xls Vouchers-V10-Sales-Purchase-Without-Stockitems-Advanced.xls See Video in English :  https://www.youtube.com/watch?v=4bmfRXlQXKc See Video in Hindi :  https://www.youtube.com/watch?v=X-J9X4iSIpI 2. Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls The following new fields / columns have been added: a. PARENT DR LEDGER  (Specify the Parent Group Name for Debit Ledger) b. PARENT CR LEDGER  (Specify the Parent Group Name for Credit Ledger)

Map Your Excel data and Import in Tally ERP The following templates support the NEW MAPPING feature: Vouchers-V10-Bank-statement.xls Vouchers-V10-Bank-statement-Single-Column-Dr-Cr.xls Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls Mapping Feature - How it works? Learn how to use the mapping feature to import your excel data into Tally ERP 9. Here, mapping refers to a process wherein you have to associate each column in the Standard Excel file with the relevant column in your Excel file. See Video in English :  https://www.youtube.com/watch?v=4bmfRXlQXKc See Video in Hindi :  https://www.youtube.com/watch?v=X-J9X4iSIpI

Excel Template Modifications 1. Vouchers-V10-Bank-statement.xls A NEW column for "VoucherNumber" has been included. 2. Vouchers-V10-Bank-statement-Single-Column-Dr-Cr.xls A NEW column for "VoucherNumber" has been included. 3. Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls A NEW column for "SKIPVoucher" has been included. If this contains "Yes", then the Voucher is skipped and is NOT imported into Tally ERP. The default value for this column is "No"

Excel to Tally - udiMagic Single Excel Template  We are pleased to inform you about launch of udiMagic Single Template Edition. udiMagic Single template Edition You can now BUY a Single template as per your requirement. Available on 1 month and 1 year subscription basis. For price details, please visit https://www.rtslink.com/buy/

Fixes in Release 1.3 Supplier and Consignee Address While importing the Purchase Vouchers from Excel to Tally ERP 9, the Supplier Name does NOT appear correctly in Tally. This  has now been rectified and the following Excel templates have been updated : Vouchers-V10-Sales-Purchase-with-Stockitems-Advanced.xls Vouchers-V10-Sales-Purchase-without-Stockitems-Advanced.xls Vouchers-V10-Sales-Purchase-without-Stockitems-Basic.xls Place of Supply The StateName appears more than once in GSTR1 B2C report as the data specified contains GUJARAT and Gujarat. This has now been rectified and the Place of Supply is now converted to Proper case before importing it in Tally.

How to enable Fill handle in Excel? The Fill Handle feature in Excel allows you to select a series of cells with incremental values and drag the cell corner to complete the series. However, if this does not work then check out the following : Click "File" Click "Options" Click "Advanced" Next, tick the option "Enable fill handle and cell drag-and-drop" Next, save the settings and then retry to fill the series by dragging the cell corner.

Import FOREX entries in Tally Using the Excel templates provided with udiMagic v10 Release 1.2, you can now upload Sales and  Purchase entries with Inventory and Multi-Currency into Tally ERP 9. In these latest Excel templates, two additional columns have been provided for CURRENCY and ROE (Rate of Exchange). If you specify the Currency and ROE, the entries are automatically reflected in FOREX currency in Tally ERP 9. If you keep these columns blank, then the entries are uploaded in Tally in base currency. The multi-currency feature is now supported in the following Excel templates : Sales, Purchase, Debit Note, Credit Note entries with Multi-currency Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls For Receipt, Payment, Journal, Contra entries with Multi-currency Vouchers-V10-Financial-Transactions-Basic.xls Vouchers-V10-Financial-Transactions-Advanced.xls