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