Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0025638
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2014-02-03 11:012014-02-12 18:29
ReportervmromanosView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5b7d0ffec363
ProjectionnoneETAnoneTarget Version3.0PR14Q3
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_12
OS VersionDebian 5.0Database version8.3.8Ant version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0025638: Cash VAT: Withholding and tax exempt (rate=0%) support

DescriptionRight now it is not possible to enter a cash VAT invoice with a withholding tax rate. This is wrong and the system should allow this scenario.

The withholding tax rates are declared as cash vat=N and withholding=Y. Besides, we can have a summary level tax rate declared as cash vat, which includes a cash VAT tax rate and a withholding tax rate, for example the Spanish tax rate "Arrendamientos 21% -21%R (cobros)" for Cash VAT.

A cash VAT invoice (declared at the invoice's header) must include (at least) a Cash VAT tax rate, an optionally it may also include a withholding tax rate or even a exempt tax rate for any of its lines.

The Cash VAT information and Cash VAT accounting flow must only apply to the cash VAT tax amount, ignoring the withholding and the exempt (rate=0%) tax rates.
Steps To Reproduce1. Create a sales invoice. Set the Cash VAT=Y
2. Enter a line with a cash vat tax rate previously created (for example Entregas IVA 21% IVA de Caja)
3. Enter a new line but this time selecting a withholding tax rate previously created (for example "Arrendamientos 21% -21%R (cobros)")
4. Try to complete the invoice. An error is shown

Proposed SolutionExpected behaviour:
1. The invoice is successfully completed regardless having cash vat and withholding or exempt (rate=0%) tax rates at the same time
2. When registering a payment, the Cash VAT tab is filled only for the Cash VAT tax rates, ignoring the withholding tax rates and exempt tax rate (rate=0%).
3. The invoice/payment/transaction/reconciliation accounting will use the transitory accounts only for the tax amounts related to the Cash VAT tax rates.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 00246153.0MP30 closedvmromanos Openbravo 3 needs to allow Cash VAT management 

-  Notes
(0063881)
hgbot (developer)
2014-02-04 10:22

Repository: erp/devel/pi
Changeset: 5b7d0ffec3637c35311e451916cf1fc360f1ec5b
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Feb 03 12:11:07 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5b7d0ffec3637c35311e451916cf1fc360f1ec5b [^]

Fixed bug 25638: [cashvat] Withholding and tax exempt (rate=0%) support

Cash VAT invoices are allowed to include withholding and exempt (rate=0%) tax rates.
Cash VAT information at Invoice | Tax level only created for Cash VAT tax rates (neither withholding nor exempt tax rates).
Cash VAT accounting flow (usage of tax transitory accounts) only for Cash VAT tax rates (neither withholding nor exempt tax rates).

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
M src-db/database/model/functions/C_GETTAX.xml
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/model/triggers/C_INVOICELINE_TRG.xml
M src/org/openbravo/erpCommon/ad_forms/DocInvoice.java
M src/org/openbravo/erpCommon/ad_forms/DocInvoice_data.xsql
M src/org/openbravo/erpCommon/ad_forms/DocTax.java
M src/org/openbravo/erpCommon/utility/CashVATUtil.java
---
(0064041)
psanjuan (manager)
2014-02-11 09:57

Fixed and working. Issue can be closed.
(0064152)
hudsonbot (developer)
2014-02-12 18:29

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d1a5bb862230 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-02-03 11:01 vmromanos New Issue
2014-02-03 11:01 vmromanos Assigned To => vmromanos
2014-02-03 11:01 vmromanos Modules => Core
2014-02-03 11:01 vmromanos Triggers an Emergency Pack => No
2014-02-03 11:03 vmromanos Status new => scheduled
2014-02-03 11:03 vmromanos fix_in_branch => pi
2014-02-03 12:13 vmromanos Relationship added related to 0024615
2014-02-04 10:22 hgbot Checkin
2014-02-04 10:22 hgbot Note Added: 0063881
2014-02-04 10:22 hgbot Status scheduled => resolved
2014-02-04 10:22 hgbot Resolution open => fixed
2014-02-04 10:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5b7d0ffec3637c35311e451916cf1fc360f1ec5b [^]
2014-02-11 09:57 psanjuan Note Added: 0064041
2014-02-11 09:57 psanjuan Status resolved => closed
2014-02-11 09:57 psanjuan fix_in_branch pi =>
2014-02-12 18:29 hudsonbot Checkin
2014-02-12 18:29 hudsonbot Note Added: 0064152


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker