Previous row values - OFFSET

The OFFSET Excel formula is quite useful when we need to access the values of previous or next rows.

Syntax
=Offset(currentcell,row,cols)

Example : 
=Offset(A10,-1,0)

Returns the value of Cell A9.

Price List with Alternate units

BUG: Tally ERP 9 Release 3.0

When you use the option "Gateway of Tally >>Price List" to enter Price Levels for an StockItem, if you specify the Rate in "Alternate Unit", the same is stored/saved but is NOT displayed when you once again modify/view it using the "Gateway of Tally >> Price List" option.

It has been confirmed by Tally Solutions, Bangalore that the aforesaid problem is a bug in Tally ERP 9 Release 3.0

Tally Error - No Accounting Info

The aforesaid error NO ACCOUNTING INFO generally occurs while importing data into Tally Software, if the LEDGERNAME tag is missing or does not contain any ledger-name.

Sales Vouchers for Automobile Dealers

Here's a sample Template for Sales Vouchers with StockItems, VAT, Addl VAT. This format is based on requirement of a Landmark Honda Dealer.

http://www.rtslink.com/excelfiles/sales-vouchers-with-items-with-vat-1004.zip

XML parse error

The XML parse error appears if you have NOT selected the XML tags file in UDIMagic. A screen snapshot of the error is given below:-

Solution
When you run UDIMagic, you will be prompted to select the following :-

a) Data-type : Voucher or Master
b) Excel file
c) XML tags file  

If you have download sample-templates from our site, please check whether the zip file contains XML-tags file.If it contains the xml-file, then you must specify the xml-file in the UDIMagic where you select the Excel sheet. Ensure that you tick the option Use separate file for XML tags.

In brief
If the zip-file downloaded from site www.rtslink.com/download-excel-sheets.html contains xml-file, then you must select it in the UDIMagic dialog box else not.

Guidelines for Tally Partners / Solutions Providers

Recently, Tally Solutions, Bangalore has provided some useful guidelines for Tally Partners / Solution Providers. Complete text of the same is available at http://tdlplayground.blogspot.com/2011/03/guidelines-for-tally-customization.html

Accordingly, it is requested of you to take note of the following :-

1) Free upgradations for UDIMagic Software shall be provided for a period of 90 days.
Remarks:-
a) This policy is being followed by Shweta Softwares from the very beginning.
b) Minor upgrades are provided free-of-cost even after 90 days.

2) Support Services shall be provided for a period of 90 days.
Remarks:-
a) This policy is being followed by Shweta Softwares from the very beginning.
b) After 90 days, Customers need to go for AMC which shall be appx 30% of the Software charges. Alternatively, support services can be availed on per-call (remote-support-call) basis also.

Convert String to Reference in Excel

Convert String to Reference

The INDIRECT worksheet function is a useful tool for creating cell or range references "on the fly", as a formula is evaluated, rather than "hard coding" them into the formula.

In its simplest usage, the INDIRECT function allows you to put the address of one cell in another, and get data from the the first cell by referencing the second. For example, if cell A1 has the value "C3", then =INDIRECT(A1) will return the value in C3