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.
