Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002977Openbravo ERP02. Master data managementpublic2008-05-21 20:072008-06-12 09:43
Reporteruser71 
Assigned Tocromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002977: Error creating invoice for volume discount
Description
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
TagsNo tags attached.
Relationships
depends on backport 0003754 closed cromero Error creating invoice for volume discount 
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0006566)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1968986 [^]
(0003698)
user71   
2008-05-22 13:37   
(edited on: 2008-06-12 09:26)
Logged In: YES
user_id=1941819
Originator: YES

Revisando este tema me he dado cuenta que el error SQL que he reportado nada tiene que ver con el problema de creación de la factura de rappels.
 
El error SQL lo dio al introducir un descuento en negativo, por ejemplo -10%, y efectivamente la tabla m_rappel_scale tiene una restricción en este sentido (ALTER TABLE m_rappel_scale ADD CONSTRAINT disc CHECK (discount >= 0::numeric AND discount <= 100::numeric);
 
Así pues, el error que se produce en la creación de la factura de rappels es: "Error: failed to find conversion function from "unknown" to integer".
(0003699)
user71   
2008-05-22 13:41   
(edited on: 2008-06-12 09:26)
Logged In: YES
user_id=1941819
Originator: YES

I have been reviewing this issue and I realised that the SQL error that I reported has nothing to do with the issue of the volume discount invoice.

The SQL error apeared when some negative discount is entered in the volume discount definition, for instance -10%, and as observed previously the table m_rappel_scale includes a constraint in this sense (ALTER TABLE m_rappel_scale ADD CONSTRAINT disc CHECK
(discount >= 0::numeric AND discount <= 100::numeric);

So, the error that pops up when creating a volume discount invoice is: "Error: failed to find conversion function from "unknown" to
integer".
(0003700)
cromero   
2008-06-12 04:01   
(edited on: 2008-06-12 09:26)
Logged In: YES
user_id=1500614
Originator: NO

Fixed in the trunk in revision 4995