0024632: VAT 100 report needs to be improved.

Description

VAT 100 report needs to be improved.
This report is provided in the format required by the Government of India, as it is a consolidated view of the "Tax Payable" to the Government.

This report calculates the difference between "Sales" and "Purchase" Invoices that have a VAT tax rate associated to its lines.

************************************
VAT -- Value-Added Tax -- is the biggest tax reform in the last 50 years of independent India and will change forever the way traders do their business.

Some VAT registered traders may overcharge their customers because they do not understand the correct workings of VAT on prices or are deliberately using VAT as an excuse for increasing prices.

A trader registered for VAT effectively pays VAT only at one stage when he sells his goods.

This tax is the only amount, which has an effect on his selling price which includes VAT. The VAT that he has paid as a part of his purchase price is charged on him by his suppliers.

This is not a cost to him because he gets it back by deducting it from tax on his sales (Output Tax). Therefore, VAT should have a minimum impact on his selling prices
************************************

Steps To Reproduce

Please follow below attached article of the User Manual:
http://wiki.openbravo.com/wiki/VAT_India/User_Documentation#Vat_100_Report [^]

Proposed Solution

Taxes are clubbed together based on the tax type, for instance:

CST means Central State tax, so all the Tax Rates that are a CST tax type (i.e. CST 2%) and besides are included in a sales invoice come under the section "Inter State Sales Tax".
The ones of this type that are included in a purchase invoice come under the section "Purchase Tax".

*In a next release of this report, these last purchase ones will come under a new section named "Inter State Purchase Tax".

Tax Rates with KAVAT are Karnataka Local (or State) Taxes, therefore the Tax Rates of this type included in a sales invoice come under the section "Local Sales Tax".
The ones of this type that are included in a purchase invoice come under the section "Purchase Tax"

*In a next release of this report, these last purchase ones will come under a new section named "Local Purchase Tax".

Finally in a next version of this report below sub-totals are going to be added, therefore the "Tax Payable" to the Central and State Government are properly calculated upon those sub-totals:

    Inter State Sales Tax subtotal
    Inter State Purchase Tax subtotal

Therefore [Inter State Sales Tax - Inter State Purchase Tax] = Total Tax Payable to Central Government.

    Local Sales Tax subtotal
    Local Purchase Tax subtotal

Therefore [Local Sales Tax - Local Purchase Tax] = Total Tax Payable to the State Government.

Issue History
Date Modified	Username	Field	Change
2013-08-30 11:07	psanjuan	New Issue
2013-08-30 11:07	psanjuan	Assigned To	=> priti
2014-05-15 13:33	psanjuan	Assigned To	priti => prashanth_s
2014-07-29 07:32	prashanth_s	Target Version	=> 14Q3
2014-07-29 07:33	prashanth_s	Status	new => scheduled
2014-09-03 08:57	prashanth_s	Description Updated	View Revisions
2015-11-07 09:11	prashanth_s	Status	scheduled => acknowledged
2015-11-07 09:11	prashanth_s	Target Version	14Q3 =>

Relationships [ Relation Graph ] [ Dependency Graph ]