Thursday, June 15, 2017

Template modifications

Excel to Tally templates - Modifications
The following changes have been done in udi-Magic Standard templates :

Template-Name : Master-StockItemMaster.xls

1. New fields / columns for VAT and Excise
2. If Alternate units are used, the Opening Stock is not displayed in alternate units - Now fixed.

Template-Name : Master-LedgerMaster.xls

1. New fields / columns related to VAT

Template-Name : Voucher-Physical-Stock-Journal.xls

1. New columns for Base-Voucher-Type and Voucher-Type
2. Voucher Number not imported - Now corrected.

Template-Name : Voucher-Stock-Journal.xls

1.. New VoucherTypes not created as given in the XLS - Now corrected

You can download (all templates) the zip file from this link :

Saturday, May 20, 2017


We are pleased to announce the launch of udi-Magic v8.0. The details are as under :-

A new template for Flipkart Settlement / Receipts has been included in udi-Magic v8.0 as shown below :

Template Name: Vouchers-Flipkart-Receipts-and-Journal.xls
XML-File Name : Vouchers-Flipkart-Receipts-and-Journal-xml-tags.xml

1. Download and install udi-Magic v8.0
2. Copy/paste your Flipkart settlement data into aforesaid template / xls.
3. Start udi-Magic v8.0
4. Go to "Excel to Tally >> Import data into Tally"
5. Select files :
Excel File: Vouchers-Flipkart-Receipts-and-Journal.xls
XML-File : Vouchers-Flipkart-Receipts-and-Journal-xml-tags.xml 

6. Click the Start button to import data into Tally.

For each Settlement Number, two entries are posted in Tally entry for Receipt voucher and another for Journal voucher.

udi-Magic v8.0 works with Tally ERP 9 Release 5.5.8 (latest release at the time of this post).

The GST related updations shall be made available in udi-Magic v8.0 as and when the GST features are made available in the Tally ERP.

udi-Magic v8.0 works with Excel 2016 (32-bit and 64-bit)

1. Customer(s) who have purchased udi-Magic v7.0 on or after 01/01/2017 shall be provided free upgrade to udi-Magic v8.0.
2. Customer(s) who have upgraded to udi-Magic v7.0 on or after 21/02/2017 shall be provided free upgrade to udi-Magic v8.0
3. All eligible customers can get the link to download udi-Magic v8.0, from here:

Wednesday, May 17, 2017

How to fetch the Tally Serial Number ?

SQL SELECT Statement

SELECT $$SerialNumber FROM Company

You can use the aforesaid SELECT Statement to fetch the Tally Serial using "Tally ODBC" or "Calculator panel" in Tally.

Monday, May 8, 2017

Template modifications

Template Name : Master-V6-StockItem-Multiple-price-levels

Bug fixes
1. StockItem ALIAS gets overwritten/removed when the Price List is imported - Now fixed.

Template Name : Master-StockItemMaster

New Field
"Inclusive of Tax" column has been included. Refer blog article :

Calc VAT on MRP
Refer blog article :

Sunday, April 30, 2017

Calculate VAT on MRP

Applicable to : Tally ERP 9 Release 5.5.6

Recently, we noticed some issues while using the "Calc VAT on MRP" feature. We posted two SALES INVOICEs in Tally, the details being as follows :

Sale Invoice 1

Stockitem Master Name: Item CX
MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 5%

Sale Voucher
StockItem Name : Item CX
Qty : 1
Rate : Rs 238.09 (Auto computed in Tally)
Amount : Rs 238.09 (Auto computed in Tally)
VAT Amount : Rs 11.91 (Auto computed in Tally)

Sale Invoice 2

Stockitem Master Name : Item DX

MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 4%
Addl Tax : 1%

Sale Voucher
StockItem Name : Item DX
Qty : 1
Rate : Rs 237.98 (Auto computed in Tally)
Amount : Rs 237.98 (Auto computed in Tally)
VAT Amount : Rs 9.62 (Auto computed in Tally)
Addl VAT Amt: Rs 2.40 (Auto computed in Tally)

As it can be seen, the VAT amount is incorrectly computed when we specify VAT + Addl Tax in the StockItem Master and "Calc VAT on MRP" is enabled.

VAT 5% => Rs 11.91 (Correct VAT in Sale Voucher 1)
VAT 4+1% => Rs 12.02 (Incorrect VAT in Sale Voucher 2)

A workaround is to disable the "Calc VAT on MRP"  and enable "Is Inclusive of duties and taxes" only in the StockItem Master. This way, VAT is computed correctly in both the situations as mentioned above.

Saturday, April 29, 2017

Inclusive of VAT

A new option "Allow inclusive of tax for stock Items" has been included in Tally ERP 9 Release 5.0 onwards. This allows you to prepare Sales Invoice with Rate inclusive of VAT.

Tally ERP 9 Release 5.0
1. Go to Stockitem creation/alteration
2. Press F12 [Config]. This displays the Stockitem Configuration screen as shown underneath :

Tally ERP 9 Release 5.0

3. Enable "Allow inclusive of tax for stock items" as shown above.

4. Back in the Stockitem screen, enable VAT Applicable and specify the VAT Rate using "Set/alter VAT details"
5. Next, set "Is inclusive of duties and taxes" to Yes

Tally ERP 9 Release 5.0

Tally ERP 9 Release 4.92 or lower
1. Go to Stockitem creation/alteration
2. Press F12 [Config]

This displays the Stockitem Configuration screen as shown underneath (without the Inclusive option) :

Tally ERP 9 Release 4.92
The "Is inclusive of duties and taxes" is NOT there in Tally ERP 9 Release 4.92

Sunday, April 23, 2017

Incorrect Unit (UOM) when importing data into Tally

I am importing Sales/Purchase Vouchers with StockItems  using one of the Standard templates provided with udi-Magic. For a specific voucher in the XLS file, the UOM is specified as "Nos", but when I check the entry imported in Tally, it shows the UOM incorrectly as "Kgs".
This would happen if the StockItem already exists in Tally with UOM as Kgs.

You must manually change the UOM in the StockItem Master. And this is only possible if there are no vouchers entries for that StockItem.

Friday, April 21, 2017

Template modifications

Of late, the following modifications have been done in the Standard templates :

Date : 22nd April 2017
Template : Vouchers-Bank-Statement.xls
New Column : Group-Name for Other Ledger
Remarks : If the Group-Name is not specified, then the Ledgers are created under group "New Ledgers"

Previous Changes

Date : 3rd April 2017
Template : Vouchers-V7-Sales-Purchase-Adavanced.xls
New columns in the Settings / CSV file :

Date : 3rd April 2017
Template : Master-LedgerMaster.xls
New columns for :

Date : 30th March 2017
Template : Master-LedgerMaster.xls
New fields added for :

Date : 28th March 2017
Template : Master-LedgerMaster
New column for COUNTRY

Download link (all templates) :

Tuesday, April 4, 2017

Cannot alter unit for Item x

The aforesaid error generally appears while :

Uploading "StockItem Masters" into a Tally Company; which already contains the same StockItem but with a different unit of measurement.

Here's a example :

StockItem with name "Item A" exists in Tally Company having Unit of Measurement (UOM) as "Nos". Let's now try to modify it's UOM to Kgs. As you can see below, the cursor does NOT go the the Unit field.

This is a restriction in Tally Software. You cannot alter the UOM of a StockItem if one or more records / vouchers exist which contain that StockItem

Tuesday, March 21, 2017

Additional Tax in Tally ERP 9

Of late, we noticed some changes in the Ledger Entry screen while creating "Additional Tax" ledger. The same is as follows :

Tally ERP 9 Release 5.4

As you can see, in Tally ERP 9 Release 5.4, the "Type of duty" is to be set as "Additional Tax".

Tally ERP 9 Release 4.93

In Tally ERP 9 Release 4.93, the "Type of duty" is to be set as "VAT" and "Additional Tax" is to be specified in another field "Method of Calculation".

And here is the difference in the XML tags :

Tally ERP 9 Release 5.4
TAXTYPE : Additional Tax

Tally ERP 9 Release 4.93

Monday, February 27, 2017

Activate license with USB Flash / Pen drive

This video shows how to activate the udi-Magic license with USB Flash drive.

If you face any have problems using the above link, you can watch the video at Youtube:

Applicable to udi-Magic v6.0 and higher versions.

Tuesday, January 10, 2017

udi-Magic v3.0 / v4.0

This message is ONLY for udi-Magic v3.0 and v4.0 users. Others, please ignore it.

  • Upgradation of udi-Magic v3.0 / v4.0 to udi-Magic v7.0 has been discontinued since 1/1/2017. Users are required to buy new license of udi-Magic, if they wish to use the new features/version.
  • No support (telephonic, email, or otherwise) shall be available for udi-Magic v3.0 / v4.0.

Email intimations about the same were sent on 3rd Dec 2016 and 29th Dec 2016 to the email ids  registered with us at the time of buying udi-Magic (or updated by the users thereafter).

To verify or update your email ids registered with us, login using the underneath link and select tab/option "Update email".

Shweta Softwares

Sunday, January 1, 2017

Free Support Services & Upgrades w.e.f 1/1/2017

All udi-Magic licenses purchased on or after 1st Jan., 2017  will include Free Support Services & Upgrades for a period 365 days. Free upgrades includes both minor and major Software upgrades.

Support is provided using Ticket system. For any help / assistance, open a ticket.

Earlier, the "Free support services & upgrades" period was 90 days.