Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029201Openbravo ERP07. Sales managementpublic2015-03-09 12:462015-05-14 17:49
Reporternaiaramartinez 
Assigned Tonaiaramartinez 
PrioritynormalSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q3 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029201: Modify 'generate invoices' process to add the posibility to include SO with different orgs in one or more SI with a parent org
DescriptionA new parameter have been added to 'Generate Invoice' process to take into account Child Orgs: 'Include Child Orgs'. When Sales Orders have the invoice rule 'Customer Scheduler After Delivery' and the new parameter is selected, a SI with a parent organization is created including pending SO for its child organizations. For 'After Delivery' Invoice Terms several SI will be created all of them for the parent Organization
Steps To ReproduceCreate a Business Partner:
   Org: *
   Search Key: A
   Name: CustomerA
   customer: yes
   Price List: Tarifa de ventas
   Payment Method: transferencia
   Payment Terms: 120 days
   Financial Account: Cuenta de Banco
   Invoice Terms: Customer Schedule After Delivery
   Invoice Schedule: Monthly 1st

Go to Location/Address tab
   Add a location:
     City: Pamplona
     Region: Navarra
     Country: Spain


Create SO:
   Org: Region Norte
   order date: 01-02-2015
   Schedules Delivery Date: 01-02-2015
   Business Partner : CustA
   Create line:
      Product: Vino Rosado
      Qty: 1
   Book

Create SO:
   Org: Region Sur
   order date: 01-02-2015
   Schedules Delivery Date: 01-02-2015
   Business Partner : CustA
   Create line:
      Product: Cola 0.5L
      Qty: 1
   Book

Create Goods Shipment:
   Org: Region Norte
   movement date: 01-02-2015
   Business Partner : CustA
   Create lines from. Select previously created SO line
   Complete the Goods Shipment

Create Goods Shipment:
   Org: Region Sur
   movement date: 01-02-2015
   Business Partner : CustA
   Create lines from. Select previously created SO line
   Complete the Goods Shipment

Execute 'Generate Invoices' process and in the popup select:
   Org: F&B España, S.A
   Include Child Org: Yes
   business Partner: CustA
   

Click OK. Notice that one invoice is created with Org 'F&B España, S.A' including the SO generated for organization 'Region Sur' and 'Region Norte'.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0033375 closed Sanjota Error! tag shown instead of Organization in Initial Organization Setup success message 
Attached Files? 29201.export (12,883) 2015-04-30 13:34
https://issues.openbravo.com/file_download.php?file_id=8041&type=bug
Issue History
Date ModifiedUsernameFieldChange
2015-03-09 12:46naiaramartinezNew Issue
2015-03-09 12:46naiaramartinezAssigned To => naiaramartinez
2015-03-09 12:46naiaramartinezOBNetwork customer => No
2015-03-09 12:46naiaramartinezModules => Core
2015-03-09 12:46naiaramartinezTriggers an Emergency Pack => No
2015-03-09 16:52hgbotCheckin
2015-03-09 16:52hgbotNote Added: 0075323
2015-03-09 16:52hgbotStatusnew => resolved
2015-03-09 16:52hgbotResolutionopen => fixed
2015-03-09 16:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e0b75e9e0dfc2641eb1d701251aefeeb3f1d31ed [^]
2015-03-09 16:52hgbotCheckin
2015-03-09 16:52hgbotNote Added: 0075324
2015-03-10 04:27hudsonbotCheckin
2015-03-10 04:27hudsonbotNote Added: 0075356
2015-03-10 13:48naiaramartinezDescription Updatedbug_revision_view_page.php?rev_id=7914#r7914
2015-03-13 14:36hgbotCheckin
2015-03-13 14:36hgbotNote Added: 0075565
2015-03-13 14:37hgbotCheckin
2015-03-13 14:37hgbotNote Added: 0075566
2015-03-13 14:47naiaramartinezStatusresolved => new
2015-03-16 15:57hudsonbotCheckin
2015-03-16 15:57hudsonbotNote Added: 0075630
2015-04-30 13:34naiaramartinezFile Added: 29201.export
2015-05-05 12:06hgbotCheckin
2015-05-05 12:06hgbotNote Added: 0076998
2015-05-05 12:06hgbotCheckin
2015-05-05 12:06hgbotNote Added: 0076999
2015-05-05 12:06hgbotStatusnew => resolved
2015-05-05 12:06hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/e0b75e9e0dfc2641eb1d701251aefeeb3f1d31ed [^] => http://code.openbravo.com/erp/devel/pi/rev/7ff556c65e0bf18d5b9a8d8583e256b0518c65c4 [^]
2015-05-06 18:33SandrahuguetReview Assigned To => Sandrahuguet
2015-05-07 09:58hgbotCheckin
2015-05-07 09:58hgbotNote Added: 0077068
2015-05-07 10:15SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8468#r8468
2015-05-07 22:17hudsonbotCheckin
2015-05-07 22:17hudsonbotNote Added: 0077212
2015-05-11 10:37dmiguelezSummaryModify 'generate invoices' process to add the posibility to group SO with different orgs in a unique SI with a parent org => Modify 'generate invoices' process to add the posibility to include SO with different orgs in one or more SI with a parent org
2015-05-11 10:37dmiguelezDescription Updatedbug_revision_view_page.php?rev_id=8498#r8498
2015-05-13 08:49SandrahuguetReview Assigned ToSandrahuguet => dmiguelez
2015-05-13 18:16hgbotCheckin
2015-05-13 18:16hgbotNote Added: 0077415
2015-05-14 10:56hgbotCheckin
2015-05-14 10:56hgbotNote Added: 0077429
2015-05-14 17:15dmiguelezNote Added: 0077454
2015-05-14 17:15dmiguelezStatusresolved => closed
2015-05-14 17:15dmiguelezFixed in Version => 3.0PR15Q3
2015-05-14 17:48hudsonbotCheckin
2015-05-14 17:48hudsonbotNote Added: 0077462
2015-05-14 17:49hudsonbotCheckin
2015-05-14 17:49hudsonbotNote Added: 0077467
2016-06-29 18:28aferrazRelationship addedcauses 0033375

Notes
(0075323)
hgbot   
2015-03-09 16:52   
Repository: erp/devel/pi
Changeset: e0b75e9e0dfc2641eb1d701251aefeeb3f1d31ed
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Mar 09 16:51:31 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e0b75e9e0dfc2641eb1d701251aefeeb3f1d31ed [^]

fixed issue 29201: Modify 'generate invoices' process to add the posibility to group SO with different orgs in a unique SI with a parent org.

New parameter 'Include child orgs' is added in the 'generate invoice' process, to group pending
Sales Order into one Sales Invoice with parent org.

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0075324)
hgbot   
2015-03-09 16:52   
Repository: erp/devel/api-checks
Changeset: 9ddbe2673244a3b7792fabeadb6e9453639926db
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Mar 09 16:35:09 2015 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/9ddbe2673244a3b7792fabeadb6e9453639926db [^]

False positive due to adding a new param to 'generate invoice' process (issue 29201)
A default value exist in the PL, so even the param does not exist in the database, the process will work.

---
M model/src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0075356)
hudsonbot   
2015-03-10 04:27   
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/2d6fd0550445 [^]
Maturity status: Test
(0075565)
hgbot   
2015-03-13 14:36   
Repository: erp/devel/pi
Changeset: 1ab24bb1a8cb87220c994f4201335c85d7c85238
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri Mar 13 14:32:45 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/1ab24bb1a8cb87220c994f4201335c85d7c85238 [^]

Related to issue 29201: reveting the commit. This change should be included in q3 (not in q2)

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0075566)
hgbot   
2015-03-13 14:37   
Repository: erp/devel/api-checks
Changeset: b623caa77c1c0b8ac0d8a56d24aae1afdc546c46
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Fri Mar 13 14:35:28 2015 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/b623caa77c1c0b8ac0d8a56d24aae1afdc546c46 [^]

The change for issue 29201 has been reverted, and this api change must be reverted

---
M model/src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0075630)
hudsonbot   
2015-03-16 15:57   
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/30bc648fab8b [^]
Maturity status: Test
(0076998)
hgbot   
2015-05-05 12:06   
Repository: erp/devel/api-checks
Changeset: fc09650b68719d29d5bff28c8e53399e613d3515
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Tue May 05 12:03:51 2015 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/fc09650b68719d29d5bff28c8e53399e613d3515 [^]

False positive due to adding a new param to 'generate invoice' process (issue 29201)
A default value exist in the PL, so even the param does not exist in the database, the process will work.

---
M model/src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0076999)
hgbot   
2015-05-05 12:06   
Repository: erp/devel/pi
Changeset: 7ff556c65e0bf18d5b9a8d8583e256b0518c65c4
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Mon Mar 09 16:51:31 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7ff556c65e0bf18d5b9a8d8583e256b0518c65c4 [^]

fixed issue 29201: Modify 'generate invoices' process to add the posibility to group SO with different orgs in a unique SI with a parent org.

New parameter 'Include child orgs' is added in the 'generate invoice' process, to group pending
Sales Order into one Sales Invoice with parent org.

---
M src-db/database/model/functions/C_INVOICE_CREATE.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0077068)
hgbot   
2015-05-07 09:58   
Repository: erp/devel/api-checks
Changeset: 80a0307389e814f8d9acbcb90f16790ab73ebb27
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Thu May 07 09:57:13 2015 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/80a0307389e814f8d9acbcb90f16790ab73ebb27 [^]

False positive due to adding a new param to 'generate invoice' process (issue 29201)
A default value exist in the PL, so even the param does not exist in the database, the process will work.

---
M model/src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0077212)
hudsonbot   
2015-05-07 22:17   
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/a1817f84bd8b [^]
Maturity status: Test
(0077415)
hgbot   
2015-05-13 18:16   
Repository: erp/devel/pi
Changeset: b472e70812ecf8a2abab051801e75f04093fb22a
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed May 13 18:15:58 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b472e70812ecf8a2abab051801e75f04093fb22a [^]

Related to Issue 29201. Changes description of Process Generate Invoices
and Label of Organization Parameter

---
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0077429)
hgbot   
2015-05-14 10:56   
Repository: erp/devel/pi
Changeset: 135a4a43d546c248275fb507c5748b4c8b5a514e
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu May 14 10:55:38 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/135a4a43d546c248275fb507c5748b4c8b5a514e [^]

Related to Issue 29201. Fixes dbcons problem.

---
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0077454)
dmiguelez   
2015-05-14 17:15   
Code Review + Testing Ok
(0077462)
hudsonbot   
2015-05-14 17: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/3375171dd310 [^]
Maturity status: Test
(0077467)
hudsonbot   
2015-05-14 17:49   
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/3375171dd310 [^]
Maturity status: Test