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

Tuesday, March 21, 2017

Additional Tax in Tally ERP 9

Of late, we noticed some changes in the Ledger Entry screen while creating "Additional Tax" ledger. The same is as follows :

Tally ERP 9 Release 5.4



As you can see, in Tally ERP 9 Release 5.4, the "Type of duty" is to be set as "Additional Tax".

Tally ERP 9 Release 4.93



In Tally ERP 9 Release 4.93, the "Type of duty" is to be set as "VAT" and "Additional Tax" is to be specified in another field "Method of Calculation".

And here is the difference in the XML tags :

Tally ERP 9 Release 5.4
TAXTYPE : Additional Tax
SUBTAXTYPE : Output VAT

Tally ERP 9 Release 4.93
TAXTYPE : VAT
BASICTYPEOFDUTY : Additional Tax
SUBTAXTYPE : Output VAT

Monday, February 27, 2017

Activate license with USB Flash / Pen drive

This video shows how to activate the udi-Magic license with USB Flash drive.

If you face any have problems using the above link, you can watch the video at Youtube:
https://www.youtube.com/watch?v=jMSNjfG2Igk


PS:
Applicable to udi-Magic v6.0 and higher versions.