udiMagic Release Notes

UDIMagic || Excel to Tally Here's a sample Excel-sheet that contains Stock-Item Master data along with some advanced features as given below:- a) Price List Tally Software provides a feature called Price-list wherein users can define different price structures/level for different purposes, generally for different Group of Customers requiring different discounts. To enable this feature in Tally 9, use option:- "Gateway of Tally -> F11 -> Inventory features -> Use Multiple Price Levels" and set it to YES. This prompts you for "Company Price Levels" dialog-box. Create a PRICE-LEVEL called MRP, that will be used while importing data from Excel sheet. The sample Excel sheet provided herewith contains MRP (Column R) and Discount (Column Q) which is imported into the PRICE-LEVEL feature using UDI-Magic. b) Specify default Ledger Allocation for Invoicing This feature allows you to specify the default Ledger Allocation for each Stock-item along with the VAT-...

UDIMagic || Excel to Tally Here's a sample Excel-sheet that contains Purchase Vouchers with VAT and Discount . Follow these steps to import the Excel-sheet data into Tally Software. 1) Download and unzip the files into "c:\udi-magic" folder. 2) Start the Tally software and create/open a Dummy Company. 3) Minimize Tally Software 4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". 5) Next, select the Excel sheet. Remarks:- The XML tags in this case have been written in the Excel-sheet itself. Hence, you must uncheck the option "Use separate file for XML tags" while using UDI-Magic. 6) Next, follow the instructions given in the wizard-screen to import data into Tally.

UDIMagic || Excel to Tally Here's a sample Excel-sheet that contains Customer and Supplier Ledger Masters . Follow these steps to import the Excel-sheet data into Tally Software. 1) Download and unzip the files into "c:\udi-magic" folder. 2) Start the Tally software and create/open a Dummy Company. 3) Minimize Tally Software 4) Run UDIMagic utility, select option "Excel to Tally -> Master". 5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet. 6) Next, follow the instructions given in the wizard-screen to import data into Tally. PS: The XML tags are provided in a separate file. While importing data into Tally using UDIMagic, you must select the XML tags file also in the same screen wherein you are prompted to select the Excel Sheet.

UDI-Magic || Excel to Tally Here's a sample Excel-sheet that contains Credit Note Vouchers of an Advertisement firm. Follow these steps to import the Excel-sheet data into Tally Software. 1) Download and unzip the files into "c:\udi-magic" folder. 2) Start the Tally software and create/open a Dummy Company. 3) Minimize Tally Software 4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". 5) Next, select the Excel sheet and the XML-tags file when prompted. Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet. 6) Next, follow the instructions given in the wizard-screen to import data into Tally. Remarks:- The ZIP file contains 3 files viz:- a) circulation-credit-notes.xls (Excel-sheet) b) circulation-credit-notes-xml-tags.xml (XML-tags file) c) circulation-credit-notes-macro.txt (Macro file) XML-Tags Normally, in the previous samples the XML tags were written in the Excel-sheet itse...

UDIMagic supports import of Masters and Vouchers data from Excel to Tally. It also supports UDF (user-defined fields) created using Tally Definition Language (TDL). A sample Excel sheet "Vouchers - Sales Transactions with Salesman UDF" has been provided for evaluation. To use it, you must download both the Excel sheet and the TDL file. The links for downloading the Excel sheet; TDL file are given in my earlier post " Sales Vouchers with Salesman UDF ". Further, you need to enable the Salesman UDF using the F11 [features] key. For more details in this TDL (Salesman UDF), refer our blogsite tdlplayground .

If you are using macros (VBA code) with UDIMagic, you may get the above error-message if you are using Office 2003 or above. Here's how you can solve this issue:- Open Excel Goto Tools -> Macros ->Security In the Security Window choose the Trusted Publisher Tab Click "Trust Access to Visual basic Project" and enable it. Click OK. Close Excel.

UDIMagic || Excel to Tally This is in continuation of my previous post wherein we had provided a sample Excel sheet with Receipt Vouchers. Herein, a sample Excel-sheet containing multiple user-defined Receipt Vouchers is being provided. Follow these steps to import data from this Excel-sheet into Tally Software. 1) Download the Excel sheet and copy it to "c:\udi-magic" folder. 2) Start the Tally software and create/open a Dummy Company. 3) Minimize Tally Software 4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". Next, select the Excel sheet when prompted. 5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally. Remarks:- The XML tags are written in cell A1 (comments section) of the Excel sheet. Alternatively, we can write the XML tags in a separate file also.

UDIMagic || Excel to Tally Here's a sample Excel-sheet that contains Receipt Vouchers of an Advertisement firm. Follow these steps to import Receipts Vouchers from this Excel-sheet in Tally Software. 1) Download the Excel sheet and copy it to "c:\udi-magic" folder. 2) Start the Tally software and create/open a Dummy Company. 3) Minimize Tally Software 4) Run UDIMagic utility, select option "Excel to Tally -> Voucher". Next, select the Excel sheet when prompted. 5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally. UDIMagic is a simple and robust utility. It allows you to import any data from Excel into Tally including both Masters and Vouchers. How does UDIMagic work ? You may have Excel-sheet format with any type of Vouchers or Masters. UDIMagic can process it and send it to Tally within seconds. UDIMagic uses XML tags to identify and read the Excel sheet data. End-users who are not familiar with XML tags, can take...