Wednesday, October 23, 2019

udiMagic v11 Release 1.3

The following new features have been  incorporated in udiMagic v11 Release 1.3:

Data Grouping or GroupBy

udiMagic now supports data-grouping. This feature makes it possible to automatically import summarized data into Tally ERP. Here's an example :

SOURCE : Excel Sheet extract - Sales with StockItems










As you can see, the Item 1 appears 3 times and Item 2 appears twice in the given data. Now, here's how this data will be imported into Tally when groupby is enabled.

DESTINATION : Tally screen - After importing data using udiMagic 










As you can see, the Item 1 and Item 2 quantity and value are now grouped.

i.e.
Item 1 (3 + 2 + 5 = 10 Nos)
Item 2 (4 + 6 = 10 Nos)

Remarks
1. The Data-Grouping feature is now supported by the template "Vouchers-Sales-Purchase-with-StockItems-Advanced.xls"
2. A new field / column GroupBy has been added. 
3. A sample Sales entry with GroupBy set as Yes has been included in the said Standard template.

OTHER TEMPLATE MODIFICATIONS

1. Master-StockItemMaster.xls

The following new fields have been added :
a. Cess on Quantity (Column BI)
b. State Cess on Quantity (Column BK)

2. Vouchers-V11-Sales-Purchase-with-Stockitems-Advanced.xls

The following new fields have been added :
a. Shipping Bill No (Column FQ)
b. Shipping Bill Date (Column FR)
c. Port Code (Column FS)

FIXES

1. Vouchers-V11-Sales-Purchase-with-Stockitems-Advanced.xls

An error "Cost Centre xxx does not support forex amount" appears when Sales or Purchase entry without Stockitems is imported in Tally and the entry included Cost Centres and forex currency. This issue has now been corrected.

Friday, October 18, 2019

Could not set SVCURRENTCOMPANY

The aforesaid error may appear while importing data from Excel to Tally in the following situations :

Case 1
The Company Name in Tally ERP contains special characters viz Linefeed [#13] and carriage return [#10] at the end of Company Name. To check whether the Company Name is correct or not, please follow the underneath steps :

  1. Open your Company in Tally ERP
  2. Press Ctrl+F3 to select the "Company Info" 
  3. Next, select the option "Alter"
  4. In the Company alteration screen, press END-key while in the the Company Name field. If there is space between the last character and the cursor (as shown in this snapshot), press BACKSPACE to remove the special characters at the end of Company Name and save it.


Solution
ALTER the Company and remove the special characters (blank spaces) if any from the end of the Company Name. 

Case 2
The Company Name in Tally ERP contains & (i.e. ampersand sign). Example, the Company Name is "ABC & Co"

Solution
A. Upgrade to the latest version of udiMagic; 
or 
B. Change the Company name in Tally. Example: "ABC and Co"


Saturday, October 12, 2019

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.

Thursday, October 3, 2019

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

Thursday, September 26, 2019

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(AD6:IV6)

New ARRAY Formula in Column AC (Press Ctrl + Shift + Enter for Array Formula)
=SUM(ROUND(AD6: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.

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. 

    Friday, May 24, 2019

    Entries not shown in Bank Reconciliation

    Entries missing in Tally Bank Reconciliation

    Problem description

    When we import the Bank payment or receipt entries with transaction-type as "e-Fund transfer" in Tally, these entries are not shown in the Bank Reconciliation statement.

    Solution

    In the transaction type column in the Excel sheet, specify "Same bank transfer" or "Inter bank transfer" instead of "e-Fund transfer" and then retry import the XLS into Tally.

    Thursday, May 16, 2019

    udiMagic v10 Release 1.9

    Excel Template Modifications

    Compound Unit in StockItem Master

    Template : Master-StockitemMaster.xls
    Description : This template now includes new fields/columns for specifying "Compound Unit" details viz "First Unit, Conversion Factor, Second Unit"

    Multi-line Address in Employee Master

    Template : Master-Employee.xls
    Description : This template now includes additional columns to specify the Employee Address.

    Template fixes

    Template : Vouchers-V10-Journal-with-multiple-references.xls
    Description : The "IsCostCentreOn" feature is NOT enabled automatically for the newly created ledgers. This bug has been now rectified.


    Tuesday, May 14, 2019

    Customer dashboard

    The Customer dashboard now includes a new option :

    Renewal
    udiMagic users can now Renew their Subscription based licenses using this option and avail additional benefits.

    Renewal of subscription has to be done on or before the expiry of the existing subscription period.

    Users can login into the Customer dashboard using the underneath link :
    https://www.rtslink.com/customer/

    Friday, April 26, 2019

    3 ways to Import data in Tally

    Different methods to import Excel data in Tally

    There are several ways to import excel data in Tally using udiMagic software. Watch the videos (links given at bottom) to know more.

    1. Copy/paste data in Standard template

    You can put your data in the Standard templates using copy/paste or can manually enter it. However, this may be tedious if the data is voluminous.

    STEPS

    • Copy/paste from your Excel file into the Standard template
    • Import data from Standard template into Tally ERP

    2. Mapping (in Standard Excel template)

    In this case, you once map the columns in the Standard EXCEL template. Next, the data is copied from your Excel sheet to the Standard template with a single click. You can then import data from the Standard template into Tally using udiMagic. 

    STEPS

    • Map the columns in Standard template
    • Transfer data from your Excel file into Standard template with a single click
    • Import data from Standard Excel template into Tally ERP


    3. Mapping (in udiMagic Software)

    In this case, you once map the columns in the udiMagic Sofware itself. You can then import data directly from your Excel sheet into Tally using udiMagic.

    STEPS

    • Map columns in udiMagic software
    • Import data directly from your Excel file into Tally ERP



    Friday, April 12, 2019

    Excel opening blank when you double-click a file icon or file name

    Symptoms

    When you double-click an icon or file name for a Microsoft Excel workbook, Excel starts but displays a blank screen where you expect the file to appear.

    Resolution

    Please refer this link to resolve the issue:
    https://support.microsoft.com/en-in/help/2994633/excel-how-to-troubleshoot-excel-opening-blank-when-you-double-click-a

    Alternatively,  restart your system and then try opening the Excel file.

    Notes:
    The above occasionally happens when you import data from Excel to Tally ERP.

    Saturday, April 6, 2019

    udiMagic v10 Release 1.8

    Excel Template Modifications

    1. Mapping feature

    The following templates support the NEW MAPPING feature:

    Vouchers-V10-Journal-with-multiple-references.xls
    Vouchers-V10-Payroll-Attendance.xls
    Vouchers-V10-Physical-Stock-Journal.xls
    Vouchers-V10-Receipts-and-Payments-with-multiple-references.xls
    Vouchers-V10-Stock-Journal.xls


    See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc
    See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI

    Thursday, April 4, 2019

    ST Category does not exist

    Fix : How to fix the error ST Category 'Not applicable' does not exists in Tally ERP 9

    Applicable to :  Branch to HO utility (Old users only)


    Steps to resolve the issue
    1. In Gateway of Tally, press F11 and select the option "Statutory & Taxation".
    2. Enable the option "Enable Service Tax" and set the option "Define service category and tax details as masters" to Yes.
    3. Press Ctrl+A to save the configuration.
    4. Next, from Gateway of Tally, select option "Accounts Info >> Statutory Info >> Service Categories".
    5. Next, select the option "Create" and specify the Name as "Not applicable" and press Ctrl+A to save the Service Tax Category.
    6. Next, disable the "Enable Service Tax" option in "Gateway of  Tally >> F11 >> Statutory & Taxation".



    Tuesday, March 26, 2019

    udiMagic v10 Release 1.7

    Excel Template Modifications


    1. Mapping feature


    The following templates support the NEW MAPPING feature:

    Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls
    Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls
    Vouchers-V10-Horizontal-Financial-Transactions.xls
    Vouchers-V10-Horizontal-Purchase-Without-Stockitems.xls
    Vouchers-V10-Horizontal-Sales-Without-Stockitems.xls

    See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc
    See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI

    2. New Fields - BANK NAME, BRANCH NAME, IFSC CODE

    The following templates now include new fields / columns for specifying "Bank details"  viz Bank Name, Branch Name, IFSC Code :

    Vouchers-V10-Financial-Transactions-Single-line-entry-Basic.xls
    Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls

    Monday, March 18, 2019

    udiMagic v10 Release 1.6

    Excel Template Modifications

    1. Mapping feature

    The following templates support the NEW MAPPING feature:

    Master-LedgerMaster.xls
    Master-StockItemMaster.xls
    Vouchers-V10-Financial-Transactions-Basic.xls
    Vouchers-V10-Financial-Transactions-Advanced.xls
    Vouchers-V10-Sales-Purchase-Without-Stockitems-Basic.xls
    Vouchers-V10-Sales-Purchase-Without-Stockitems-Advanced.xls

    See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc
    See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI

    2. Vouchers-V10-Financial-Transactions-Single-line-entry-Advanced.xls

    The following new fields / columns have been added:
    a. PARENT DR LEDGER  (Specify the Parent Group Name for Debit Ledger)
    b. PARENT CR LEDGER  (Specify the Parent Group Name for Credit Ledger)

    Friday, March 8, 2019

    New Mapping Feature - udiMagic v10 Release 1.5

    Map Your Excel data and Import in Tally ERP

    The following templates support the NEW MAPPING feature:
    1. Vouchers-V10-Bank-statement.xls
    2. Vouchers-V10-Bank-statement-Single-Column-Dr-Cr.xls
    3. Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls
    4. Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

    Mapping Feature - How it works?

    Learn how to use the mapping feature to import your excel data into Tally ERP 9. Here, mapping refers to a process wherein you have to associate each column in the Standard Excel file with the relevant column in your Excel file.

    See Video in English : https://www.youtube.com/watch?v=4bmfRXlQXKc
    See Video in Hindi : https://www.youtube.com/watch?v=X-J9X4iSIpI

    Thursday, February 21, 2019

    udiMagic v10 Release 1.4

    Excel Template Modifications

    1. Vouchers-V10-Bank-statement.xls
    A NEW column for "VoucherNumber" has been included.

    2. Vouchers-V10-Bank-statement-Single-Column-Dr-Cr.xls
    A NEW column for "VoucherNumber" has been included.

    3. Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls
    A NEW column for "SKIPVoucher" has been included. If this contains "Yes", then the Voucher is skipped and is NOT imported into Tally ERP. The default value for this column is "No"

    Wednesday, February 20, 2019

    udiMagic Single Template Edition

    Excel to Tally - udiMagic Single Excel Template 

    We are pleased to inform you about launch of udiMagic Single Template Edition.

    udiMagic Single template Edition

    • You can now BUY a Single template as per your requirement.
    • Available on 1 month and 1 year subscription basis.
    • For price details, please visit https://www.rtslink.com/buy/

    Tuesday, February 5, 2019

    udiMagic v10 Release 1.3

    Fixes in Release 1.3

    Supplier and Consignee Address

    While importing the Purchase Vouchers from Excel to Tally ERP 9, the Supplier Name does NOT appear correctly in Tally. This  has now been rectified and the following Excel templates have been updated :

    Vouchers-V10-Sales-Purchase-with-Stockitems-Advanced.xls
    Vouchers-V10-Sales-Purchase-without-Stockitems-Advanced.xls
    Vouchers-V10-Sales-Purchase-without-Stockitems-Basic.xls

    Place of Supply

    The StateName appears more than once in GSTR1 B2C report as the data specified contains GUJARAT and Gujarat. This has now been rectified and the Place of Supply is now converted to Proper case before importing it in Tally.


    Thursday, January 17, 2019

    Fix: Excel Fill Handle is missing

    How to enable Fill handle in Excel?

    The Fill Handle feature in Excel allows you to select a series of cells with incremental values and drag the cell corner to complete the series. However, if this does not work then check out the following :
    1. Click "File"
    2. Click "Options"
    3. Click "Advanced"
    4. Next, tick the option "Enable fill handle and cell drag-and-drop"
    5. Next, save the settings and then retry to fill the series by dragging the cell corner.

    Friday, January 11, 2019

    Multi-Currency Excel templates

    Import FOREX entries in Tally

    Using the Excel templates provided with udiMagic v10 Release 1.2, you can now upload Sales and  Purchase entries with Inventory and Multi-Currency into Tally ERP 9.

    In these latest Excel templates, two additional columns have been provided for CURRENCY and ROE (Rate of Exchange). If you specify the Currency and ROE, the entries are automatically reflected in FOREX currency in Tally ERP 9. If you keep these columns blank, then the entries are uploaded in Tally in base currency.

    The multi-currency feature is now supported in the following Excel templates :

    Sales, Purchase, Debit Note, Credit Note entries with Multi-currency

    Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls
    Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

    For Receipt, Payment, Journal, Contra entries with Multi-currency

    Vouchers-V10-Financial-Transactions-Basic.xls
    Vouchers-V10-Financial-Transactions-Advanced.xls