Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023008Openbravo ERP07. Sales managementpublic2013-02-07 13:502013-03-05 09:30
Reporternaiaramartinez 
Assigned Tonaiaramartinez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket19518
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023008: Not working correctly when processing an order that has a not stocked BOM product
DescriptionWhen an order, with a product that is BOM and is not stocked, is processed that product is deleted and products containing in BOM tab are shown. This is not the correct functionality.

You should be able to explode all BOM products not stocked before processing the order. So, a 'Explode' button should appear when a line containing not stocked BOM product is selected.

When processing the order, all its not stocked BOM product should be exploded.

When reactivating the order the BOM product should not be comprimed. They should be exploded.

A new column should be added to the lines, to know if a product depends on other product. That could be useful for reporting.

The same thing should happend in shipments and invoices.
Steps To ReproduceGo to product a window.
Select 'Cerveza Ale 0.5L' and modify:
   * stocked=no
   * Bill of Materials= yes
Go to Bill of material tab and add two products, for example, 'Agua sin Gas 1L' and 'Bebida Energética 0,5L'.

Go to sales order window and create a new header for 'Alimentos y Supermercados, S.A'.
Create a new line with 'Cerveza Ale 0,5L' product. Process the Sales order. Notice that 'Cerveza Ale 0.5L' product has dissapeared and the products inserted in 'Bill of Materials' tab have been inserted.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0032205 closed collazoandy4 Deleting a line on the order line window takes long on environment with big amount of data 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-07 13:50naiaramartinezNew Issue
2013-02-07 13:50naiaramartinezAssigned To => dmiguelez
2013-02-07 13:50naiaramartinezModules => Core
2013-02-07 13:50naiaramartinezOBNetwork customer => No
2013-02-07 13:50naiaramartinezTriggers an Emergency Pack => No
2013-02-07 13:50naiaramartinezAssigned Todmiguelez => naiaramartinez
2013-02-11 09:11naiaramartinezSummaryNot working correctly when processing a SO that has a not stocked BOM product => Not working correctly when processing an order that has a not stocked BOM product
2013-02-11 09:11naiaramartinezDescription Updatedbug_revision_view_page.php?rev_id=4385#r4385
2013-02-11 12:20VictorVillarIssue Monitored: networkb
2013-02-11 12:34VictorVillarOBNetwork customerNo => Yes
2013-02-11 12:34VictorVillarSupport ticket => 19518
2013-02-27 17:04naiaramartinezDescription Updatedbug_revision_view_page.php?rev_id=4458#r4458
2013-03-01 08:49hgbotCheckin
2013-03-01 08:49hgbotNote Added: 0056873
2013-03-01 08:49hgbotStatusnew => resolved
2013-03-01 08:49hgbotResolutionopen => fixed
2013-03-01 08:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2e4dccb63f7deda22859050a68fa4ab9503d6077 [^]
2013-03-01 08:49hgbotCheckin
2013-03-01 08:49hgbotNote Added: 0056874
2013-03-02 05:48hudsonbotCheckin
2013-03-02 05:48hudsonbotNote Added: 0056936
2013-03-02 05:48hudsonbotCheckin
2013-03-02 05:48hudsonbotNote Added: 0056937
2013-03-04 08:49SandrahuguetNote Added: 0056953
2013-03-04 08:50SandrahuguetReview Assigned To => Sandrahuguet
2013-03-04 08:50SandrahuguetStatusresolved => closed
2013-03-04 08:56SandrahuguetStatusclosed => new
2013-03-04 08:56SandrahuguetResolutionfixed => open
2013-03-04 08:56SandrahuguetNote Deleted: 0056953
2013-03-04 08:58naiaramartinezStatusnew => scheduled
2013-03-04 08:58naiaramartinezfix_in_branch => pi
2013-03-04 08:58naiaramartinezStatusscheduled => resolved
2013-03-04 08:58naiaramartinezResolutionopen => fixed
2013-03-04 09:56hgbotCheckin
2013-03-04 09:56hgbotNote Added: 0056956
2013-03-04 10:45VictorVillarReview Assigned ToSandrahuguet => VictorVillar
2013-03-04 10:45VictorVillarNote Added: 0056961
2013-03-04 10:45VictorVillarStatusresolved => closed
2013-03-05 09:30hudsonbotCheckin
2013-03-05 09:30hudsonbotNote Added: 0057019
2016-02-12 10:27vmromanosRelationship addedcauses 0032205

Notes
(0056873)
hgbot   
2013-03-01 08:49   
Repository: erp/devel/pi
Changeset: 2e4dccb63f7deda22859050a68fa4ab9503d6077
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Wed Feb 27 17:16:35 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2e4dccb63f7deda22859050a68fa4ab9503d6077 [^]

fixed bug 23008: Bom non-stocked is not working correctly

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/model/functions/M_INOUT_CREATE.xml
M src-db/database/model/functions/M_INOUT_POST.xml
M src-db/database/model/tables/C_INVOICELINE.xml
M src-db/database/model/tables/C_ORDERLINE.xml
M src-db/database/model/tables/M_INOUTLINE.xml
M src-db/database/sourcedata/AD_AUXILIARINPUT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_TAB.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice.html
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment.html
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_ShipmentPO.html
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_ShipmentPO.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
A src-db/database/model/functions/M_EXPLODEBOMNOTSTOCK.xml
A src-db/database/model/functions/M_INOUTEXPLODEBOMNOTSTOCK.xml
A src-db/database/model/functions/M_INVEXPLODEBOMNOTSTOCK.xml
---
(0056874)
hgbot   
2013-03-01 08:49   
Repository: erp/devel/pi
Changeset: 4446edd73038fef18ecd8fdde8ff7b40eb77363b
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Thu Feb 28 10:45:08 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/4446edd73038fef18ecd8fdde8ff7b40eb77363b [^]

Related to issue 23008: add ad_elements

---
M src-db/database/model/functions/M_INVEXPLODEBOMNOTSTOCK.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---
(0056936)
hudsonbot   
2013-03-02 05:48   
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/f5db629e7058 [^]

Maturity status: Test
(0056937)
hudsonbot   
2013-03-02 05:48   
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/f5db629e7058 [^]

Maturity status: Test
(0056956)
hgbot   
2013-03-04 09:56   
Repository: erp/devel/pi
Changeset: b89b81a6f0f9a480aeb5816efca50942bc2289c1
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Mar 04 09:55:23 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b89b81a6f0f9a480aeb5816efca50942bc2289c1 [^]

Related to issue 23008: fix 'Column AS alias' to work in pgsql 8.3

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
---
(0056961)
VictorVillar   
2013-03-04 10:45   
Verified
(0057019)
hudsonbot   
2013-03-05 09:30   
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/e5bdfce74ee2 [^]

Maturity status: Test