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.
How to export data from Tally to Excel?
- Start udiMagic Free Edition
- Select option "Tally to Excel"
- Type the SQL statement
- Click the Start button
Example of SQL 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 |
Merge Tally Ledgers
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:
Steps to configure the TDL
- Start Tally and open a Company
- Press F12 [Configuration]
- Select option "Product and Features"
- Press F4 [Manage local TDL]
- 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 udiMagic FE in the Gateway of Tally.
How to Merge ledgers in Tally?
- Start udiMagic Free Edition
- Select option "Merge two ledgers"
- Click the Populate button
- Select the Source Ledger
- Select the Destination Ledger
- Click the Merge button
If you get error "No vouchers found" while merging, kindly recheck the TDL configuration steps.