Localhost Vs 127.0.0.1

Localhost
Localhost (this computer) is the standard hostname given to the address of the loopback interface of the Computer.

127.0.0.1
127.0.0.1 is a special purpose address reserved for use on each computer and is conventionally the computer's loopback address.

On modern systems, the Localhost as a hostname translates into 127.0.0.1 (IPv4 address). Generally, both Localhost and 127.0.0.1 can be used to access the local machine. However, if a Proxy Server is defined, then Localhost works fine, but 127.0.0.1 may create problems and may connect to the Proxy Server even though the option "Bypass proxy server for local addresses" is set on. By default only hostnames are checked when "Bypass proxy server for local addresses" is set on. For more information, refer http://support.microsoft.com/kb/262981

Create dependent Masters in Tally

UDI-Magic v4.0 supports a new feature that allows you to specify whether Dependent Masters are to be created or not in Tally.

Usage:-
1) Open the UDIMAGIC.INI (configuration file) in Notepad.
2) Add the lines as shown below :-
     
  [UDIMAGIC]

  CreateDependentMasters=No

  

  ;;Remarks:-

  ;;a) Must appear under section [UDIMAGIC]

  ;;b) Yes means - Create Dependent Masters. 

  ;;c) No means - Do not create Dependent Masters.

3) Save the file and close Notepad.

Remarks :-
The aforesaid feature is useful in situations where initially you want to IMPORT data in a Blank New Company in Tally and the dependent Masters must be created (set CreateDependentMasters=Yes). Later on when you import data in your Original Company wherein Masters already exist, you can set it to No (CreateDependentMasters=No)

Introducing UDIMagic v4.0

We are pleased to announce the launch of UDIMagic v4.0

UDIMagic v4.0 supports UNICODE. In simple words, it allows you to import multilingual data into Tally 9,Tally ERP 9 like data in Hindi, Gujarati, Arabic etc. For more information, visit http://www.rtslink.com/udimagic-unicode.html

UDIMagic v3.0 users can upgrade to the UDIMagic v4.0. The upgradation charges are as follows depending upon the version :-

Rs 1000/- Upgrade from UDIMagic v3.0 Light to UDIMagic v4.0 Light
Rs 2000/- Upgrade from UDIMagic v3.0 Standard  to UDIMagic v4.0 Standard  
Rs 4000/- Upgrade from UDIMagic v3.0 Professional to UDIMagic v4.0 Professional

The above charges are for Single-User version. For Multi-user version, the charges will be 2.5 times that of the Single-user charges as shown above.

Customers who have  purchased UDIMagic v3.0 on or after 01/07/2011 shall be provided upgrades free-of-charge

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