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.