Another free utility for Tally Users: UdiMagic

ApniTally reader Rajiv has sent me another free utility which can be used by all Tally users. This is called UDI Magic Free Edition. This utility is an excellent tool to bring data out of Tally. This can be in various forms and user can bring out what ever report they want.
Basically it can be termed as bridge program which can fetch data from Tally provided you know which data you want.The utility can be downloaded from this link.
After downloading you can unzip the files and install it on your c drive. You would get icon on desktop.

How to Use it

Although it is a restricted version then the original software called UDI Magic but still i was able to get lot of reports from this utility. Start Tally and Open the company from where you want to pull the data. Be sure that ODBC Server is running.
Double click the icon and the utility is started.
Now press next and choose the first option of Tally to Excell.
Press Next and you would get the are where you have to put the command for data. The utility accepts SQL like commands and the data is shown in the portion below. Try this example, In Tally you cann not get balances off all ledgers. Here you can see all ledgers with their closing balances. Put this command:

Select $Name, $ Closingbalance from ledger

You would get all ledger names with their closing balances. If you want only sundry debtors then modify the command as this:

Select $Name,$ClosingBalance From LEDGER where $$IsChildOf:$$GroupSundryDebtors

This would give you the list of all sundry debtors. This report can be taken from Tally itself by going to Display->Account Books->Group Summery->SundryDebtors
But If you want to call all sundry debtors then this utility would help as this command would provide their phone numbers also with the name and balances. Just insert $LedgerPhone. The command would be :
Select $Name,$LedgerPhone,$ClosingBalance From LEDGER where $$IsChildOf:$$GroupSundryDebtors

This report would be usefull and you would like to print the list of all person with their phone numbers. Just press the button view in excel in the right bottom and it would be transferred in excel and new sheet would be opened from where you can take the print out also.

Similarly following command would show the item report with name , base unit, closing value and closing balance.

Select $Name, $Baseunits, $ClosingBalance, $ClosingValue from StockItem

In case you get some error then perhanps there is a spelling mistake, correct it and try it again.
The readers can face problem in exploring the names of the tags which are used to display report. This problem will be explored and explained in next article.

As a closing note I want to add that if ApniTally readers have free utilities developed by them they can share it with other readers. If some payed products are there which can help the users of the Tally then ApniTally would be happy to review them. They can send the information regarding their products at my email at shailyji at gmail dot com.

Related Reading : Free Utility Recycle Bin for Tally.

Shailendra Yadav

The Post is written with an aim to help Tally software users. You can consider subscribing all my post related to Tally by putting your email id in the box below and joining my email list. If you find the contents interesting then don't forget to share it with your friends.
You can also get professional help like Implementation of Tally in your business or Web Support on tally by asking a Quote.
Be GST Ready with ApniTally and Tally.ERP 9

Join over 5000 Subscribers! Please sign up to receive Updates.

Enter your email address:

Delivered by FeedBurner

0 responses:

 

Copyright @ 2013 Apni Tally.

Designed by Templateiy &Site Developed abd Maintained By Cybertec Solutions