Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0016512 | Openbravo ERP | 07. Sales management | public | 2011-03-28 12:56 | 2011-05-12 13:25 |
|
| Reporter | AinhoaPagola | |
| Assigned To | AinhoaPagola | |
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Ubuntu 8.4 |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0RC7 | |
| 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 | 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. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | depends on | backport | 0016645 | | closed | AinhoaPagola | Error when creating shipments with negative quantities for products with negative stock |
|
| Attached Files | |
|
| 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: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 | bug_revision_view_page.php?rev_id=1784#r1784 |
| 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 | |
|
Notes |
|
|
|
(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
|
|
2011-04-20 09:37
|
|
|
|
|
(0036179)
|
|
maite
|
|
2011-04-28 17:14
|
|
|
|
|
|
|