Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2014-10-03 12:172014-12-30 23:22
ReportervmromanosView Statuspublic 
Assigned Tovmromanos 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision401047aa8e05
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0027753: Tax Payment Unprocess when Generate Payment = Y - ORACLE

DescriptionIMPORTANT: 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 Reproduce1. Follow tax payment guide and process record using option "generate payment"=Y: [^] [^]
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 SolutionIdeally, 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00265623.0PR15Q1 closedvmromanos Improve error message when Unprocessing a Tax Payment with related Payment posted 

-  Notes
hgbot (developer)
2014-10-06 12:13

Repository: erp/devel/pi
Changeset: 401047aa8e05b51d4b8bcbd7ea261e71cb6e3f23
Author: Víctor Martínez Romanos <victor.martinez <at>>
Date: Mon Oct 06 11:46:42 2014 +0200
URL: [^]

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.

M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_TAX_PAYMENT.xml
maite (developer)
2014-10-15 19:01

hudsonbot (developer)
2014-12-30 23:22

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

Promotion changeset: [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
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 Checkin
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 => [^]
2014-10-15 19:01 maite Note Added: 0070978
2014-10-15 19:01 maite Status resolved => closed
2014-12-30 23:22 hudsonbot Checkin
2014-12-30 23:22 hudsonbot Note Added: 0072901

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker