0003754: Error creating invoice for volume discount

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0003754

Openbravo ERP

02. Master data management

public

2008-06-12 03:53

2008-12-12 17:49

Reporter

cromero

Assigned To

cromero

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.35MP10

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

0003754: Error creating invoice for volume discount

Description

Related to bug:
0002977

Openbravo 2.35 MP1
Ubuntu 7.10
PostgreSQL 8.26

Create the simplest possible volume discount:

* Scaled is not checked.
* No product categories included and "Not selected" in the Included Product
Categories combo.
* No product included and "Not selected" in the Included Product combo.
* Define a 10% discount for a minimum amount of â‚¬1 and a maximum amount
of â‚¬1000000
* Assign the volume discount to a business partner to whom some sales
invoices had been issued during 2008.

In the tab "Volume Discount" for the business partner:

* Double-check that the discount is assigned to the bp.
* Enter a validity date range corresponding to the whole year 2008.
* Execute the process "Create invoice".

Outcome = Error: failed to find conversion function from "unknown" to
integer

Log4j =
ERROR org.openbravo.erpWindows.VolumeDiscount.VolumeDiscountParametersData
- SQL error in query: UPDATE M_Rappel_Scale SET AD_Client_ID = TO_NUMBER(?)
, AD_Org_ID = TO_NUMBER(?) , IsActive = (?) , M_Rappel_ID = TO_NUMBER(?) ,
Discount = TO_NUMBER(?) , Amnt_From = TO_NUMBER(?) , Amnt_To = TO_NUMBER(?)
, M_Rappel_Scale_ID = TO_NUMBER(?) , updated = now(), updatedby =
to_number(?) WHERE M_Rappel_Scale.M_Rappel_Scale_ID = ? AND
M_Rappel_Scale.M_Rappel_ID = ? Exception:org.postgresql.util.PSQLException:
ERROR: new row for relation "m_rappel_scale" violates check constraint
"disc"

Steps To Reproduce

Proposed Solution

Additional Information