Thursday, January 17, 2019

Fix: Excel Fill Handle is missing

How to enable Fill handle in Excel?

The Fill Handle feature in Excel allows you to select a series of cells with incremental values and drag the cell corner to complete the series. However, if this does not work then check out the following :
  1. Click "File"
  2. Click "Options"
  3. Click "Advanced"
  4. Next, tick the option "Enable fill handle and cell drag-and-drop"
  5. Next, save the settings and then retry to fill the series by dragging the cell corner.

Friday, January 11, 2019

Multi-Currency Excel templates

Import FOREX entries in Tally

Using the Excel templates provided with udiMagic v10 Release 1.2, you can now upload Sales and  Purchase entries with Inventory and Multi-Currency into Tally ERP 9.

In these latest Excel templates, two additional columns have been provided for CURRENCY and ROE (Rate of Exchange). If you specify the Currency and ROE, the entries are automatically reflected in FOREX currency in Tally ERP 9. If you keep these columns blank, then the entries are uploaded in Tally in base currency.

The multi-currency feature is now supported in the following Excel templates :

Sales, Purchase, Debit Note, Credit Note entries with Multi-currency

Vouchers-V10-Sales-Purchase-With-Stockitems-Basic.xls
Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls

For Receipt, Payment, Journal, Contra entries with Multi-currency

Vouchers-V10-Financial-Transactions-Basic.xls
Vouchers-V10-Financial-Transactions-Advanced.xls

Wednesday, December 26, 2018

Need Simple Template To Import in Tally

Simple Excel Template

Often people ask: "I need a simple excel template to import sales data in Tally. Which one should I use?"

udiMagic comes with several predefined Standard Excel templates. For Sales and Purchase excel formats, two different versions are provided viz BASIC and ADVANCED (with advanced features). To begin with, start with the BASIC template. If you requirements are NOT fulfilled with the BASIC template, then go for the ADVANCED template. 

CHOOSE What You Want

Alternatively, you can Create A New Template by selecting the fields / columns that you want from an existing template. This can be done using the udiMagic Online Template Builder here:  https://www.rtslink.com/excel-to-tally-templates/

Read more on udiMagic at: https://www.rtslink.com  

If you face any problems, post your comments in the comments box below.

Saturday, December 15, 2018

udiMagic v10 Release 1.1

Decimal Places in Tally ERP

Change Decimal Places In Amount - udiMagic Settings

By default, the udiMagic Software supports two "Decimals Places in Amount". In simple words, when we import data from Excel to Tally ERP, the amount is rounded off to 2 decimals. However, in some countries (like Oman), the transactions are generally recorded with 3 decimals in amount.

In this latest release, a new option has been included in the udiMagic Settings which allows you to set / change the "Decimal Places in Amount" as shown below:



In addition, ensure that you specify the correct decimal places  in the Excel sheet wherever the ROUND() function is used.

NOTE:
In certain excel templates provided with udiMagic Software, the ROUND() function is used. You must change the ROUND() to specify the decimal places as per your requirement.

Tuesday, December 4, 2018

Multi-Currency in Tally ERP

Multi-currency Import Excel to Tally

Recording multi-currency vouchers in Tally ERP can be a difficult task, unless you are an experienced Tally user.


udiMagic v10

The excel templates provided with udiMagic software, help you import vouchers with multi-currency in Tally ERP, quickly and easily. You need to specify the Currency, Forex Amount, Rate of Exchange for recording payment, receipt and other entries. You can also import Base-currency vouchers by keeping these columns blank viz. Currency, Forex Amount, ROE.



Supports all financial vouchers like Payment, Receipt, Journal, Contra, Sales and Purchase without inventory.

Forex and Base Currency

  • To import vouchers with Forex, specify the "Currency, Forex Amount, ROE".
  • To import vouchers in Base currency, keep the "Currency, Forex Amount and ROE" columns blank.

Wednesday, November 14, 2018

Cess based on Quantity, GST entries in Tally ERP

Cess based on Quantity - Tally ERP

Under the GST regime, some products attract "Additional Cess" based on quantity (in addition to Cess based on value). This feature "Cess based on qty" is now supported by udiMagic Software. 

Excel Template Name : Vouchers-V10-Sales-Purchase-With-Stockitems-Advanced.xls
Location : C:\udiMagicDemo

Kindly note that the "Cess based on Quantity" has to be specified in the column RATE/per unit in the aforesaid excel template. 



udiMagic Demo download link:

Friday, November 2, 2018

INTRODUCING UDIMAGIC V10.0

We are pleased to announce the launch of udiMagic v10 

The details are as under :-

Backward compatibility for Old Templates
With udiMagic v10 onwards, the old-templates (i.e. excel templates  of v9.0 r2.3 or higher) are  included in a folder named "old-templates" within the folder where the udiMagic software is installed. 

Here's what is means. 

In udiMagic v10, if you use an old template (i.e. v9. r2.3 or higher), the XML file for that template will be selected automatically by the udiMagic software. Prior to this, if you used a template of  older version, you had to manually select the XML file for that template to upload data into Tally.

Bulk record processing for UNDO entries
UNDO entries is a feature which allows the user to remove / delete the entries which were previously imported into Tally using udiMagic. By default, when you use the option UNDO entries, the records are processed one-by-one and are removed / deleted from Tally. 

A new option "Bulk upload / record processing for UNDO entries" has been now included in udiMagic Settings. When this option is ticked / enabled, the records are processed in Bulk. By default, this option is disabled.

Templates Modifications

1. Vouchers-V10-Receipts-and-Payments-with-multiple-references.xls
The DATE (Column B) has been shifted after the VCHNO column.