Wednesday, March 30, 2011

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.

Tuesday, March 29, 2011

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.

Tuesday, March 22, 2011

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.

Saturday, March 19, 2011

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.