Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019278Openbravo ERP07. Sales managementpublic2011-12-12 10:342012-01-30 17:55
Reporterjecharri 
Assigned Tojecharri 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP8Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019278: Error with parcial "Goods Shipments" and Invoices
DescriptionError with parcial "Goods Shipments" and Invoices.
When you have a "Good Shipment" that it is covering partially a "sales Order" and after that you want to create a "Sales invoice", you only can create the invoice from the "good shipment" and not from the order.

To understand, it is better to do the "steps to reproduce".
Steps To ReproduceAs "Group Admin" go to "Sales Order" window:
-Create one "Sales order":
    + Header --> "Ivoice Terms": "After Order Delivered" and BP=("Alimentos y Supermercados, S.A.")
    + In tab line --> Choose product "Agua con Gras 1L" and put "Ordered quantity"=6
-"Book" it.

Go to window "Goods Shipment":
-Create a header for the same "Business Partner" and push in "Create Lines From":
    + Select the previos order and choose the lines
    + Change the quantity from "6" to "4"
-Complete it.

Now, go to window "Sales invoice" and create a "Header" for the same "Busieness Partner".
-push in "Create Lines From":
   + in this pop-up, you will see that you can choose the "Good Shipment" but not the "order". This is wrong, you will not be able to select the shipment if it is not completely covered.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00192792.50MP39 closed jecharri Error with parcial "Goods Shipments" and Invoices 
related to defect 0019858 closed jecharri The "Goods Shipment" selector it doesn't work properly 
related to defect 0034205 closed AtulOpenbravo View c_invoice_candidate_v has performance problem when having lots of unpaid invoices 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-12-12 10:34jecharriNew Issue
2011-12-12 10:34jecharriAssigned To => jonalegriaesarte
2011-12-12 10:34jecharriWeb browser => Google Chrome
2011-12-12 10:34jecharriModules => Core
2011-12-12 10:34jecharriResolution time => 1330470000
2011-12-12 10:34jecharriStatusnew => scheduled
2011-12-12 10:34jecharrifix_in_branch => pi
2012-01-16 13:24jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-01-17 13:31hgbotCheckin
2012-01-17 13:31hgbotNote Added: 0044426
2012-01-17 13:31hgbotStatusscheduled => resolved
2012-01-17 13:31hgbotResolutionopen => fixed
2012-01-17 13:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/65dffb0597a83f6878c530056302270da33596c1 [^]
2012-01-17 15:47hgbotCheckin
2012-01-17 15:47hgbotNote Added: 0044427
2012-01-18 14:22hudsonbotCheckin
2012-01-18 14:22hudsonbotNote Added: 0044438
2012-01-18 14:22hudsonbotCheckin
2012-01-18 14:22hudsonbotNote Added: 0044439
2012-01-30 17:55xabiermerinoNote Added: 0044711
2012-01-30 17:55xabiermerinoStatusresolved => closed
2012-02-23 22:12jecharriRelationship addedrelated to 0019858
2016-12-02 09:49aferrazRelationship addedrelated to 0034205

Notes
(0044426)
hgbot   
2012-01-17 13:31   
Repository: erp/devel/pi
Changeset: 65dffb0597a83f6878c530056302270da33596c1
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Jan 17 13:30:39 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/65dffb0597a83f6878c530056302270da33596c1 [^]

Fixes issue 19278: Error with parcial "Goods Shipments" and Invoices.
Now the shipments don't appear until the order has been delivered completely

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
(0044427)
hgbot   
2012-01-17 15:47   
Repository: erp/devel/pi
Changeset: 30a7643fa5b04108bd7a3aa9312dd3c762df9d62
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Jan 17 15:35:03 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/30a7643fa5b04108bd7a3aa9312dd3c762df9d62 [^]

issue 19278: Error with parcial "Goods Shipments" and Invoices.
The previous query fails in Oracle

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql
---
(0044438)
hudsonbot   
2012-01-18 14:22   
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/0035a0985219 [^]

Maturity status: Test
(0044439)
hudsonbot   
2012-01-18 14:22   
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/0035a0985219 [^]

Maturity status: Test
(0044711)
xabiermerino   
2012-01-30 17:55   
verified