rtslink.com
Home / Free Tally utilities / UDIMagic Free Edition

UDIMagic Free Edition



UDIMagic Free Edition v1.0 Release 2.0 is a FREE Tally add-on utility that provides Tally-add-on features. 


PS:
UDIMagic FREE Edition is a free software and NO support services are provided for it (whether free or on chargeable basis).

How to Install UDIMagic Free Edition ?



STEPS:-
1) Download and Install UDIMagic Free Edition

Remarks:-
On successful installation, you will get a shortcut for UDIMagic FREE Edition on your DESKTOP.

2) Make changes in the Tally.ini (Tally configuration file is located in Tally folder) as shown below :-



Remarks:-
You can use any text-editor like NOTEPAD to edit the Tally.ini file.

3) Next, save the Tally.ini  file.

4) Start Tally Software and open any dummy company.

Remarks:-
When you start Tally Software, you will be able to see UDIMagic TCP 2.x  in the Gateway of Tally menu. Here's how it appears in the Gateway of Tally screen..

Tally versions Remarks
Screen snap-shot of Tally 9 Release 3 [BETA]

Tally 9 Release 3 BETA

If you are using Tally 9 Release 3 [BETA], you must get this screen with UDIMagic TCP 2.x in Gateway of Tally

Screen snap-shot of Tally 9 Release 2.14

Tally 9 Release 2.14
If you are using Tally 9 Release 2.14, you must get this screen with UDIMagic TCP 2.x in Gateway of Tally
Screen snap-shot of Tally 7.2 Release 3.12

Tally 7.2 Release 3.12
If you are using Tally 7.2 Release 3.12, you must get this screen with UDIMagic TCP 2.x in Gateway of Tally



PS:
- UDIMagic FREE Edition has been tested with the above mentioned Tally versions.
- Ensure that you properly mention the TCP file in the Tally.ini file. If you still, do not get "UDIMagic TCP 2.x" in the Gateway of Tally screen then try with the latest EDUCATIONAL version of Tally (i.e. Tally 9)



UDIMagic FREE Edition Features



Merge two Ledgers



Allows you to merge vouchers of two Ledgers. Here's an illustration of a situation wherein this feature can be useful.

Mr X had been posting his routine expenses into various ledgers a/c as show below:-
a) Newspaper Expenses
b) Tea Expenses
c) Office Expenses.

However, when his Chartered Accountant saw the entries in Tally Software, he advised that only one ledger must be kept for all these expenses as they of are of small amounts. He advised that the entries of "Newspaper Expenses" and "Tea Expenses" to be merged into "Office Expenses" ledger. In brief, only one ledger viz "Office Expenses" was required.

Merge two Ledgers


Mr X used UDIMagic Free Edition to Merge two ledgers. Here's a screen-snapshot of UDIMagic Free Edition. 

Step 1  
Source Ledger        : Newspaper Expenses
Destination Ledger : Office Expenses

Remarks:
Merge Ledger "Newspaper Expenses" into "Office Expenses"

Step 2
Source Ledger        : Tea Expenses
Destination Ledger : Office Expenses

Remarks:
Merge Ledger "Tea Expenses" into "Office Expenses"




Please See:-
After merging,  all vouchers of the "Source Ledger" will appear under the "Destination Ledger" and the Source-ledger will be deleted.


Delete a Ledger (including all its transactions)



Allows you to DELETE a Ledger including all its transactions.

Merge two Ledgers


Here's a screen snapshot of Delete a Ledger (Including all its transactions).

Caution:-
Once a ledger is deleted (including all its entries), the same cannot be retrieved back. Hence, be careful before you use this feature.















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://www.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.


Downloads


>>  UDIMagic Free Edition





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