Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002977 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 02. Master data management | minor | always | 2008-05-21 20:07 | 2008-06-12 09:43 | |||
| Reporter | user71 | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0002977: 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" | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(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 (reporter) 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 |
|
(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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |