Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016512 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | have not tried | 2011-03-28 12:56 | 2011-05-12 13:25 | |||
| Reporter | AinhoaPagola | View Status | public | |||||
| Assigned To | AinhoaPagola | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 3.0RC7 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 601527a7b71a | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 8.4 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0016512: Error when creating shipments with negative quantities for products with negative stock | |||||||
| Description | A "null value in column "c_uom_id" violates not-null constraint" error is displayed when a POS sales order with two lines with a negative amount of a product without stock is completed. | |||||||
| Steps To Reproduce | - Create a product and check as stocked. Link it to a pricelist - Make sure the client allows negative stock - Create a POS sales order with one line and a positive amount of the product. The product will have a negative amount on stock. Complete the order. The shipment and invoice will be created. - Create a POS sales order with two lines. Both of them with negative amounts of the product. Complete the order. The error will be thrown because the shipment can not be created. This issue only reproduces when the stocked quantity of the product is negative. I does not reproduce if different products are used. | |||||||
| Proposed Solution | The problem may be related to the Cursor Cur_Storage in the function m_inout_create. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0035293) jpcalvente (viewer) 2011-03-29 09:11 |
(JCA): The possible solution is to change m_inout_create(IN p_pinstance_id character varying, OUT p_inout_id character varying, IN p_order_id character varying, IN p_invoice_id character varying, IN p_forcedelivery character, IN p_locator_id character varying) line 416, put v_LocatorQty>0 instead of v_LocatorQty<>0. This should be tested with all possibilites |
|
(0036023) hgbot (developer) 2011-04-20 09:37 |
Repository: erp/devel/pi Changeset: 601527a7b71ae8834d82716055388b39b3319cfe Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com> Date: Mon Apr 11 18:10:06 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/601527a7b71ae8834d82716055388b39b3319cfe [^] Fixes issue 16512. Error in shipments with negative quantities and negative stock --- M src-db/database/model/functions/M_INOUT_CREATE.xml --- |
|
(0036179) maite (viewer) 2011-04-28 17:14 |
verfied |
|
(0036733) hudsonbot (viewer) 2011-05-12 13:25 |
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/c40e579fcd38 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-03-28 12:56 | AinhoaPagola | New Issue | |
| 2011-03-28 12:56 | AinhoaPagola | Assigned To | => adrianromero |
| 2011-03-28 12:56 | AinhoaPagola | Modules | => Core |
| 2011-03-28 12:56 | AinhoaPagola | OBNetwork customer | => Yes |
| 2011-03-28 12:57 | AinhoaPagola | Priority | normal => high |
| 2011-03-29 09:11 | jpcalvente | Note Added: 0035293 | |
| 2011-03-29 10:10 | AinhoaPagola | Priority | high => urgent |
| 2011-03-29 10:10 | AinhoaPagola | Severity | minor => major |
| 2011-04-05 10:20 | AinhoaPagola | Assigned To | adrianromero => AinhoaPagola |
| 2011-04-05 13:11 | AinhoaPagola | Status | new => scheduled |
| 2011-04-05 13:11 | AinhoaPagola | fix_in_branch | => pi |
| 2011-04-06 13:03 | AinhoaPagola | fix_in_branch | pi => |
| 2011-04-06 13:03 | AinhoaPagola | Steps to Reproduce Updated | View Revisions |
| 2011-04-20 09:37 | hgbot | Checkin | |
| 2011-04-20 09:37 | hgbot | Note Added: 0036023 | |
| 2011-04-20 09:37 | hgbot | Status | scheduled => resolved |
| 2011-04-20 09:37 | hgbot | Resolution | open => fixed |
| 2011-04-20 09:37 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/601527a7b71ae8834d82716055388b39b3319cfe [^] |
| 2011-04-28 17:14 | maite | Note Added: 0036179 | |
| 2011-04-28 17:14 | maite | Status | resolved => closed |
| 2011-04-28 17:14 | maite | Fixed in Version | => 3.0RC7 |
| 2011-04-29 00:00 | anonymous | sf_bug_id | 0 => 3294643 |
| 2011-05-12 13:25 | hudsonbot | Checkin | |
| 2011-05-12 13:25 | hudsonbot | Note Added: 0036733 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |