Saturday, September 14, 2019

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. 

Friday, September 13, 2019

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.

Thursday, August 22, 2019

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.

Wednesday, August 7, 2019

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.


Wednesday, July 31, 2019

License Activation Error : HTTP 406 Not Acceptable

How to resolve the error HTTP 406 Not Acceptable?

While activating the udiMagic license, if you get the error HTTP 406 Not Acceptable,  please follow the instructions given underneath.


For udiMagic v7.0 and higher versions


1. Download and install the latest release of udiMagic for which you are eligible.
2. Next, activate the udiMagic license using the "Licensing" button in the 2nd screen.

Remarks
To get the download link, visit https://www.rtslink.com/customer/forgot/ and enter your udiMagic Serial Number. The download link will be sent to your email id registered with us.

    For udiMagic v6.0 and lower versions 

    Please write to us by email to resolve the HTTP 406 Not Acceptable error.

    Thursday, July 4, 2019

    Working with Multi-Currency in Tally

    Importing FOREX entries in Tally

    Some excel templates provided with udiMagic software contain a column to specify the CURRENCY. Here's how you can use these templates for importing FOREX as well as BASE currency transactions in Tally ERP.

    1. Keep the CURRENCY column blank, if you want to upload a voucher in base currency.
    2. For FOREX entries, specify the CURRENCY name or symbol in the currency column. Please note that the there must be NO space in the Currency symbol.

    Valid Currency Symbol : USD
    Invalid Currency Symbol : US Dollar

    Important Note
    1. The symbol "US Dollar" has a space and hence is invalid.
    2. It is advised that you manually create the Currencies in Tally ERP before importing the FOREX entries.
    3. The Currency Symbol must be ASCII character(s). Example: Don't use the Indian Rupee symbol which is a Unicode symbol; instead use "INR" or "Rs" as the Currency Symbol.
    4. Tally ERP does NOT allow spaces in the Currency Symbol.

    Friday, May 31, 2019

    Convert from Perpetual to Subscription license

    How to convert udiMagic Perpetual license to Subscription license?

    To convert your udiMagic Perpetual license to Subscription license, follow the underneath steps :

    1. Log in into the Customer dashboard [https://www.rtslink.com/customer/] using your Serial and Key.
    2. Next, select the tab "License Mgmt"
    3. Next, click the "Buy Now" button under the Panel "Conversion from Perpetual to Subscription License"
    4. Upon successful payment, your Perpetual license is converted to Subscription license.

    NOTE
    Subscription licenses are less expensive than Perpetual licenses and are cost-effective option.