|View Issue Details|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|defect||[Openbravo ERP] 09. Financial management||major||always||2014-10-03 12:17||2014-12-30 23:22|
|Priority||normal||Resolution||fixed||Fixed in Version|
|Status||closed||Fix in branch||pi||Fixed in SCM revision||401047aa8e05|
|OS Version||Database version||Ant version|
|Product Version||SCM revision|
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
0027753: Tax Payment Unprocess when Generate Payment = Y - ORACLE
|Description||IMPORTANT: This behavior is only reproducible in Oracle!|
The Tax Payment generates a payment when processing the record as long as the Generate Payment = Y.
However, when unprocessing the tax payment, the previously created payment is kept.
Later on, if we process again the same tax payment, a new payment is created, which is totally wrong
|Steps To Reproduce||1. Follow tax payment guide and process record using option "generate payment"=Y: http://wiki.openbravo.com/wiki/Tax_Payment [^] [^]|
2. Access Payment in/Payment out window and search for created payment. Write down the payment number
3. Navigate to GL Journal window from Tax Payment header and ensure that journal is unpost
4. Go back to tax payment and unprocess it
5. Go to the Payment in/Payment out window and search for the previously created payment. It's still there. WRONG
6. Go back to tax payment, ensure "generate payment"=Y and process it.
7. Go to the Payment in/Payment out window and realize the previous payment is there and the process has created a new one. WRONG
|Proposed Solution||Ideally, when unprocessing the tax payment, the associated payment should be deleted. |
If not possible (for example because the payment is already included into a transaction, reconcilation, it's posted, etc.), an error message should inform the user about this situation and stops the process. The user should be able to manually fix this situation (if possible) and try to unprocess the tax payment again.
|Tags||No tags attached.|
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Oct 06 11:46:42 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/401047aa8e05b51d4b8bcbd7ea261e71cb6e3f23 [^]
Fixed bug 27753: Tax Payment Unprocess when Generate Payment = Y (ORACLE only)
The extension point when unprocessing a Tax Payment didn't work in Oracle, reason: a SQL query was expecting to receive always a GL Item, but when unprocessing a record, the GL Item is not sent to the extension point. This created an Oracle exception that wasn't properly captured.
The solution is to move the SQL query that requires the GL Item inside the processing flow only.
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/6525fe229e06 [^]
Maturity status: Test
|2014-10-03 12:17||vmromanos||New Issue|
|2014-10-03 12:17||vmromanos||Assigned To||=> dmiguelez|
|2014-10-03 12:17||vmromanos||Modules||=> Core|
|2014-10-03 12:17||vmromanos||Triggers an Emergency Pack||=> No|
|2014-10-03 12:17||vmromanos||Relationship added||related to 0026562|
|2014-10-03 13:54||vmromanos||Summary||Tax Payment Unprocess when Generate Payment = Y => Tax Payment Unprocess when Generate Payment = Y - ORACLE|
|2014-10-03 13:54||vmromanos||Description Updated||View Revisions|
|2014-10-06 11:30||vmromanos||Assigned To||dmiguelez => vmromanos|
|2014-10-06 11:30||vmromanos||Status||new => scheduled|
|2014-10-06 11:30||vmromanos||fix_in_branch||=> pi|
|2014-10-06 12:13||hgbot||Note Added: 0070736|
|2014-10-06 12:13||hgbot||Status||scheduled => resolved|
|2014-10-06 12:13||hgbot||Resolution||open => fixed|
|2014-10-06 12:13||hgbot||Fixed in SCM revision||=> http://code.openbravo.com/erp/devel/pi/rev/401047aa8e05b51d4b8bcbd7ea261e71cb6e3f23 [^]|
|2014-10-15 19:01||maite||Note Added: 0070978|
|2014-10-15 19:01||maite||Status||resolved => closed|
|2014-12-30 23:22||hudsonbot||Note Added: 0072901|
|Copyright © 2000 - 2009 MantisBT Group|