Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013912Openbravo ERP07. Sales managementpublic2010-07-07 13:512012-06-28 08:02
Reporternetworkb 
Assigned Toharikrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP19 
Target Version2.50MP20Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013912: The process 'Create Lines from' of the Goods Shipment window shows incorrect data
DescriptionWhen we create a sales order (transaction document: Prepay Order) and then we create the good shipment if we go to Create Shipments from Orders it shows the order created as pending.
Steps To Reproduce- As Openbravo Admin go to Sales Management || Transactions || Sales Order
- Create a new record:
     - Transaction Document: Prepay Order
     - BP: McGiver
     - Invoice Terms: immediate
- Go to Lines:
     - Product: hammer
     - Ordered Quantity: 150
- Complete

- Go to Sales Management || Transactions || Goods Shipment
- Create a new record,(BP:McGiver) click 'Create Lines From'
- Select the invoice created and ok
- Complete
- Create a new record:
- Create a new record,(BP:McGiver) click 'Create Lines From'
- Realize that the invoice still appears, and you can select it and complete the good shipment without problems.
Proposed Solution
Additional Information
TagsRegression
Relationships
related to feature request 00134362.50MP19 closed adrianromero New extension point in shipments 
related to defect 00197833.0MP9 closed jecharri When running "Generate Receipt from Invoice" process, associated matched invoice entry is created twice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-07-07 13:51networkbNew Issue
2010-07-07 13:51networkbAssigned To => adrianromero
2010-07-08 13:41adrianromeroStatusnew => scheduled
2010-07-08 13:41adrianromerofix_in_branch => pi
2010-07-08 13:42adrianromeroRelationship addedrelated to 0013436
2010-07-08 13:42adrianromeroNote Added: 0029157
2010-07-21 12:22harikrishnanAssigned Toadrianromero => harikrishnan
2010-07-21 12:23hgbotCheckin
2010-07-21 12:23hgbotNote Added: 0029433
2010-07-21 12:23hgbotStatusscheduled => resolved
2010-07-21 12:23hgbotResolutionopen => fixed
2010-07-21 12:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/edda5328f260cb9556c0506ce4cf62c6eab8782c [^]
2010-07-21 12:23harikrishnanNote Added: 0029434
2010-07-22 08:08sureshbabuNote Added: 0029461
2010-07-22 08:08sureshbabuStatusresolved => closed
2010-07-23 00:00anonymoussf_bug_id0 => 3033267
2010-07-24 22:54hudsonbotCheckin
2010-07-24 22:54hudsonbotNote Added: 0029545
2012-02-21 17:15hgbotCheckin
2012-02-21 17:15hgbotNote Added: 0045319
2012-02-21 17:15hgbotCheckin
2012-02-21 17:15hgbotNote Added: 0045321
2012-02-24 09:14jecharriRelationship addedrelated to 0019783
2012-02-29 15:30jecharriTag Attached: Regression
2012-03-02 15:38hudsonbotCheckin
2012-03-02 15:38hudsonbotNote Added: 0045911
2012-03-02 15:38hudsonbotCheckin
2012-03-02 15:38hudsonbotNote Added: 0045914
2012-03-08 10:22jecharriNote Added: 0046181
2012-03-08 10:39hgbotCheckin
2012-03-08 10:39hgbotNote Added: 0046183
2012-06-27 20:23hgbotCheckin
2012-06-27 20:23hgbotNote Added: 0050204
2012-06-27 20:23hgbotCheckin
2012-06-27 20:23hgbotNote Added: 0050206
2012-06-27 20:25hgbotCheckin
2012-06-27 20:25hgbotNote Added: 0050209
2012-06-27 20:25hgbotCheckin
2012-06-27 20:25hgbotNote Added: 0050211
2012-06-28 08:01hudsonbotCheckin
2012-06-28 08:01hudsonbotNote Added: 0050230
2012-06-28 08:01hudsonbotCheckin
2012-06-28 08:01hudsonbotNote Added: 0050233
2012-06-28 08:02hudsonbotCheckin
2012-06-28 08:02hudsonbotNote Added: 0050235
2012-06-28 08:02hudsonbotCheckin
2012-06-28 08:02hudsonbotNote Added: 0050238

Notes
(0029157)
adrianromero   
2010-07-08 13:42   
This issue can be related to the new extension points created for the shipment flow
(0029433)
hgbot   
2010-07-21 12:23   
Repository: erp/devel/pi
Changeset: edda5328f260cb9556c0506ce4cf62c6eab8782c
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Jul 21 15:51:48 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/edda5328f260cb9556c0506ce4cf62c6eab8782c [^]

Fixes Issue 13912: The process 'Create Lines from' of the Goods Shipment window shows incorrect data.

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0029434)
harikrishnan   
2010-07-21 12:23   
Steps to Reproduce:

*Follow the steps to reproduce given in the issue.

Root cause:
*Before completing the shipment copied from the invoice ,the MatchInv table records are not inserted.

Impact:

*Their is no impact because of this issue.
(0029461)
sureshbabu   
2010-07-22 08:08   
verified..
(0029545)
hudsonbot   
2010-07-24 22:54   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/edda5328f260 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/eb739d47ff2b [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17900.obx [^]
(0045319)
hgbot   
2012-02-21 17:15   
Repository: erp/devel/pi
Changeset: ada3076fc7dd363a77c8904bfcc1608d7cc40e8d
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Feb 21 17:08:53 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ada3076fc7dd363a77c8904bfcc1608d7cc40e8d [^]

issue 13912,issue 19783: The process 'Create Lines from'
of the Goods Shipment window shows incorrect data

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
---
(0045321)
hgbot   
2012-02-21 17:15   
Repository: erp/devel/pi
Changeset: 33175c6c534f1874b078f7f290e4f4364ca15362
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Feb 21 17:14:13 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/33175c6c534f1874b078f7f290e4f4364ca15362 [^]

Fixes issue 19783: When running "Generate Receipt from Invoice" process,
associated matched invoice entry is created twice.
The problem was that to solve the issue 13912 it was created some code duplicated and it did not work properly. Now this code has been deleted and changed the combo query for proper behaviour

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0045911)
hudsonbot   
2012-03-02 15:38   
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/544d64e0c159 [^]

Maturity status: Test
(0045914)
hudsonbot   
2012-03-02 15:38   
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/544d64e0c159 [^]

Maturity status: Test
(0046181)
jecharri   
2012-03-08 10:22   
Test cases:
-reproduce the steps to reproduce
-create a simple sales invoice:
  - go to goods shipment and push in create lines from and verify that invoice appear
  -select the invoice and ok
  -push again in the create lines from and verify that it does not appear

-create an order and related invoice
  -go to goods shipment and verify that both appear
  -select the invoice and complete
  -verify that the order and the invoice are not more available
(0046183)
hgbot   
2012-03-08 10:39   
Repository: erp/stable/2.50
Changeset: f619f50ded07e3450de6a735be85e2a6ecb82d2a
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Mar 08 10:38:35 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/f619f50ded07e3450de6a735be85e2a6ecb82d2a [^]

Fixes issue 19862, issue 13912:
When running "Generate Receipt from Invoice" process, associated matched invoice entry is created twice.
The process 'Create Lines from' of the Goods Shipment window shows incorrect data.
The problem was that to solve the issue 13912 it was created some code duplicated and it did not work properly. Now this code has been deleted and changed the combo query for proper behaviour.
Added the module script to delete the duplicated lines in m_matchinv table. Also, the lines with related m_inout or c_invoiceline that are sales.

---
M src-db/database/model/functions/M_INOUT_POST.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
A src-util/modulescript/build/classes/org/openbravo/modulescript/DeleteDuplicateMatchInvoice.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/DeleteDuplicateMatchInvoiceData.class
A src-util/modulescript/src/org/openbravo/modulescript/DeleteDuplicateMatchInvoice.java
A src-util/modulescript/src/org/openbravo/modulescript/DeleteDuplicateMatchInvoice_data.xsql
---
(0050204)
hgbot   
2012-06-27 20:23   
Repository: erp/devel/pi
Changeset: 462253717b32abf3829512e2aae52703bb4f0b59
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Feb 21 17:08:53 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/462253717b32abf3829512e2aae52703bb4f0b59 [^]

issue 13912,issue 19783: The process 'Create Lines from'
of the Goods Shipment window shows incorrect data

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
---
(0050206)
hgbot   
2012-06-27 20:23   
Repository: erp/devel/pi
Changeset: b76249577bb8801a74d3c39073add669978f66dd
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Feb 21 17:14:13 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/b76249577bb8801a74d3c39073add669978f66dd [^]

Fixes issue 19783: When running "Generate Receipt from Invoice" process,
associated matched invoice entry is created twice.
The problem was that to solve the issue 13912 it was created some code duplicated and it did not work properly. Now this code has been deleted and changed the combo query for proper behaviour

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0050209)
hgbot   
2012-06-27 20:25   
Repository: erp/devel/pi
Changeset: fe80bdb44fce453bfed9bce64306a8c0b2a42bdd
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Feb 21 17:08:53 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fe80bdb44fce453bfed9bce64306a8c0b2a42bdd [^]

issue 13912,issue 19783: The process 'Create Lines from'
of the Goods Shipment window shows incorrect data

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Shipment_data.xsql
---
(0050211)
hgbot   
2012-06-27 20:25   
Repository: erp/devel/pi
Changeset: 2d6bf11fbb96b655cc0a5f4615138fe069538adc
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Feb 21 17:14:13 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2d6bf11fbb96b655cc0a5f4615138fe069538adc [^]

Fixes issue 19783: When running "Generate Receipt from Invoice" process,
associated matched invoice entry is created twice.
The problem was that to solve the issue 13912 it was created some code duplicated and it did not work properly. Now this code has been deleted and changed the combo query for proper behaviour

---
M src-db/database/model/functions/M_INOUT_POST.xml
---
(0050230)
hudsonbot   
2012-06-28 08:01   
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/c66e853c5cf4 [^]

Maturity status: Test
(0050233)
hudsonbot   
2012-06-28 08:01   
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/c66e853c5cf4 [^]

Maturity status: Test
(0050235)
hudsonbot   
2012-06-28 08:02   
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/c66e853c5cf4 [^]

Maturity status: Test
(0050238)
hudsonbot   
2012-06-28 08:02   
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/c66e853c5cf4 [^]

Maturity status: Test