0009192: When completing a purchase invoice I get an error

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009192

Openbravo ERP

03. Procurement management

public

2009-05-27 02:12

2009-05-29 00:00

Reporter

gkfabs

Assigned To

rafaroda

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

rPath Linux

Product Version

2.50

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0009192: When completing a purchase invoice I get an error

Description

When completing a purchase invoice I get the error

Postgresql logs

2009-05-26 14:16:03 MDT NOTICE: Creating C_Cash
2009-05-26 14:16:03 MDT CONTEXT: SQL statement "SELECT C_INVOICE_POST( $1 , NULL)"
PL/pgSQL function "c_invoice_post0" line 27 at PERFORM
2009-05-26 14:16:03 MDT NOTICE: @ERROR=operator does not exist: character varying = numeric

Steps To Reproduce

Create a new purchase invoice from a purchase order from a requirement. Try to complete it.

Proposed Solution

In the file ./src-db/database/model/functions/C_INVOICE_POST.xml

Line 1457

Replace:
v_CB_Curr NUMBER;

With
v_CB_Curr VARCHAR2(32);

The v_CB_Curr is used to keep an id. Id are not numerics, they are chars because of the uuid change.

Additional Information