udiMagic v11 Release 1.4

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  K]
Must contain a valid State-name as per Tally's State-Name list. An alert message will be displayed if the Excel contains invalid state-name.

3. Unit of Measurement
An alert message is displayed if this is empty. The default value "Nos"  is  used in such cases.

udiMagic v11 Release 1.3

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 template.

OTHER TEMPLATE MODIFICATIONS

1. Master-StockItemMaster.xls

The following new fields have been added :
a. Cess on Quantity (Column BI)
b. State Cess on Quantity (Column BK)

2. Vouchers-V11-Sales-Purchase-with-Stockitems-Advanced.xls

The following new fields have been added :

a. Shipping Bill No (Column FQ)

b. Shipping Bill Date (Column FR)

c. Port Code (Column FS)

FIXES

1. Vouchers-V11-Sales-Purchase-with-Stockitems-Advanced.xls

An error "Cost Centre xxx does not support forex amount" appears when Sales or Purchase entry without Stockitems is imported in Tally and the entry included Cost Centres and forex currency. This issue has now been corrected.

Could not set SVCURRENTCOMPANY

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 :

1. Open your Company in Tally ERP
2. Press Ctrl+F3 to select the "Company Info" 
3. Next, select the option "Alter"
4. 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"

Solution

A. Upgrade to the latest version of udiMagic; 

or 

B. Change the Company name in Tally. Example: "ABC and Co"

udiMagic v11 Release 1.2

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.

INTRODUCING UDIMAGIC V11.0

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

udiMagic v10 Release 2.3

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 simple Sum() function. This is because we need to Round off the values to 2 decimals before adding them using the Sum() function.

What are Array Formulas?
Array formulas are powerful formulas that enable you to perform complex calculations that often can’t be done with standard worksheet functions. They are also referred to as "Ctrl-Shift-Enter" formulas, because you need to press Ctrl+Shift+Enter to enter them.

4. Vouchers-V10-Horizontal-Purchase-Without-Stockitems.xls

Array Formula used in Column AC as mentioned in the previous point

OTHER CHANGES
The following fixes / corrections have been done in udiMagic v10 Release 2.3

Invalid key
The aforesaid error appears when we copy/paste the udiMagic Serial Number while activating the license. This problem has been now resolved. In the older versions, users can use "Right-click and then Paste" functionality to paste the Serial Number. 

XML Parse error
The aforesaid error is displayed when udiMagic Software is started and then the software hangs. This problem has been now resolved.

udiMagic v10 Release 2.2

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 "Remove Invalid XML Chars automatically" is now included in the udiMagic Settings. When enabled, invalid XML chars are automatically removed from text data. This option is enabled, by default.

PS:
Option "Use Advanced sockets" has now been removed from the udiMagic settings. This option was kept for backward compatibility purpose only and hence has been now removed. 

SQL Server : Using named parameters in SQL Query

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 there is no need to change your SQL Server / System date format.

udiMagic v10 Release 2.1

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.

udiMagic v10 Release 2.0

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 dealers who levy this cess have to file a separate KFC-A form online,

TODO
Users must manually set/modify the Kerala Cess Rate in StockItem master and set the effective date to 01/08/2019

Changes in other templates

Master-LedgerMaster.xls
New column for Kerala Cess/State Cess  been added.

Master-StockItemMaster.xls
New column for Kerala Cess/State Cess  been added.

Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls
New column ChequeRange been added

Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls
New column ChequeRange has been added

Fixes in Master-StockItemMaster.xls

1. The section "Advanced Settings to Append data date-wise" for StandardPrice / StandardCost  / MRP / PriceLevel does not work. This has been now rectified.

2. Stock-item Rate is not imported correctly when the Unit of measurement (UOM) is specified in Column "PerUnit". This has now been rectified.

3. The batch-wise Opening Qty is imported incorrectly (for the 1st batch) when the stockitem has two or more batches. This has now been rectified.

License Activation Error : HTTP 406 Not Acceptable

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.

Working with Multi-Currency in Tally

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 Symbol.

Convert from Perpetual to Subscription license

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 not shown in Bank Reconciliation

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.

udiMagic v10 Release 1.9

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.

Customer dashboard

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/

3 ways to Import data in Tally

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) :  https://www.youtube.com/watch?v=4bmfRXlQXKc

See Video (Hindi) : https://www.youtube.com/watch?v=X-J9X4iSIpI

3. Mapping (in udiMagic Software)

In this case, you once map the columns in the udiMagic Sofware itself. You can then import data directly from your Excel sheet into Tally using udiMagic.

STEPS

• Map columns in udiMagic software
• Import data directly from your Excel file into Tally ERP

See Video: https://www.youtube.com/watch?v=8axVdhAJ6zM

Excel opening blank when you double-click a file icon or file name

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.

udiMagic v10 Release 1.8

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

ST Category does not exist

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

1. In Gateway of Tally, press F11 and select the option "Statutory & Taxation".
2. Enable the option "Enable Service Tax" and set the option "Define service category and tax details as masters" to Yes.
3. Press Ctrl+A to save the configuration.
4. Next, from Gateway of Tally, select option "Accounts Info >> Statutory Info >> Service Categories".
5. Next, select the option "Create" and specify the Name as "Not applicable" and press Ctrl+A to save the Service Tax Category.
6. Next, disable the "Enable Service Tax" option in "Gateway of  Tally >> F11 >> Statutory & Taxation".

udiMagic v10 Release 1.7

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

udiMagic v10 Release 1.6

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)

New Mapping Feature - udiMagic v10 Release 1.5

Map Your Excel data and Import in Tally ERP

The following templates support the NEW MAPPING feature:

1. Vouchers-V10-Bank-statement.xls
2. Vouchers-V10-Bank-statement-Single-Column-Dr-Cr.xls
3. Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls
4. 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

udiMagic v10 Release 1.4

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"

udiMagic Single Template Edition

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/

udiMagic v10 Release 1.3

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.

Fix: Excel Fill Handle is missing

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 :

1. Click "File"
2. Click "Options"
3. Click "Advanced"
4. Next, tick the option "Enable fill handle and cell drag-and-drop"
5. Next, save the settings and then retry to fill the series by dragging the cell corner.

Multi-Currency Excel templates

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