Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021333 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | minor | always | 2012-08-09 09:06 | 2012-09-26 17:18 | |||
| Reporter | xabiermerino | View Status | public | |||||
| Assigned To | jecharri | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | ea1e6b9dbf58 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP16 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 3.0MP13 | SCM revision | ||||||
| Review Assigned To | xabiermerino | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0021333: Error creating an invoice line of a product with 'price adjustment' and price 0 | |||||||
| Description | When you try to create a line from an order with the price 0, if there is a price adjustment that affects, this error appears: Error ERROR: null value in column "priceoffer" violates not-null constraint Where: SQL statement "INSERT INTO C_INVOICELINE_OFFER (C_INVOICELINE_OFFER_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_INVOICELINE_ID, LINE, M_OFFER_ID, PRICEOFFER, AMTOFFER) VALUES ( $1 , $2 , $3 , $4 , TO_DATE(NOW()), $5 , TO_DATE(NOW()), $6 , $7 , $8 , $9 , ROUND( $10 , $11 ), ROUND( $12 , $11 ))" PL/pgSQL function "c_invoiceline_trg2" line 194 at SQL statement | |||||||
| Steps To Reproduce | -As admin create a price adjustment: - Discount %: 100 - Included Products: Only those defined - Products: Zumo de Piña 0.5L -Create an order of this product and change the price to 0. -Create an invoice and try to create the line using the button 'Create lines from' | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0051911) hgbot (developer) 2012-09-07 11:06 |
Repository: erp/devel/pi Changeset: ea1e6b9dbf5884804b58b7288461a8ccf7935db2 Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Mon Sep 03 15:25:27 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/ea1e6b9dbf5884804b58b7288461a8ccf7935db2 [^] Fixes issue 21333: Error creating an invoice line of a product with 'price adjustment' and price 0 --- M src-db/database/model/functions/M_GET_OFFER_STD_PRICE.xml --- |
|
(0051967) jecharri (developer) 2012-09-10 16:19 |
test plan: -with steps to reproduce is enough. You can try to execute with differents values of discount but the code change only affect to discount with value 100. |
|
(0052104) xabiermerino (reporter) 2012-09-14 09:24 |
verified |
|
(0052698) hudsonbot (developer) 2012-09-26 17:18 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-08-09 09:06 | xabiermerino | New Issue | |
| 2012-08-09 09:06 | xabiermerino | Assigned To | => mirurita |
| 2012-08-09 09:06 | xabiermerino | Modules | => Core |
| 2012-08-09 09:06 | xabiermerino | Resolution time | => 1350943200 |
| 2012-08-09 09:06 | xabiermerino | Issue Monitored: networkb | |
| 2012-08-09 14:11 | mirurita | Assigned To | mirurita => jonalegriaesarte |
| 2012-08-10 10:15 | jonalegriaesarte | Assigned To | jonalegriaesarte => jecharri |
| 2012-09-07 11:06 | hgbot | Checkin | |
| 2012-09-07 11:06 | hgbot | Note Added: 0051911 | |
| 2012-09-07 11:06 | hgbot | Status | new => resolved |
| 2012-09-07 11:06 | hgbot | Resolution | open => fixed |
| 2012-09-07 11:06 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ea1e6b9dbf5884804b58b7288461a8ccf7935db2 [^] |
| 2012-09-10 16:19 | jecharri | Note Added: 0051967 | |
| 2012-09-14 09:24 | xabiermerino | Closed by | => xabiermerino |
| 2012-09-14 09:24 | xabiermerino | Note Added: 0052104 | |
| 2012-09-14 09:24 | xabiermerino | Status | resolved => closed |
| 2012-09-26 17:18 | hudsonbot | Checkin | |
| 2012-09-26 17:18 | hudsonbot | Note Added: 0052698 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |