udiMagic v9.0 Release 1.9

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 1.9

NEW TEMPLATEs

1. Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls

You can use this template to import Sales, Purchase, Debit Notes, Credit Notes (all without StockItems).

The new feature in this template are as follows :
a. Invoice Mode : You can specify whether to import voucher as "Accounting Voucher" or "Invoice Voucher"
b. You can now map this Standard template to your Excel sheet.

This template replaces the old template named "Vouchers-V9-Sales-Horizontal-format-without-stockitems.xls" and "Vouchers-V9-Purchase-Horizontal-format-without-stockitems.xls" which did not support mapping.

2. Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls
This is the advanced version of the previous template. It additionally supports Cost Category, Cost Centre also.

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Purchase.xls
New Column added : A new column has been added to specify "Invoice Mode". i.e whether to import voucher in "Accounting Voucher" or "Invoice Voucher"

Fixes: While importing Sales/Purchase without Stockitems, the Cost Centre details were not imported / reflected in Tally. This has now been rectified.

2. Vouchers-V9-Sales-Purchase-Basic.xls

New Columns added

a. Party Ledger Alias :  You can now specify the Party Code / Alias in this column.

b. Invoice Mode :  You can specify whether to import voucher as "Accounting Voucher" or "Invoice Voucher"

3. Vouchers-V9-Sales-Horizontal-format-without-Stockitems.xls

New Columns added

a. Nature of Return

b. Debit/Credit Note No

c. Date

d. URD-Original Sale Value

PS:

This template has now been moved to the folder c:\udiMagic\templates-discontinued". Kindly use the new template "Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls" or "Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls".

4. Vouchers-V9-Purchase-Horizontal-format-without-Stockitems.xls

New Columns added

a. Nature of Return

b. Debit/Credit Note No

c. Date

d. URD-Original Sale Value

PS:

This template has now been moved to the folder c:\udiMagic\templates-discontinued". Kindly use the new template "Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls" or "Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls".

5. Vouchers-V9-Financial-Transactions-Single-line-entry-Advanced.xls

Fixes : While mapping, error "Nesting of Formula too deep" appears. Now rectified.

6. Vouchers-V9-Financial-Transactions-Single-line-entry-Basic.xls

Fixes : While mapping, error "Nesting of Formula too deep" appears. Now rectified.

7. Master-LedgerMaster.xls

New Columns added

a. Mailing Name

b. Assessee of Other Territory

c. Consider Party as Deemed Exporter for Purchases

d. Is a transporter

8. Master-StockItemMaster.xls

Fixes : Incorrect formula / typo for GSTDETAILS. Rectified in v9.0 r1.8

udiMagic v9.0 Release 1.7

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 1.7

Mapping Formula Length
The MAXIMUM LENGTH of Formula supported by udiMagic Mapping feature has been now increased from 255 characters to 8192 characters.

PS:
The earlier versions of udiMagic had a limit of 255 characters for Formula Length for the Mapping feature.

NEW TEMPLATEs
1. Master-Employee.xls
This excel template allows you to import Employee Master details from Excel to Tally.

TEMPLATEs  (Modifications)

1. Master-StockGroupMaster.xls
New column to specify the "GST Classification"

TEMPLATES (Fixes)

Vouchers-V9-Sales-Purchase-Basic.xls
Fixes : Provision for grouping on Sales/Purchase ledger for transactions without inventory is now done.

Vouchers-V9-Sales-Purchase.xls
Fixes : Provision for grouping on Sales/Purchase ledger for transactions without inventory is now done.

Vouchers-V9-Financial-Transactions-Basic.xls
Fixes : InstrumentDate and InstrumentNumber values do NOT appear correctly - Now rectified.

Master-StockItemMaster.xls
Fixes : GST details SKIP condition now includes GST Classification check.

udiMagic v6.0 support to be discontinued from 1st April 2018

udiMagic v6.0 (or lower versions) customers / users are requested to note that the support for udiMagic v6.0 shall be discontinued from 1st April 2018 and there shall be no product enhancements in udiMagic v6.0 thereafter.

Also, to avail technical support and product enhancements, users will have to upgrade to the latest version.

If XML tags are required for any new formats, then XML tags compatible with the latest version shall only be provided.

udiMagic v9.0 Release 1.6

Excel to Tally templates
Applicable to : udiMagic v9.0 Release 1.6

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Purchase-Basic.xls
• If the Sales / Purchase ledger column is kept blank, the default ledger names are taken. Now, the default ledger names have the Tax percentage as suffix.
• A new column has been added to specify the "Stockitem Part Number".
• A new column has been added to "Disable GST effect" while importing data into Tally. You must set it to Yes, if you want to upload entries with VAT.
• Fixes : The tag URDORIGINALSALEVALUE is now set as "Lesser than or equal to 2.5 lakhs" if the voucher type is Credit Note or Debit Note [Otherwise GSTR-1 displays message "Original Sales details not specified"]
2. Vouchers-V9-Sales-Purchase.xls
• If the Sales / Purchase ledger column is kept blank, the default ledger names are taken. Now, the default ledger names have the Tax percentage as suffix.
• A new column has been added to "Disable GST effect" while importing data into Tally. You must set it to Yes, if you want to upload entries with VAT.
3. Voucher-V9-Payroll-Attendance.xls
• New Columns have been added to specify the Gender, BloodGroup, IncomeTaxNo, AadharNo, PF No, UAN, PRAN, ESI No etc
4. Vouchers-V9-Financial-Transactions-Single-line-entry-Basic.xls
• New columns have been added to specify the "ReferenceNo" and "ReferenceDate"
5. Vouchers-V9-Financial-Transactions-Single-line-entry-Advanced.xls
• New columns have been added to specify the "ReferenceNo" and "ReferenceDate"
• New columns have been added for "Bank Instrument details"

TEMPLATEs (Renamed)New template : Voucher-V9-Payroll-Attendance.xls
Old template : Voucher-V8-Payroll-Attendance.xls

New template : Vouchers-V9-Financial-Transactions-Single-line-entry-Basic.xls
Old template : Vouchers-V6-Financial-transactions-single-line-entry.xls

New template : Vouchers-V9-Financial-Transactions-Single-line-entry-Advanced.xls
Old template : Vouchers-V6-Financial-transactions-single-line-entry-with-cost-centres.xls

udiMagic v9.0 Release 1.5

Excel to Tally templates
Applicable to : udiMagic v9.0 Release 1.5

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Purchase.xls
New Columns have been added to specify the Ledger-wise description. The Ledger-wise description works only in case of Sales / Purchase Vouchers without StockItems.

2. Vouchers-V9-Financial-transactions-Basic.xls
New Column added to specify Narration (for each Ledger).

3. Vouchers-V9-Financial-transactions-Advanced.xls
New Column added to specify Narration (for each Ledger).

TEMPLATEs (Renamed)
New template : Vouchers-V9-Sales-Purchase.xls

Old template : Vouchers-V8-Sales-Purchase.xls

New template : Vouchers-V9-Sales-Purchase-Basic.xls

Old template : Vouchers-V8-Sales-Purchase-Basic.xls

udiMagic v9.0 Release 1.4

Excel to Tally templates
Applicable to : udiMagic v9.0 Release 1.4

NEW TEMPLATEs

Master-Budgets.xls
This template allows import of Budgets from Excel to Tally.

TEMPLATEs  (Modifications)

Vouchers-V8-Sales-Purchase.xls
Minor fixes : Credit Days not imported when BYB Ref No is empty - now rectified.

Others
A new version named udiMagic Custom Edition has been introduced. The Custom Edition will include templates for specific domains.

Currently, we have included templates for Cadbury distributors

For more details on udiMagic Custom Edition, please refer :
https://www.rtslink.com/products/

Your feedback

Customer feedback is valuable. Many features introduced in udiMagic Software are based on the suggestions and feedback of our users.

We request udiMagic users to RATE the udiMagic Software using the underneath link.

Log-in into the Customer dashboard using your udiMagic Serial / Key :
https://www.rtslink.com/customer/

RATINGS are displayed at https://www.rtslink.com/downloads/