udiMagic Release Notes

This is further to my earlier post on the above subject-matter. Multiple Price Levels in Tally Tally Accounting Software allows you to maintain "Multiple Price levels". This feature is useful in situations wherein you have different types of Customers like "Wholesale Customers", "Retail customers", "Export Customers" etc. Using the "Multiple Price Levels" feature you can assign different prices (or discounts) to different types of Customers. UDIMagic and "Multiple Price Levels" in Tally UDIMagic allows you to Import "Multiple Price Levels" data into Tally. Here's a detailed writeup on how you can import "Multiple Price Levels (Price List)" data into Tally Software along with sample Excel sheet and XML tags.

FAQs: Tally-to-Tally While using the UDIMagic Tally-to-Tally feature to transfer "Sales vouchers" from source-company as "Purchase vouchers" into the destination-company, I get the following error :- XML tags <SVCURRENTCOMPANY> not found. Cause of Error:- The aforesaid generally occurs when you have NOT specified the UDIMagic TCP file in your Tally.ini file. Solution:- Open the Tally.ini (which is there in Tally folder) and add the following lines depending upon Tally version you are using. ;;For Tally 7.2 users User TDL = Yes TDL = C:\tally\udimagic72.tcp ;;For Tally 9 users User TDL = Yes TDL = C:\tally\udimagic9.tcp ;;For Tally 9 Release 3 [Beta] User TDL = Yes TDL = C:\tally\udimagic9-R3.tcp Remarks:- 1) Ensure that the UDIMagic TCP file exists in your Tally folder. 2) The aforesaid UDIMagic TCP files get copied into "c:\udi-magic" folder when you install the UDIMagic software. 3) You must use the udimagic9-r3.tcp file with Tally 9 Release 3 [B...

FAQs: Import data from Foxpro DBF into Tally I am using the UDIMagic software to import data from my Foxpro DBF into Tally. While running UDIMagic, I am getting the following error :- "Parameter has no default value" Cause of Error:- The above error generally errors when incorrect field-name is specified in the SQL-SELECT statement. Solution:- 1) Check (and rectify) the field-name(s) specified in the SQL-SELECT statement. 2) Also ensure that you have specified the correct folder-name which contains the DBF's from which data is to be imported into Tally . The steps to specify the folder-name are as follows :- STEP 2a STEP 2b

Batch Processing UDIMagic v3.0 Release 1.67 supports " Batch Processing ". In simple words, it allows you to " Import of data from multiple Excel sheets " in one-go. Before going into the details of this feature, let's have a look at the Auto-Run feature of UDI-Magic which was introduced some-time back ( UDIMagic v3.0 Release 1.60 ). Auto Run The Auto-Run feature allows import of data into Tally without any user-intervention. The auto-run status report is generated in autorun.txt file. Scheduling UDIMagic to run a specific time With the Auto-Run and Batch-Processing features, you can automate your tasks. In simple word...

In UDIMagic v3.0 Release 1.64 , the Branch to Head Office feature supports data transformation also. Here are some examples of data transformation :- Example 1 : Transform Sales vouchers as "Branch Sales" Assuming that at your Branch Office, "Sales" vouchers are entered. Your requirement is that when the Branch-data is imported into the Head Office Tally, it must be imported as "Branch Sales" vouchers. Example 2: Import specific Voucher-types only At you Branch-Office, various type of entries like "Sales", "Receipt", "Payment" etc are done in Tally. You need to import the Branch-Office data in your Head-Office Tally, but only the "Sales" entries are to be imported, that too as "Branch Sales". Remarks:- 1) We have listed some examples of data transformation. 2) UDIMagic [Professional] provides two features viz Tally-to-Tally and Branch-to-HO which support Data-transformation. 3) Almost all-types of Dat...

FAQ's - Excel to Tally I am using UDI-Magic to import data into Tally. Even though I have started Tally and opened one Company, UDI-Magic still shows error message "No company is opened in Tally". How do I solve this problem ? Temporary Solution Those who are using UDI-Magic Demo for evaluation purpose, are requested to follow these steps :- 1) Close the Tally Software. 2) Next, press Ctrl+Alt+Del. 3) Next select " Task Manager " 4) Next, search for Tally9.exe (or Tally72.exe under processes-tab) and click on the End-Process button to close it. 5) Next, search for TallyLicServer.exe (under processes-tab) and click on the End-Process button to close it. 6) Next, start Tally Software and open your Company. 7) Run UDI-Magic and try importing data in Tally Software. Remarks:- Re-start the Computer afterwards so that workstations can access the Tally-license Server which we had terminated manually.

FAQs "How is the mapping of Excel sheet cells done with the Tally fields ? " UDIMagic uses XML tags for mapping Excel Sheet cells with the Tally fields. The XML tags can be written using any text-editor like NOTEPAD. There are two ways of writing XML tags viz 1) In the Comments of Cell A1 (or any other cell in 1st row) in the Excel sheet itself 2) In a separate file with extension XML. For those who are totally new to XML, initially it may be difficult to digest all these things. But then, it is not very difficult. We have provided several tutorials at Learn-Tally-XML-Tags blog-site There is one more tutorial which covers the basics of " Writing XML tags " with step-by-step Instructions. You can get several other good reference / links from our web-site at www.rtslink.com/udimagic-standard.html PS: End-users need not worry about learning XML tags to use UDIMagic. Shweta Softwares provides the XML tags. Refer www.rtslink.com/orderinfo.html for more information. Ti...

This Post provides Tally-to-Tally Rules for converting Sales vouchers to Purchase. Download 1) Sales-to-Purchase Rules (zip file) 2) Instructions for using Tally-to-Tally feature (PDF file) What is Tally to Tally ? UDIMagic v3.0 [Professional] comes with a feature called Tally-to-Tally that allows you to transform Tally data. As the name suggests, the Tally-to-Tally feature allows you to retrieve data from one Tally Company; apply transformation rules; and then send it to another Tally Company. For more information, refer Tally-to-Tally

FAQs I am having X records (say 10,000 records) in my Excel Sheet. I am using the licensed version of UDI Magic. However, UDI Magic processes only few records (say 100 records). What could be the reason ? It is likely that your Excel Sheet has a BLANK-ROW or HIDDEN-ROW at or near the ROW-number 100 in the Excel Sheet. Remove that and try again. It should work. PS: 1) UDI Magic stops processing if it finds a BLANK-ROW or a HIDDEN-ROW. 2) If you are using DEMO version of UDI Magic, then only 5 or 10 records (Vouchers and Masters resp.) shall be processed.

UDIMagic v3.0 Release 1.62 UDIMagic v3.0 Release 1.62 allows you to transform (Branch office) data before importing it into Head-Office Tally Accounting Software. Illustration Branch Office Assuming, you have a Branch Office wherein Accounting is done in Tally. Here, at the Branch Office, only SALES vouchers entries are done. Now, you need to transfer the Branch Office data to Head-Office. Head Office At the Head-Office, you need to maintain consolidated data and hence will be importing the Branch-office data into the Head-Office (Tally). However, you want that the SALES vouchers (of Branch Office) be transformed/renamed as "BRANCH SALES" and then the same to be imported into the Head-Office Tally. In simple words, this allows you to have TWO different Sales Voucher-types. i.e. one for Head-Office Sales and another for Branch-Office sales (BRANCH SALES voucher-type). UDIMagic v3.0 Release 1.62 allows you to apply transformation rules to the Branch Office data before import...

UDIMagic - Excel to Tally The UDIMagic v3.0 Release 1.61 allows you to import specific rows from MS-Excel into Tally Software. To import part-data, you need to specify the FROM and TO rows. By default, all rows are processed by UDIMagic. However, UDIMagic stops processing when it finds a BLANK row or a HIDDEN row.

FAQ's : Excel to Tally I want to import MS-Excel data into Tally such that TWO Vouchers are passed for each record in the MS-Excel sheet. Is it possible using UDIMagic Software? Yes. It can be done. Information for UDIMagic Partners All you need to do is to write XML tags that contain TWO <VOUCHER> tags. Each <VOUCHER> tag will post one Voucher into Tally. The XML tags file will look like this :- <-- XML tags to create 1st Voucher --> <VOUCHER> .... XML tags ..... </VOUCHER> <-- XML tags to create the 2nd Voucher --> <VOUCHER> .... XML tags ..... </VOUCHER> Remarks:- As you can see, we have specified TWO <VOUHCER> tags in the XML tags file for posting TWO vouchers for a single Excel-sheet record.

FAQs : Excel to Tally I am trying to import Vouchers into Tally Software using UDI-Magic Software. Though UDI-Magic shows no errors still no data is imported into Tally and the Tally screen (calculator panel) shows error "Cant' Import. Please check Tally.imp file" The above error generally appears if you are using the Tally Demo (Educational) version and the Vouchers in the Excel Sheet have DATE's other than 1st or 2nd (of any month). The Educational version of Tally accepts Vouchers for the 1st and 2nd of each month . i.e. You cannot import Vouchers having date other than the 1st or 2nd of any month.

"Voucher Totals do not match. Dr 122.00 Cr 122.00 Diff 0.00 " Surprised. Even though the Debit and Credit figures shown in the error are same, Tally Software still shows Dr and Cr mismatch. Cause of the Problem:- It is likely that the Excel sheet that you are using contains some FORMULA's. Though the display format (may) have been set to 2 decimals, MS-Excel internally does not round it off to 2 decimals until you use the =ROUND() function. Solution :- Search for FORMULA's used in the Excel sheet and use the =ROUND() function wherever decimal points are required. For example, let us assume, cell D2 has a FORMULA. i.e. =+A2 / B2 . You must change it to =Round(+A2 / B2,2) Remarks:- 1) You can set the number of decimals places DISPLAYED in Excel-sheet using option "Format >> Cell >> Number". However, when UDIMagic programmatically retrieves the cell-data, MS-Excel may return a different value which is not rounded-off to two decimals. 2) Hence,...

CSV (Comma Separated values) files are plain-text files having extension (.csv or .txt) that contains data-values that are separated by commas. The first line in the file must be the Header-line and is followed by data-rows. CSV files can be directly opened/ viewed in MS-Excel. This post provides a CSV file that contains Ledger-Master records. Follow the steps given underneath to import data from the CSV file into Tally 9 :- STEPS:- 1) Download and unzip the ledger-master-csv.zip file. The zip file contents are :- a) Ledger-Master.csv (Can be directly opened in MS-Excel) b) Ledger-Master.xml (Use Internet Explorer to view this file) 2) Next, start Tally and create/open any Dummy Company 3) Next, minimize Tally 4) Start UDIMagic Software 5) Select option "Excel to Tally" 6) Select option "Masters" 7) Next, select the CSV file by clicking on the Browse button. By default, only Excel-files are displayed in the list-box. You need to set the option "Files o...

UDIMagic v3.0 Release 1.60 comes with a new feature called Auto-Run . What is Auto Run ? The Auto Run feature allows you to setup UDIMagic to run automatically without any User-intervention. Once this feature is enabled, you can add UDIMagic to "Windows Scheduler" to run UDIMagic at scheduled timings. How to enable the Auto Run mode in UDIMagic ? 1) Start UDIMagic and follow the wizard instructions to import data as you normally do. 2) In the Settings screen, click on the "Enable Auto Run" check-box to enable it. 3) Next, click on the Start button to import data into Tally. This now enables Auto-Run mode; and few lines are added to the UDIMagic.ini (configuration) file. You can also manually edit the UDIMagic.ini (configuration) to enable/disable the Auto-Run feature. How do I add UDIMagic to Windows Scheduler ? 1) From the Windows Start menu, select "Settings >> Control Panel" 2) Next, select Scheduled Tasks This displays...

Tally Solutions, Bangalore has come out with a new Release of Tally Software. i.e. Tally 9 Release 3 Beta. What is BETA Software? Beta is a nickname for software which has passed the alpha testing stage of development and has been released to a limited amount of users for software testing before its official release. Tally 9 Release 3 BETA Some new and advanced features have been introduced in the Tally 9 Release 3 which relate to :- a) Tally Synchronization b) Accessing Tally data over Internet The new features and functionality are applaudable. However, this is a BETA version and many problems have been reported with this new Release 3 BETA. As there are several issues; I am not putting up all the problems / issues here. As a result we advice all our Customers (users of RTSlink DLL and UDIMagic software) to wait till Tally Solutions, Bangalore comes out with a stable Release.

UDIMagic v3.0 Release 1.56 comes with a new feature "Branch to Head Office". This module allows you to transfer Tally Accounting data from your Branch Office to Head Office without using the Tally Synchronization feature. UDIMagic "Branch to HO" module is an alternative to Tally Synchronization feature. The primary objective herein is one-way transfer of data. i.e. from Branch Office to H.O.For more information, please refer " Transfer Branch Office [Tally] data to Head Office ".

You can now access all the Excel Sheet templates for importing Masters and Vouchers into Tally from this link :- http://www.rtslink.com/download-excel-sheets.html

Write to us for Online Demonstration of UDIMagic. The Demo shall be provided right in your System, by our staff sitting in our Office at Gandhidham, Gujarat. For more information, refer http://www.rtslink.com/contact.html

Here's a sample Excel sheet which contains Stock Item Master records with the following details:- a) UDF (User-defined-field) named UPDATEDDT b) Standard Cost c) Standard Price d) Alternate Units e) Default Ledger f) Multiple Godowns g) Batch Expiry Download the Excel sheet with XML tags. Remarks:- The primary objective of this sample Excel sheet and XML tags is to provide basic understanding as to how you can use UDF's (User-defined-fields created using Tally definition language) with UDIMagic. The XML tags relating to the UDF will be ignored if the TDL does not exist.

When we import the Stock-Item Masters with Standard Cost /Price data into Tally 9, the existing Standard Cost / Price data gets overwritten. For more information, please refer :- Tally 9 Bug: Importing Stock Masters with Standard Cost / Price UDIMagic v3.0 Release 1.50 comes with new functionality that allows you to import Stock Item Masters (with Standard Cost / Price data) into Tally 9 without overwriting the existing data.

UDI Magic [Light] is light-weight version of UDI Magic [Standard] . It supports Import of MASTER's from MS-Excel into Tally Accounting Software. UDI Magic [Light] is a low-priced utility which is particularly useful for Customers who wish to Import only Masters from MS-Excel into Tally. It is also useful for Tally Professionals who wish to provide solutions to end-users for importing Masters data from Excel into Tally. However, it does NOT support import of Vouchers from MS-Excel into Tally. Features - Supports import of all Masters from MS-Excel into Tally Software - Supports user-defined-fields created using TDL - Supports VBA (Visual Basic for Applications) (a powerful feature that is useful for performing calculations and manipulating Excel data at runtime) For Cost details, please refer www.rtslink.com/buy.html For other terms and conditions, please refer www.rtslink.com/orderinfo.html For learning "How to write XML tags ?" , please refer www.learn-tally-xml-...

Here's a sample Excel file that contains "Purchase" Vouchers with multiple VAT rates which are to be imported into Tally. Follow these steps to Import the Excel sheet data into Tally Software. 1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project 2) Download and unzip the files into "c:\udi-magic" folder. Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder. 3) Start the Tally software and create/open a Dummy Company. 4) Minimize Tally Software 5) Run UDIMagic utility, select option "Excel to Tally -> Voucher". 6) 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. 7) Next, follow the instructions given in the wizard-screen to import data into Tally...

Here's a sample Excel file that contains "Shares sale and purchase" transactions which are to be imported into Tally. Follow these steps to Import the Excel sheet data into Tally Software. 1) Download and unzip the files into "c:\udi-magic" folder. Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder. 2) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project 3) Start the Tally software and create/open a Dummy Company. 4) Minimize Tally Software 5) Run UDIMagic utility, select option "Excel to Tally >> Voucher". 6) Next, select the XML-tags file and the Excel sheet 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. 7) Next, follow the instructions given in the wizard-screen to import data into Tally....

Here's a sample Excel file that contains "Sales" Vouchers with Multi-currency ; Cost Category and Cost Centres which are to be imported into Tally. 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) Enable the following features in Tally 9 a) F11 -> Accounting Features -> Allow Multi-Currency b) F11 -> Accounting Features -> Maintain Cost Centres c) F11 -> Accounting Features -> More than ONE Payroll / Cost Category 4) Minimize Tally Software 5) Run UDIMagic utility, select option "Excel to Tally -> Voucher". 6) 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. 7) Next, follow the instructions given in the wizard-screen to import data into Tally. ZIP file c...

Want to learn Tally XML tags and import Excel data into Tally... Here's our new blog Learn Tally XML tags that attempts to teach you write XML tags to import data into Tally Software.

Here's a sample Excel file that contains "Sales" Vouchers with multiple VAT rates which are to be imported into Tally. Follow these steps to Import the Excel sheet data into Tally Software. 1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project 2) Download and unzip the files into "c:\udi-magic" folder. Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder. 3) Start the Tally software and create/open a Dummy Company. 4) Minimize Tally Software 5) Run UDIMagic utility, select option "Excel to Tally -> Voucher". 6) 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. 7) Next, follow the instructions given in the wizard-screen to import data into Tally. Z...

Here's a sample Excel file that contains "Journal" Vouchers which are to be imported into Tally. In this sample, macros have been used to lookup the Masters data. The sample Excel-file contains two sheets as shown below:- 1) Vouchers 2) Masters Here's how the "Vouchers" sheet looks like:- Here's how the "Masters" sheet looks like:- Remarks:- 1) The "Vouchers" sheet contains a Column "Bank Name". The values in this Column are replaced at run-time using VBA (macros). Example :- "Axis" is replaced with "Axis bank Ltd" at runtime. 2) In the "Masters" sheet, we have specified the Group-Name under which the Account is to be created. 3) In case, if a Master is not specified in the "Masters" sheet, UDI-Magic automatically creates that Ledger under a Group called "New Ledger Items". Follow these steps to Import the Excel sheet data into Tally Software. 1) As macro file is used, you...

When you Download and install UDIMagic Demo version, few sample Excel sheets get created when you run it for the first time . We have noticed that the Excel sheets containing Voucher records (Sales; Purchase; Payment; Receipt etc) had Voucher Date as 01-04-2007 (dd-mm-yyyy). This generated error if you imported the Vouchers data into your Tally Company with Books beginning date as 01-04-2008 (dd-mm-yyyy). The error message is given below for your reference :- "The date 1-4-2007 is Out of Range" Remarks:- The Voucher Date in the Excel sheets is 1-4-2007 whereas the Books Beginning-Date in the Tally (Company) is specified as 1-4-2008. Now, the Voucher Date in the sample Excel Sheets has been corrected and changed to 01-04-2008 in UDIMagic v3.0 Release1.45. Alternatively, you can manually change the Date in the Excel Sheets which get created in the "C:\udiMagic" folder.

Here's a sample Excel sheet that contains StockItem Master records with multiple Price Levels. For those who are not familiar with the Price List (Multiple Price Level) feature of Tally, here's a brief introduction:- Price List in Tally 9 Tally Software allows you to maintain different Price Levels for a single Stock-Item. For example, a stock-item may be sold at different rates to :- a) Whole-sale Dealers b) Retailers c) End-users Tally Software provides "Multiple Price Levels" feature that allows you to accomplish this task. Enabling the Multiple Price Level feature To import Stock-Item Masters with multiple Price Level from the sample Excel sheet, you must first enable the Multiple Price-level feature in Tally using the underneath option :- Gateway of Tally -> F11 -> Inventory features -> Use Multiple Price Levels=Yes Follow these steps to Import the Excel sheet data into Tally Software. 1) Download and unzip the files into "c:\udi-magic" fo...

UDIMagic || Excel to Tally This post illustrates how to write XML tags that include formula's . For those who are new, here's a brief introduction to UDIMagic. "UDIMagic is a software utility that allows you to Import Excel data into Tally Software . It can process any type of data (Masters or Vouchers) irrespective of the format in which it is arranged in the Excel sheet. All you need to do is to specify what data you have in the Excel sheet and where is it stored. This is done using XML tags." In simple words, UDIMagic uses the XML tags to read the Excel sheet data and then Import it into the Tally Software. Now, let's us try to understand how to write the XML tags. For illustrative purpose, we have taken up a single tag i.e. the NARRATION tag which is used to specify the Narration in Voucher-entries. Format 1 <NARRATION> This is a Static Narration </NARRATION> Remarks:- The above XML tag instruct UDIMagic that NARRATION tag has a static / fixed v...

Multi-user version of UDIMagic is now available. For cost details, please refer http://www.rtslink.com/buy.html

Here's a sample Excel-sheet that contains StockItem Masters with Batch expiry and Multiple Locations . As we are using Multiple-Godown and Batch-wise expiry features, the StockItem Master records may span to multiple rows, as seen in the sample Excel-sheet. The NAME field (i.e. StockItem Name) is used as the Key-field. We are also using a Macro file which is required to do some calculations at run-time. Due to this, you may get an error message, if you are using Excel 2003 or higher. To solve this issue, refer FAQ: "Programmatic access to Visual basic project is not trusted" . Follow these steps to Import the Excel sheet data into Tally Software. 1) Download and unzip the files into "c:\udi-magic" folder. Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder. 2) Start the Tally software and create/open a Dummy Company. 3) Enable the following features using F11 key :- a) Maintain Multiple...

Here's a case wherein the Customer already had few thousand Stock-Item Master records in Tally 9. The requirement was to set the Default Ledger for these Stock-Items. As all the Stock-Items were of similar type (i.e. spares parts), a common ledger was to be assigned to all the Stock-Items. Example:- Stock-Item Name : Bush Ledger Name : Sales @ 12.5% VAT : Sales @ 12.5% Posting : 100% Though this could be easily done if we could directly access the Tally database, like using REPLACE or UPDATE (SQL) in other programming languages to update any database/table. Herein, we had follow these steps:- 1) Export the Stock-Item Masters from Tally 9 into Excel sheet 2) Add the Ledger Name; VAT; Posting details in Excel sheet 3) Copy/paste the Ledger-name;VAT; Posting details to all Stock-Items in the Excel-sheet. 4) Next, import the data into Tally 9 using UDIMagic utility. Download the Excel sheet and XML tags for Set-default-Ledge...

Here's a sample Excel sheet named (v-link-collection.xls) that contains Receipt Voucher entries which are to be posted into the Tally Software. Understanding the Excel sheet data The Excel sheet contains details of Cash received from various parties. Though there are several entries (parties), a single entry is to be passed as shown below:- Cash a/c Debit Party A a/c Credit Party B a/c Credit Party C a/c Credit For this purpose, we have written a MACRO (v-link-collection-macro.txt) which calculates the TOTAL AMOUNT that is to be posted to the Cash A/c in this case. Note that this is calculated at runtime using the commands specified in the macro-file. How does UDIMagic function ? When you run UDIMagic, you are prompted to select a) the Excel sheet which contains the data and b) the XML tags for it. Next, when you click the START button, UDIMagic loads the Excel file and the XML tags. If you view the XML tags file (in Internet Explorer), you will notice that we have ...

FAQs: Tally to Excel "I am using UDI-Magic 'Tally to Excel' option to retrieve Ledger Master data from Tally 9 into Excel. This generates an XML parse error. The SELECT-statement and error message are given below". SELECT statement SELECT $Name, $Parent FROM Ledger Error Message XML parse Error (Invalid unicode character) Problem cause and Solution Though the SELECT-statement show above is correct, still udi-Magic generates error message. This is because the data that is returned by Tally contains some Invalid Unicode characters (as the said error message suggests) On further analysis, we found that Tally has a Ledger named "Profit & Loss a/c" which falls under Group "# Primary". The Group name contains an invalid unicode character as the first character (although we have show # hash). On further analysis we found that the Group Name returned by Tally was "&#4; Primary". Solution As the cause of this problem is invalid unicode ...

UDIMagic v3.0 [Professional] Release 1.40 comes with a new feature called Tally-to-Tally that allows you to transform Tally data. As the name suggests, the Tally-to-Tally feature allows you to retrieve data from one Tally Company; apply transformation rules; and then send it to another Tally Company. This is particularly useful in case of concerns wherein Sales of one firm becomes Purchase of another sister concern firm. Herein, UDIMagic picks data from the Source company; transforms it and then sends it to the Destination Company, thus saving your precious time and avoiding typographical mistakes. Know more about Tally to Tally feature...

FAQs: Excel to Tally "Can I use UDIMagic to import UDF's (user-defined-fields) data from Excel into Tally ?" Yes. UDIMagic supports all Tally Masters and Voucher-types including Tally UDFs (User-defined-fields) . To be more specific, UDIMagic can process whatever data that you can manually enter in Tally Software for any Master or Voucher. Herein, we shall take up sample Excel sheets which contain Purchase and Sales Vouchers data including UDF data that is to be imported into Tally. Singapore GST A TCP file (GST72.TCP) has been provided by Tally Solutions, Bangalore that provides new reports/fields required by Tally Customers in Singapore. The sample Excel-sheets provided herewith contain a field for GST (Goods and Service Tax) that is to be imported into a UDF which is created using TDL (i.e. GST72.TCP file). GST is applicable in Signpore and is similar to VAT that is applicable in INDIA. Learn more about "Using UDIMagic to import data including UDF (Singapore GST...

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...

It has been an year since UDIMagic v1.0 was launched. UDIMagic v1.0 UDIMagic v1.0 supported transfer of Masters data from Excel to Tally. It had limited functionality for even transferring the Master's data too. i.e. the fields were limited. UDIMagic v2.0 and v3.0 Later on UDIMagic v2.0 was introduced which supported transfer of Vouchers from Excel to Tally. UDIMagic v 3.0 followed which added support for VBA (Visual basic for Applications). It also supported all Tally features like Cost Centres; Cost Categories; Multiple Currencies; Multiple Godowns etc. The UDIMagic v3.0 also supports user-defined Voucher-types, and fields created using TDL (Tally Definition language). In this fast-changing technology era, it has become crucial for us to concentrate on the latest technologies in order to make our products more robust and scalable. There have been several new releases for UDIMagic v3.0 till date, each one adding some new functionalities. In view of the above, we have decided ...

You can now buy UDIMagic from our Partners in your proximity. Click here to view the UDIMagic Partners list .

First of all, why do we require this thing ? Let me clarify it. While importing Vouchers from Excel to Tally, we require a field which contains unique values. Normally, there is such a field (Invoice Number for Sales) which contains unique values. However, Invoice numbers are unique for a given year and the number restarts from 1 every year. This would create problems as the next year vouchers will overwrite the current year vouchers. Hence, we need to generate a unique value which is a combination of the "Invoice Number" and the "Financial Year". Here's the Excel formula to get the FINANCIAL-YEAR from a given Date. FORMULA =IF(AND(MONTH($A#)>=4,MONTH($A#) YEAR($A#) & "-" & YEAR($A#)+1,YEAR($A#)-1 & "-" &YEAR($A#)) Example DATE FINANCIAL YEAR 2007-04-01 2007-08 2008-04-01 2008-09 Remarks:- 1) To test the above formula, substitute the A# with the Excel-sheet Cell-reference (say A1). 2) To use this formula i...

FAQs: Excel to Tally "I am using udi-Magic to import Vouchers from Excel into Tally 9. While importing the data, udi-Magic shows an error message "Ole Error 800A03EC". Solution:- It is likely that you are using a FORMULA in the XML tags which is incorrect . In case if you are using several FORMULA's then you must test-check each FORMULA. This can be done by tying out the Formula directly in the MS-EXCEL sheet itself. For Example, if the XML tags have a Formula as shown underneath:- FORMULA="=F# &amp; &quot;/&quot; &amp; O#" You can test-check the above formula in EXCEL as given underneath:- In the Excel sheet, enter the formula given underneath in any cell (say cell Z2). =F2 & "/" & O2 You need to test-check each FORMULA that is used in your XML tags. If you get error message while testing the Formula in EXCEL, it means that Formula is incorrect. Remarks:- In XML, there are certain characters which have special meaning a...

Topic: Import UNIT Master data from Excel into Tally Software This tutorial covers how to use UDIMagic utility to import UNIT Master records from MS-Excel into Tally Accounting Software. Visit UDIMagic tutorials page at our site.

Tally Integration made Easy New Release 1.3 udi-Magic v3.0 Release 1.3 [Professional] allows you to transfer data directly from MS SQL Server to Tally Accounting Software using few SQL-SELECT statements and XML tags. Supports all versions of Microsoft SQL Server. Click here for more details on MS SQL Server to Tally

Tally Integration made Easy New Release 1.2 udi-Magic v3.0 Release 1.2 [Professional] allows you to transfer data directly from XBase (DBF) files to Tally Accounting Software using few SQL-SELECT statements and XML tags. Supports a) DBase b) Fox 2.x c) Visual Foxpro DBFs and DBC files d) Other XBase file formats. Click here for more details on XBase (DBF) to Tally

Tally Integration made Easy udi-Magic v3.0 Professional allows you to retrieve data from External databases and send it directly to Tally Software. Useful for Software Developers udi-Magic professional is particularly useful for Software Developers / programmers who wish to INTEGRATE their software with Tally Accounting Software. Instead of modifying the existing program code, Developers can integrate with Tally by merely writing few SQL-SELECT and XML tags. Useful for End-Users Users (i.e. end-users) who wish to Integrate software with Tally but do not have the source-code of the program can do it using udi-Magic professional. Full support is provided by for writing SQL-SELECT statements and XML tags for Tally Integration. In the coming days/weeks, support for additional databases shall be included in the udiMagic professional version.

UDI-Magic in now available in two versions viz. UDI-Magic v3.0 [Standard] Supports transfer of data from Excel to Tally and vice versa. (i.e. push and pull Tally data from/to MS-Excel). UDI-Magic v3.0 [Professional] Supports transfer of data from external databases to Tally viz. MySQL to Tally MS-Access to Tally The professional version is a superset of the standard version and includes all the features of the standard version. Other new features in udiMagic version 3.0 Using separate file for XML tags Using VBA macros with udi-Magic