udiMagic v9.0 Release 2.1

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

TEMPLATEs (Modifications)

1. Vouchers-V9-Sales-Purchase.xls

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

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

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

3. Vouchers-Stock-Journal.xls

This format now supports Material IN and Material OUT vouchers also. A new column to specify the Party Ledger Name has been added in this template.

udiMagic Limited Edition

The following features are now supported in udiMagic Limited Edition also :

1. Debugging
2. Undo Entries

udiMagic v9.0 Release 2.0

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

TEMPLATEs (Modifications)

1. Vouchers-V9-Sales-Purchase.xls

a. New Columns added under "Despatch details"

- Bill of Lading/LR No

- Date

- Motor Vehicle No

b. New Columns added under "Other ledgers before Tax"

- Cost Category (for all ledgers)

- Cost Centre (for all ledgers)

c. New Columns added under "Other ledgers after Tax"

- Cost Category (for all ledgers)

- Cost Centre (for all ledgers)

d. New Column added under "Tax Classification details"

- Override Voucher

PS: This must be used only if you want to override the Tax Classification details at the Voucher level.

e. Additional Cess (i.e Cess based on Quantity)

Under the GST regime, some products attract "Additional Cess" based on quantity (in addition to Cess based on value). This is now supported by udiMagic Standard template. Kindly note that the "Additional Cess" has to be specified as RATE/per unit.

f. Point of Sale (POS) feature

The POS feature is now supported which allows you to specify the following details :

- Gift Voucher details

- Credit/Debit Card details

- Bank Ledger details

- Cash Ledger details

g. Fixes

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Voucher Mode + Round Amount is Negative

b. Sales without Items + Voucher Mode + Round Amount is Negative

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

Fixes: 

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Voucher Mode + Round Amount is Negative

b. Sales without Items + Voucher Mode + Round Amount is Negative

3. Vouchers-V9-Financial-Transactions-Advanced.xls

In this template, you can now specify "Multiple Cheques/Instruments" against a single Bank ledger.

4. Master-StockItemMaster.xls

a. New Column added

- Enable Cost tracking

- Rate per Unit (under Price levels)

b. Bill of Materials (BOM)

The BOM feature is now supported.

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