Sunday, April 30, 2017

Calculate VAT on MRP

Applicable to : Tally ERP 9 Release 5.5.6

Recently, we noticed some issues while using the "Calc VAT on MRP" feature. We posted two SALES INVOICEs in Tally, the details being as follows :

Sale Invoice 1

Stockitem Master Name: Item CX
MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 5%

Sale Voucher
StockItem Name : Item CX
Qty : 1
Rate : Rs 238.09 (Auto computed in Tally)
Amount : Rs 238.09 (Auto computed in Tally)
VAT Amount : Rs 11.91 (Auto computed in Tally)

Sale Invoice 2

Stockitem Master Name : Item DX

MRP : Rs 250.
Calc VAT on MRP : Yes
MRP Incl of VAT : Yes
Is Inclusive of duties and taxes : Yes
VAT : 4%
Addl Tax : 1%

Sale Voucher
StockItem Name : Item DX
Qty : 1
Rate : Rs 237.98 (Auto computed in Tally)
Amount : Rs 237.98 (Auto computed in Tally)
VAT Amount : Rs 9.62 (Auto computed in Tally)
Addl VAT Amt: Rs 2.40 (Auto computed in Tally)

Remarks
As it can be seen, the VAT amount is incorrectly computed when we specify VAT + Addl Tax in the StockItem Master and "Calc VAT on MRP" is enabled.

VAT 5% => Rs 11.91 (Correct VAT in Sale Voucher 1)
VAT 4+1% => Rs 12.02 (Incorrect VAT in Sale Voucher 2)

Workaround
A workaround is to disable the "Calc VAT on MRP"  and enable "Is Inclusive of duties and taxes" only in the StockItem Master. This way, VAT is computed correctly in both the situations as mentioned above.

Saturday, April 29, 2017

Inclusive of VAT

A new option "Allow inclusive of tax for stock Items" has been included in Tally ERP 9 Release 5.0 onwards. This allows you to prepare Sales Invoice with Rate inclusive of VAT.

Tally ERP 9 Release 5.0
1. Go to Stockitem creation/alteration
2. Press F12 [Config]. This displays the Stockitem Configuration screen as shown underneath :

Tally ERP 9 Release 5.0

3. Enable "Allow inclusive of tax for stock items" as shown above.

4. Back in the Stockitem screen, enable VAT Applicable and specify the VAT Rate using "Set/alter VAT details"
5. Next, set "Is inclusive of duties and taxes" to Yes


Tally ERP 9 Release 5.0



Tally ERP 9 Release 4.92 or lower
1. Go to Stockitem creation/alteration
2. Press F12 [Config]

This displays the Stockitem Configuration screen as shown underneath (without the Inclusive option) :

Tally ERP 9 Release 4.92
Remarks:
The "Is inclusive of duties and taxes" is NOT there in Tally ERP 9 Release 4.92

Sunday, April 23, 2017

Incorrect Unit (UOM) when importing data into Tally

Query:
I am importing Sales/Purchase Vouchers with StockItems  using one of the Standard templates provided with udi-Magic. For a specific voucher in the XLS file, the UOM is specified as "Nos", but when I check the entry imported in Tally, it shows the UOM incorrectly as "Kgs".
Ans:
This would happen if the StockItem already exists in Tally with UOM as Kgs.

You must manually change the UOM in the StockItem Master. And this is only possible if there are no vouchers entries for that StockItem.

Friday, April 21, 2017

Template modifications

Of late, the following modifications have been done in the Standard templates :

Date : 22nd April 2017
Template : Vouchers-Bank-Statement.xls
New Column : Group-Name for Other Ledger
Remarks : If the Group-Name is not specified, then the Ledgers are created under group "New Ledgers"

Previous Changes

Date : 3rd April 2017
Template : Vouchers-V7-Sales-Purchase-Adavanced.xls
New columns in the Settings / CSV file :
NATUREOFTRANSACTION
TYPEOFINVOICE
CSTFORMRECVTYPE

Date : 3rd April 2017
Template : Master-LedgerMaster.xls
New columns for :
TaxType
NatureOfTransaction
VATRate
AdditionalTax

Date : 30th March 2017
Template : Master-LedgerMaster.xls
New fields added for :
VATDEALERTYPE, VAT Reg Date, CST Reg Date

Date : 28th March 2017
Template : Master-LedgerMaster
New column for COUNTRY

Download link (all templates) :
https://github.com/ShwetaSoftwares/standard-templates/archive/master.zip

Tuesday, April 4, 2017

Cannot alter unit for Item x

The aforesaid error generally appears while :

Uploading "StockItem Masters" into a Tally Company; which already contains the same StockItem but with a different unit of measurement.

Here's a example :

StockItem with name "Item A" exists in Tally Company having Unit of Measurement (UOM) as "Nos". Let's now try to modify it's UOM to Kgs. As you can see below, the cursor does NOT go the the Unit field.



Remarks:
This is a restriction in Tally Software. You cannot alter the UOM of a StockItem if one or more records / vouchers exist which contain that StockItem