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"