Wings to Tally

Here are sample files for importing data from Wings Software to Tally

1) Import Cash Vouchers from Wings Software to Tally
2) Import Sales Vouchers from Wings Software to Tally

Excel 2010 - Error 800A3EC

In case, if you are using Excel 2010 or Excel 2007 and get the Ole Error 800A3EC while importing data into Tally using UDIMagic, then it is likely that VBA is NOT installed in your system.

VBA macros in 2010, 2007

Prior to Excel 2007 you didn't need to install the Visual Basic Editor if you wanted to develop or run macros (VBA procedures). In Excel 2007, Excel 2010 you must specify that VBA be installed when you install Excel from the Office CD. See how to install Visual Basic for Application for Excel 2010 / 2007

VBA Replace function

Syntax

Replace(cString , cFind , cReplaceWith)

Example

Replace(cString, "A","a")

The above replaces all occurrences of  capital "A" with small "a" in the cString variable.

Remarks:-
The VBA Replace function is very useful for manipulating Excel data at runtime. In certain cases, where the Excel data is generated from 3rd party softwares, we faced certain issues. Example, the Amount was displayed in TEXT format and included comma separator like 1,50,000.00. We used the VBA Replace function to remove the commas and then convert the value to Numeric.

Excel to Tally - Sample Excel sheet formats

The following sample Excel sheet format is now available for UDIMagic users :-

Financial Vouchers with Cost Category and Cost Centres

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