0024632: VAT 100 report needs to be improved. - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo Localizations
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0024632	Openbravo Localizations	Localization India	public	2013-08-30 11:07	2015-11-07 09:11

Reporter	psanjuan
Assigned To	prashanth_s
Priority	urgent	Severity	major	Reproducibility	always
Status	acknowledged	Resolution	open
Platform		OS	20	OS Version	Ubuntu 8.04.1
Product Version
Target Version		Fixed in Version
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Support ticket
OBNetwork customer
Regression introduced in release

Summary	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.
Additional Information
Tags	No tags attached.
Relationships
Attached Files

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	bug_revision_view_page.php?rev_id=6528#r6528
2015-11-07 09:11	prashanth_s	Status	scheduled => acknowledged
2015-11-07 09:11	prashanth_s	Target Version	14Q3 =>

There are no notes attached to this issue.