0009890: Error trying to unprocess Tax Payment - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009890

Openbravo ERP

09. Financial management

public

2009-07-14 13:00

2009-07-21 00:00

Reporter

networkb

Assigned To

eduardo_Argal

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40MP6

Target Version

Fixed in Version

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

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

Additional Information