udiMagic Release Notes

TEMPLATE Modifications  1. Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls NEW COLUMNs Column I  - PARENT DR. LEDGER (Specify the Parent Group name for Debit Ledger) Column K - PARENT CR. LEDGER (Specify the Parent Group name for Credit Ledger) Remarks a. These newly added columns are optional. b. However, for Bank entries you must specify the Parent Group Name as "Bank Accounts" for the Bank entries to be reflected in Bank Reconciliation Statement. 2. Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls Remarks For Bank entries you must specify the Parent Group Name as "Bank Accounts" for the bank entries to get reflected in Bank Reconciliation Statement. 3.  Vouchers-V10-Horizontal-Sales-Without-Stockitems.xls Old Formula in Column AC =SUM(AF6:IV6) New ARRAY Formula in Column AC (Press Ctrl + Shift + Enter for Array Formula) =SUM(ROUND(AF6:IV6,2)) In the Column AC, we have now used Array Formula instead of s...

The template "Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls" now includes additional columns for Cost Category and Cost Centre for the Party ledger. TEMPLATE : Vouchers-V10-Sales-Purchase-with-StockItems-Advanced.xls NEW COLUMNS 1. Cost Category (Columns L) 2. Cost Centre (Columns M) The following fixes / corrections have been done in udiMagic v10 Release 2.2 XML Parse error The aforesaid error is displayed while importing the template Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls when the  CompanyName in Tally contains Ampersand Sign (&) . This problem has now been resolved. PS: Those using the older versions of udiMagic can set / enable the option "Disable Fetch Objects" in udiMagic settings to resolve the issue. Invalid USB drive details When activating with USB flash drive, invalid details are shown in certain cases. This problem has now been resolved. New setting option in udiMagic Settings screen A new option ...

SQL Statement with named parameters You can use named parameters :FromDate and :ToDate in your SQL Query to provide input for the fields "From Date" and "To Date" in udiMagic for uploading data from SQL Server to Tally ERP. How to use parameters in SQL query? Here's a sample SQL SELECT query that shows how to use the :FromDate and :ToDate named parameters SELECT field1, field2, fldDate FROM table WHERE table.fldDate>=:FromDate AND table.fldDate<=:ToDate Instead of hard-coding the period (from and to dates) in SQL-query, we have used 2 named parameters viz :FromDate and :ToDate. The values for these parameters are assigned at runtime based on the period you enter in the udiMagic screen. Remarks 1. In udiMagic screen, you must specify the FromDate and ToDate in dd/mm/yyyy format only. 2. The date format of SQL server  or your system may be different (ex: yyyy-mm-dd). However, udiMagic automatically sets the date format internally and hence the...