udiMagic Free Edition is a free utility to export data from Tally to Excel or to merge ledgers in Tally. This tool is completely free and you can use it without any restrictions. However, no support technical support is provided for udiMagic Free Edition.
udiMagic Free Edition works with the latest version of Tally ERP 9.
Download it from here :
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, udiMagic Free Edition allows you to retrieve selective raw-data using SQL-SELECT statements.
SQL Statement | Table | Remarks |
---|---|---|
SELECT $Name, $LedgerPhone, $Email FROM ledger WHERE $$IsChildOf:$$GroupSundryDebtors | Ledger | Export data from Tally ERP 9 for all Parties falling under the group Sundry Debtors |
SELECT $Name, $LedgerPhone, $Email FROM ledger WHERE $$IsChildOf:$$GroupSundryCreditors | Ledger | Export data from Tally ERP 9 for all Parties falling under the group Sundry Debtors |
SELECT * FROM ledger WHERE $$IsChildOf:$$GroupSundryDebtors | Ledger | Export all data for all Customers from Tally to Excel |
SELECT * FROM ledger WHERE $$IsChildOf:$$GroupSundryCreditors | Ledger | Export all data for all Vendors from Tally to Excel |
SELECT $Name,$AdditionalName as PartNo FROM StockItem | StockItem | Export Name and PartNo of all StockItems from Tally to Excel |
SELECT $Name,$$Alias FROM StockItem | StockItem | Export Name and Alias of all StockItems from Tally to Excel |
This feature allows you to merge Tally ledgers i.e. 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:
If the TDL is configured correctly, then you will be able to see udiMagic FE in the Gateway of Tally.
If you get error "No vouchers found" while merging, kindly recheck the TDL configuration steps.