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