udiMagic Free Edition is a free utility to export data from Tally to Excel or to merge two ledgers in Tally. This tool is completely free and you can use it without any restrictions. Tally to Excel: The Tally to Excel feature enables you to export data from Tally ERP 9 to MS-Excel. Though, Tally ERP 9 has inbuilt support to export 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, udi-Magic Free Edition allows you to retrieve selective raw-data using SQL-SELECT statements. How to export data from Tally to Excel? 1.Start udi-Magic Free Edition. 2.Select option "Tally to Excel". 3.Type the SQL statement. 4.Click the Start button. Merge two Ledgers: This feature allows you to merge vouchers of two Ledgers in Tally ERP 9. After merging, all vouchers of the "Source Ledger" will appear under the "Destination Ledger" and the Source-ledger will be deleted. Before you use this feature, you must configure the TDL file as shown below: Steps to configure the TDL: 1.Start Tally and open a Company. 2.Press F12 [Configuration]. 3.Select option "Product and Features". 4.Press F4 [Manage local TDL]. 5.Specify the file c:\udiMagicFreeEditionV20\udiMagic.txt in the List of TDLs to preload If the TDL is configured correctly, then you will be able to see udi-Magic FE in the Gateway of Tally. How to Merge ledgers in Tally? 1.Start udi-Magic Free Edition. 2.Select option "Merge two ledgers". 3.Click the Populate button. 4.Select the Source Ledger. 5.Select the Destination Ledger. 6.Click the Merge button. If you get error "No vouchers found" while merging, kindly recheck the TDL configuration steps.
||2.0 release 1.0
Windows Server 2008
||Tally 6.3, Microsoft Excel 2003