Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0025541Openbravo ERP07. Sales managementpublic2014-01-23 10:402014-02-12 18:29
caristu 
caristu 
normalminorhave not tried
closedfixed 
5
pi 
3.0PR14Q2 
VictorVillar
Core
No
0025541: Wrong error message when generating bill of materials production under some circumstances
If we process a bill of materials and we have a completed stock reservation for a needed product with all the quantity released, this reservation is taken into account when generating the transactions.

If in addition we don't have enough stock of that product, the following message appears:

"Cannot take out reserved stock of Product: xxx, Attribute Set Instance: xxx, UOM: xxx and Storage Bin: xxx"
1) In the [Client] window check the "allow negative stock"
2) Create a new product: P1
3) Create a new product: B1 and check it as bill of materials, add two units of P1 in the [Bill of Materials] tab
4) Verify the BOM
5) Create a new physical inventory for product P1, with quantity 1
6) Create a new sales order with one line with P1 product and quantity 1, reserve it and create the corresponding goods shipment (the reservation will be completed and with all its quantity released)
7) Create a new Bill of Materials production for B1 product.
8) Process it. The error appears.
Completed reservations with all the stock released shouldn't be taken into account in the M_TRANSACTION_TRG2 trigger
No tags attached.
Issue History
2014-01-23 10:40caristuNew Issue
2014-01-23 10:40caristuAssigned To => caristu
2014-01-23 10:40caristuModules => Core
2014-01-23 10:40caristuTriggers an Emergency Pack => No
2014-01-23 10:40caristuversion => pi
2014-01-23 10:40caristuTarget Version => 3.0MP32
2014-01-23 10:45caristuIssue Monitored: networkb
2014-01-23 10:46caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5361#r5361
2014-01-23 10:46caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5362#r5362
2014-01-23 19:04hgbotCheckin
2014-01-23 19:04hgbotNote Added: 0063665
2014-01-23 19:04hgbotStatusnew => resolved
2014-01-23 19:04hgbotResolutionopen => fixed
2014-01-23 19:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7ccc650e7c7e1bc7f602c6282214abca32af49cc [^]
2014-01-24 00:18VictorVillarReview Assigned To => VictorVillar
2014-01-24 00:18VictorVillarNote Added: 0063666
2014-01-24 00:18VictorVillarStatusresolved => closed
2014-02-12 18:29hudsonbotCheckin
2014-02-12 18:29hudsonbotNote Added: 0064110

Notes
(0063665)
hgbot   
2014-01-23 19:04   
Repository: erp/devel/pi
Changeset: 7ccc650e7c7e1bc7f602c6282214abca32af49cc
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Thu Jan 23 19:03:43 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7ccc650e7c7e1bc7f602c6282214abca32af49cc [^]

fixes issue 25541: Adds condition to the m_transaction_trg2 trigger

---
M src-db/database/model/triggers/M_TRANSACTION_TRG2.xml
---
(0063666)
VictorVillar   
2014-01-24 00:18   
Verified
(0064110)
hudsonbot   
2014-02-12 18:29   
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/d1a5bb862230 [^]
Maturity status: Test