udiMagic Release Notes

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