Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009953 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 09. Financial management | major | always | 2009-07-14 13:00 | 2009-07-22 13:15 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.40MP8 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 2d67352cc4dc | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.40MP6 | 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 | 0009953: Error trying to unprocess Tax Payment | |||||||
| Description | When a tax payment is processed, and you try to unprocess it, the application returns an error. In Postgre: Error: This record cannot be deleted because it is associated with other existing elements. Please see Linked Items In Oracle: ORA - 01403 No data found. That's why C_TaxPayment_Post procedure is wrong. This line: inner join gl_journalbatch gljb on gljb.gl_journalbatch_id=glj.gl_journal_id must be replaced by inner join gl_journalbatch gljb on gljb.gl_journalbatch_id=glj.gl_journalbatch_id | |||||||
| Steps To Reproduce | Create a Tax Payment. Launch Create VAT register. (Make sure that some rows within amount is returned). Process it. Unprocess it. Note: if you unprocess it sucessfully, create a single GL/Journal (batch) with many lines in Header tab. | |||||||
| Proposed Solution | Replace in C_TaxPayment_Post this line: inner join gl_journalbatch gljb on gljb.gl_journalbatch_id=glj.gl_journal_id by inner join gl_journalbatch gljb on gljb.gl_journalbatch_id=glj.gl_journalbatch_id | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0018436) hgbot (developer) 2009-07-20 22:01 |
Repository: erp/stable/2.40 Changeset: 2d67352cc4dc057d3b8fb00353b2b22af55414c5 Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com> Date: Mon Jul 20 22:00:45 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/2d67352cc4dc057d3b8fb00353b2b22af55414c5 [^] Fixes bug 0009953: Error trying to unprocess Tax Payment --- M src-db/database/model/functions/C_TAXPAYMENT_POST.xml --- |
|
(0018552) sureshbabu (viewer) 2009-07-22 13:15 |
Tested working fine, But when i click the unprocess button for the first time i am getting error as "Already processed/posted". if i reclick the button once again i am getting the above error. probably i will raise a new issue and close this current issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-19 16:37 | psarobe | Type | defect => backport |
| 2009-07-19 16:37 | psarobe | fix_in_branch | => 2.40 |
| 2009-07-20 09:08 | rafaroda | Assigned To | rafaroda => eduardo_Argal |
| 2009-07-20 22:01 | hgbot | Checkin | |
| 2009-07-20 22:01 | hgbot | Note Added: 0018436 | |
| 2009-07-20 22:01 | hgbot | Status | scheduled => resolved |
| 2009-07-20 22:01 | hgbot | Resolution | open => fixed |
| 2009-07-20 22:01 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/2d67352cc4dc057d3b8fb00353b2b22af55414c5 [^] |
| 2009-07-22 13:15 | sureshbabu | Status | resolved => closed |
| 2009-07-22 13:15 | sureshbabu | Note Added: 0018552 | |
| 2009-07-22 13:15 | sureshbabu | Fixed in Version | => 2.40MP8 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |