Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009890
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2009-07-14 13:002009-07-21 00:00
ReporternetworkbView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP6SCM revision 
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
Summary

0009890: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0009953 closededuardo_Argal Error trying to unprocess Tax Payment 

-  Notes
There are no notes attached to this issue.

- 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
Powered by Mantis Bugtracker