Wednesday, September 28, 2011

UDI Magic Licensing

Important Note
Manual reset for UDIMagic license shall be restricted to maximum 4 times per annum and 10 times in total (life-time).This shall be applicable to all UDIMagic users.

Friday, September 23, 2011

Missing Security Tab in Windows XP

In Windows XP, you can set permissions on files so that specific users can access it. However, in certain cases when you Right click on the file and select Properties, you may notice that the Security tab is missing.

To get the Securities tab, follow the underneath steps :-
1. Open Windows Explorer, and choose Folder Options from the Tools menu.
2. On the View tab, scroll to the bottom of the Advanced Settings and Clear (click) the check box next to "Use Simple File Sharing."
3. Click OK to apply the change, and you should now have a Security tab when viewing the properties of a file on an NTFS volume.

VBA Check if Sheet exists

In certain Excel templates, we use a sheet for specifying some Settings. Generally, this sheet is named as SETTINGS.

However, at times you may forget to include the Settings sheet. Here's the macro code to check for the Settings sheet and display a message if it is NOT found.
'Check if Sheet exists
 Dim sh As Worksheet, flg As Boolean
 For Each sh In Worksheets
  If sh.Name Like "Settings*" Then flg = True: Exit For
 If flg = True Then
  'MsgBox "Found!"
  MsgBox "Error: Settings Sheet NOT Found! " +chr(13)+chr(13)+"A sheet named SETTINGS must exist in Excel file"+chr(13)+"Terminating application"
 End If

Thursday, September 8, 2011

Wings to Tally

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

1) Import Cash Vouchers from Wings Software to Tally

Supports multiple Party ledgers in Receipt and Payment

Friday, September 2, 2011

Tally Error : Date is Out of Range

The aforesaid error Date is Out of Range occurs if the voucher date is lesser than the Books beginning date given in the Tally Company.

A typical situation wherein the aforesaid occurs is shown underneath :-

a) The Books beginning date in Tally is 01/04/2011
b) The Voucher date in the Excel sheet is 09/01/2011

While importing data into Tally using UDIMagic, the error "Date 9-1-2011 is out of Range" appears. This is because the Voucher has DATE as 9-1-2011 (i.e. 9th January 2011)

We  have found that the said problem generally arises in cases where the Excel data is generated from some 3rd party application. Though the data generated by that application may be in dd-mm-yyyy format, it appears as mm-dd-yyyy in the Excel sheet. To rectify this, use option "Start - Settings - Control Panel - Regional and Language Options" and set the option as "English (United Kingdom)" instead of "English (United States)".