Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009953Openbravo ERP09. Financial managementpublic2009-07-14 13:002009-07-22 13:15
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP6 
Target VersionFixed in Version2.40MP8 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009953: Error trying to unprocess Tax Payment
DescriptionWhen 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 ReproduceCreate 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 SolutionReplace 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
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0009890 closed eduardo_Argal Error trying to unprocess Tax Payment 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-19 16:37psarobeTypedefect => backport
2009-07-19 16:37psarobefix_in_branch => 2.40
2009-07-20 09:08rafarodaAssigned Torafaroda => eduardo_Argal
2009-07-20 22:01hgbotCheckin
2009-07-20 22:01hgbotNote Added: 0018436
2009-07-20 22:01hgbotStatusscheduled => resolved
2009-07-20 22:01hgbotResolutionopen => fixed
2009-07-20 22:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/2d67352cc4dc057d3b8fb00353b2b22af55414c5 [^]
2009-07-22 13:15sureshbabuStatusresolved => closed
2009-07-22 13:15sureshbabuNote Added: 0018552
2009-07-22 13:15sureshbabuFixed in Version => 2.40MP8

Notes
(0018436)
hgbot   
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   
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.