Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009890 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 09. Financial management | major | always | 2009-07-14 13:00 | 2009-07-21 00:00 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | eduardo_Argal | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ||||
| 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 | 0009890: 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 ]
|
||||||||
|
||||||||
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-07-14 13:00 | networkb | New Issue | |
| 2009-07-14 13:00 | networkb | Assigned To | => rafaroda |
| 2009-07-14 13:00 | networkb | OBNetwork customer | => Yes |
| 2009-07-19 16:37 | psarobe | Status | new => scheduled |
| 2009-07-19 16:37 | psarobe | fix_in_branch | => pi |
| 2009-07-20 09:08 | rafaroda | Assigned To | rafaroda => eduardo_Argal |
| 2009-07-20 22:12 | eduardo_Argal | Status | scheduled => closed |
| 2009-07-20 22:12 | eduardo_Argal | Resolution | open => fixed |
| 2009-07-21 00:00 | anonymous | sf_bug_id | 0 => 2824536 |
| Copyright © 2000 - 2009 MantisBT Group |