rtslink.com
Home / Free Tally utilities

FREE Tally Utilities 




UDIMagic Free Edition


UDIMagic Free Edition v1.0 Release 1.0 supports the following features :-

a) Tally to Excel
b) Tally Customized Reports

Tally to Excel
This feature enables you to retrieve data from Tally Accounting Software into MS-Excel  (using SQL-SELECT statements).

Remarks:-
Though Tally 9 supports export of Tally data into MS-Excel format, this functionality is primarily restricted to export of Tally Reports and NOT raw data or selective raw-data. Contrary to this, UDIMagic Free Edition allows you to retrieve selective raw-data using SQL-SELECT statements.



Example 1 - Using SQL-SELECT statement to retrieve Tally data into MS-Excel

Select $Name,$LedgerPhone,$Email From LEDGER where $$IsChildOf:$$GroupSundryDebtors

Remarks:-
The above SELECT-statement retrieves all the Party-Names, Phones numbers; Emails-addresses; ClosingBalances of all Parties falling under the group Sundry Debtors.



Here are some useful links for learning / writing SQL-SELECT statements supported by Tally :- 

a) Using SQL-SELECT statements:-  http://rtslink.com/Tally-Integration-Using-SQL-SELECT-to-fetch-Tally-data.htm
b) Using TDL functions :-  http://www.rtslink.com/TDL-functions-Alphabetical-Listing.htm


Tally Customized Reports

As of now, only one Report (i.e. Negative Stock) is available under this option. This report displays all Stock-items which have negative balance on any date during the specified period.

Remarks:-
Tally Software comes with "Negative-stock" report. However , if any stock-item has a negative balance during the year but has positive balance on year-end (i.e 31-3-yyyy), it will not be listed in this Report. As a result, this report does not provide true picture of the Negative stock.

Recycle Bin for Tally


Allows you to retrieve records that you may have accidentally deleted in Tally. It is similar to Windows Recycle bin which allows you to retrieve deleted files.

For more information on Recycle-bin, click here.



Downloads


>>  UDIMagic Free Edition v1.0 Release 1.0

>>  Recycle bin for Tally





Tags:
RTSlink DLL, UDIMagic, Tally Integration tools, Excel to Tally, Free Tally Tools, Utilities, Tally 7.2, Tally 9
Tally is a registered trademark of Tally Solutions FZ LLC.

Valid HTML 4.01 Transitional