udiMagic v11 Release 1.2

The following changes have been done :

udiMagic v11 Release 1.2

1. In the udiMagic screen "Create a Custom Custom", the grid HEIGHT for Standard Excel and User Excel template has now been increased for better user experience.

2. The Tally to Tally feature (separately available) is now compatible with the latest Tally ERP.

udiMagic v11 Release 1.1

1. In some of the Standard templates, the "DataFromRow" and "MappingRow" was incorrectly specified. This has now been corrected / fixed. Those using udiMagic v11 Release 1.0 are advised to upgrade to the latest udiMagic release.

INTRODUCING UDIMAGIC V11.0

We are pleased to announce the launch of udiMagic v11.

The details are as follows :

TEMPLATE MODIFICATIONs

The following templates now support multi-currency feature :

1. Vouchers-V11-Bank-statement.xls
2. Vouchers-V11-Bank-statement-Single-Column-Dr-Cr.xls
3. Vouchers-V11-Financial-Transactions-Single-line-entry-Basic.xls
4. Vouchers-V11-Financial-Transactions-Single-line-entry-Advanced.xls

udiMagic v10 Release 2.3

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 simple Sum() function. This is because we need to Round off the values to 2 decimals before adding them using the Sum() function.

What are Array Formulas?
Array formulas are powerful formulas that enable you to perform complex calculations that often can’t be done with standard worksheet functions. They are also referred to as "Ctrl-Shift-Enter" formulas, because you need to press Ctrl+Shift+Enter to enter them.

4. Vouchers-V10-Horizontal-Purchase-Without-Stockitems.xls

Array Formula used in Column AC as mentioned in the previous point

OTHER CHANGES
The following fixes / corrections have been done in udiMagic v10 Release 2.3

Invalid key
The aforesaid error appears when we copy/paste the udiMagic Serial Number while activating the license. This problem has been now resolved. In the older versions, users can use "Right-click and then Paste" functionality to paste the Serial Number. 

XML Parse error
The aforesaid error is displayed when udiMagic Software is started and then the software hangs. This problem has been now resolved.

udiMagic v10 Release 2.2

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 "Remove Invalid XML Chars automatically" is now included in the udiMagic Settings. When enabled, invalid XML chars are automatically removed from text data. This option is enabled, by default.

PS:
Option "Use Advanced sockets" has now been removed from the udiMagic settings. This option was kept for backward compatibility purpose only and hence has been now removed. 

SQL Server : Using named parameters in SQL Query

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 there is no need to change your SQL Server / System date format.

udiMagic v10 Release 2.1

The following fixes / corrections have been done in udiMagic v10 Release 2.1

Error: Could not set SVCURRENTCOMPANY to (name)
An error "Could not set SVCurrentCompany to (name)" is displayed when the CompanyName in Tally contains Ampersand Sign (&) and data is not imported into Tally. This problem has now been resolved.

Slow speed issue when ReferenceStyle is set to xlR1C1
The ReferenceStyle is now automatically set to xlA1, if it is xlR1C1. Alternatively, it can be changed using the MS-Excel option "File | Options | Formulas | R1C1 reference style"

New setting option in udiMagic Settings screen
A new option "Disable SSL" is now included in the udiMagic Settings. This is kept for backward compatibility and is to be used / ticked if "Socket Error 10060" occurs while activating the udiMagic license.

udiMagic v10 Release 2.0

Kerala Flood Cess

Kerala state has introduced a new cess named "Kerala Flood Cess" on goods and services w.e.f 01/08/2019. This is a State Cess and is levied on intra-state supplies made by taxable persons (Regular Dealers) to consumers and unregistered dealers.

The template "Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls" now includes additional columns which support the new Kerala Flood Cess / State Cess.

TEMPLATE : Vouchers-V10-Sales-Purchase-with-StockItems-Advanced.xls
NEW COLUMNS
1. State Cess Rate (Columns CW, CX)
2. Addl State Cess Rate(Columns CY, CZ)
3. State Cess ledger (Column DG)
4. Addl State Cess Ledger (Column DH)
5. Tax Classification at Voucher level (Column EM)

A sample entry has also been provided in the aforesaid template.

Important Notes
The aforesaid feature viz. Kerala Flood Cess works only for:
a) Kerala State
b) Sale to Unregistered dealer or consumer
c) Sale date is 01/08/2019 or higher

All registered dealers who levy this cess have to file a separate KFC-A form online,

TODO
Users must manually set/modify the Kerala Cess Rate in StockItem master and set the effective date to 01/08/2019

Changes in other templates

Master-LedgerMaster.xls
New column for Kerala Cess/State Cess  been added.

Master-StockItemMaster.xls
New column for Kerala Cess/State Cess  been added.

Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls
New column ChequeRange been added

Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls
New column ChequeRange has been added

Fixes in Master-StockItemMaster.xls

1. The section "Advanced Settings to Append data date-wise" for StandardPrice / StandardCost  / MRP / PriceLevel does not work. This has been now rectified.

2. Stock-item Rate is not imported correctly when the Unit of measurement (UOM) is specified in Column "PerUnit". This has now been rectified.

3. The batch-wise Opening Qty is imported incorrectly (for the 1st batch) when the stockitem has two or more batches. This has now been rectified.