Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0027753 | ||||||||
| 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 | |||
| Reporter | vmromanos | View Status | public | |||||
| Assigned To | vmromanos | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 401047aa8e05 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 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. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0070736) hgbot (developer) 2014-10-06 12:13 |
Repository: erp/devel/pi Changeset: 401047aa8e05b51d4b8bcbd7ea261e71cb6e3f23 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. --- M modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_TAX_PAYMENT.xml --- |
|
(0070978) maite (viewer) 2014-10-15 19:01 |
verified |
|
(0072901) hudsonbot (viewer) 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: https://code.openbravo.com/erp/devel/main/rev/6525fe229e06 [^] Maturity status: Test |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 | OBNetwork customer | No => Yes |
| 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 | => 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 | Checkin | |
| 2014-12-30 23:22 | hudsonbot | Note Added: 0072901 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |