Excel 2007 - Error 800A9C68

If you are using Excel 2007 or higher version and get the said error while importing data into Tally using UDIMagic, then it is likely due to Macros.

Solution:-
In Excel 2007, the default setting for Recalculation of formulas is AUTOMATIC. We need to change it to MANUAL initially before making changes in the Excel sheet at run-time and the reset it to the Automatic at the end.

The following code is used to set the calculation to Manual :-
'Stop Recalculation
Dim xlCalc As XlCalculation
xlCalc = Application.Calculation
Application.Calculation = xlCalculationManual
On Error GoTo CalcBack

The following code is used to reset the calculation setting to Automatic :-
'Recalculate
Application.Calculation = xlCalculationAutomatic
Exit Sub

CalcBack:
Application.Calculation = xlCalculationAutomatic

Excel to Tally - Sample Excel sheet formats

The following sample Excel sheets formats are now available for UDIMagic users :-

1) Sales Vouchers with StockItems and Multiple Sales Ledgers
2) Sales Vouchers without StockItems, with multilple VAT rates
3) Point of Sale vouchers with Sales Return, Cancelled vouchers
4) Purchase Vouchers with VAT and CST (Local Purchase and CST Purchase)
5) Purchase Vouchers with StockItems and multiple VAT rates
6) Purchase Vouchers without StockItems, with multiple VAT rates

Date displayed as number in MS Excel

Query
On entering DATE in Excel, it is displayed as a number rather than Date.

Solution
1) Select "Tools >> Options >> View"
2) Uncheck the option "Formulas"  which appears under the section "Window options".

Failed to fetch Tally data

The aforesaid error Failed to fetch Tally data appears if the Tally License Server and Tally Software both are running on the same Port.

Solution :-
1) In Tally Software, press F12 and select option Advanced Confiuration
2) Next, set the Port to a different than the current Port, say 9001 or 9002.
3) Save it using Ctrl+A. The new Port settings will be visible in the Gateway of Tally.
4) Next, start UDIMagic and in the 2nd screen, click on the Settings button and set the Port as assigned in Tally Software in point 2.
5) Next, in UDIMagic 3rd screen, click on the "Test Connection" button to test connection with Tally Software.

Create new VAT Classifications in Tally

Here's a sample Excel sheet format to add / create new VAT Classifications in Tally ERP 9, Tally 9, Tally 8.1, Tally 7.2, Tally 6.3

Download Excel sheet template for VAT Classifications in Tally

Journal Vouchers with Cost Centres

Sample Excel sheet template for JV with Cost Category and Cost Centres

For other Excel to Tally templates, please refer http://www.rtslink.com/download-excel-sheets.html

Stock Items with BOM

BOM or Bill Of Materials in Tally, allows you to define a list of items for manufacturing a product.

Here are two sample Excel sheet formats for importing StockItem Master with BOM (Bill of Material) into Tally Accounting Software using UDIMagic.

Sample 1 - http://www.rtslink.com/excelfiles/stockitem-master-with-bom-sample-1.zip

Sample 2 - http://www.rtslink.com/excelfiles/stockitem-master-with-bom-sample-2.zip