udiMagic v11 Release 1.5

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

TEMPLATE MODIFICATIONs

1. Master-StockItemMaster.xls
The following new fields have been added :
a. Quantity From (for Price Level)
b. Quantity Less than (for Price Level)

FIXES
In udiMagic Settings, if the default decimal places is changed and error appears "Access violation at address xxx". This issue has now been resolved.

REMOTE SUPPORT
Teamviewer QuickSupport version 13 is now included with udiMagic Software

• When you run Teamviewer QuickSupport, it automatically generates a Service Case ID (like a ticket) and notifies the Shweta Softwares Support Team. 
• You can additionally specify the "Description" about your query so that the support team knows about your query and can assist accordingly at the earliest.
• Remote assistance is available during office hours on working days. 
• The response time may vary depending upon the queries in the queue.
• You may additionally create a ticket using the Support Desk ticket system.

udiMagic v11 Release 1.4

The following new feature have been  incorporated in udiMagic v11 Release 1.4:

Data Validation Alerts

udiMagic now supports data-validation alerts. The data validation feature checks and validates the excel data prior to importing it into Tally ERP software and displays warnings if incorrect data is found in the Excel file.

How it works?
Excel data is validated against a pre-defined set of rules which are specified in the XML tags. An alert is displayed on screen or logged into file, if any of the the rules are voilated.

Presently, alerts have been included in the following templates :
1. Vouchers-V11-Sales-Purchase-With-Stockitems-Basic.xls
2. Vouchers-V11-Sales-Purchase-With-Stockitems-Advanced.xls

The following checks have been currently kept :

1.  VoucherType Name [Column B]
Must contain a valid [predefined] Tally voucher-type. An alert message will be displayed if the Excel sheet contains incorrect voucher-type.

2. State Name  [Column  K]
Must contain a valid State-name as per Tally's State-Name list. An alert message will be displayed if the Excel contains invalid state-name.

3. Unit of Measurement
An alert message is displayed if this is empty. The default value "Nos"  is  used in such cases.

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.

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"

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(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.