Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032938Openbravo ERP07. Sales managementpublic2016-05-12 09:582016-06-20 12:38
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR16Q3 
Merge Request Status
Review Assigned Toaferraz
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0032938: It is necessary a script to add the 1-1 relation between sales invoice line and goods shipment line
DescriptionIt is necessary a script to add the 1-1 relation between sales invoice line and goods shipment line. This association should not be done when there are more than one good shipment lines associated with the same invoice line
Steps To ReproduceAs group admin role:
   Launch the Sales Invoice Dimensional Report
   Add the Product and DocumentNo dimension
   Check that a cost of 0 is shown for the sales invoice lines with the goods shipment line empty
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0024355 closed AtulOpenbravo Openbravo ERP "Good Shipment Line" field information is not filled when creating POS Order with Invoice Terms=Immediate 
related to defect 0028685pi closed reinaldoguerra Openbravo ERP Goods shipment and invoice relationship not created when launching "Create shipments from orders" form. 
related to defect 0024147RMP25 closed marvintm Retail Modules Goods Shipment Line field not filled in Sales Invoice Lines 
related to defect 0032670 closed collazoandy4 Openbravo ERP "Good Shipment Line" field information is not filled in Sales Invoice Line when processing On Credit Order 
related to defect 0032709 closed AtulOpenbravo Openbravo ERP Sales Invoice - Invoice Term=Immediate does not create link to Good Shipment in Sales Invoice 
related to design defect 0033042 new Triage Omni OMS Openbravo ERP Partially shipped Goods Shipment Line is linked to completely invoiced Sales Invoice Line 
related to design defect 0032061 new Triage Omni OMS Openbravo ERP No "Cost" information shown in Sales Invoice Dimensional Report in case there is no 1 to 1 relation between SO line and GS line 
Attached Files? 32938.sql (1,034) 2016-06-20 12:38
https://issues.openbravo.com/file_download.php?file_id=9560&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-05-12 09:58ngarciaNew Issue
2016-05-12 09:58ngarciaAssigned To => Triage Finance
2016-05-12 09:58ngarciaModules => Core
2016-05-12 09:58ngarciaResolution time => 1466287200
2016-05-12 09:58ngarciaTriggers an Emergency Pack => No
2016-05-12 10:00ngarciaIssue Monitored: networkb
2016-05-12 10:00ngarciaRelationship addedrelated to 0024355
2016-05-12 10:00ngarciaRelationship addedrelated to 0028685
2016-05-12 10:00ngarciaRelationship addedrelated to 0024147
2016-05-12 10:01ngarciaRelationship addeddepends on 0032670
2016-05-12 10:01ngarciaRelationship addeddepends on 0032709
2016-05-12 10:01ngarciaRelationship deleteddepends on 0032670
2016-05-12 10:01ngarciaRelationship deleteddepends on 0032709
2016-05-12 10:02ngarciaRelationship addedrelated to 0032670
2016-05-12 10:02ngarciaRelationship addedrelated to 0032709
2016-05-12 11:43aferrazAssigned ToTriage Finance => AtulOpenbravo
2016-05-12 14:21heccamIssue Monitored: heccam
2016-05-27 10:32yogaskarnikIssue Monitored: yogaskarnik
2016-05-31 08:53AtulOpenbravoStatusnew => scheduled
2016-05-31 10:28aferrazRelationship addedrelated to 0033042
2016-06-15 17:07aferrazFile Added: 32938.sql
2016-06-15 17:09aferrazReview Assigned To => aferraz
2016-06-15 17:09aferrazNote Added: 0087312
2016-06-15 17:09aferrazStatusscheduled => closed
2016-06-15 17:09aferrazResolutionopen => fixed
2016-06-15 17:09aferrazFixed in Version => 3.0PR16Q3
2016-06-20 12:37aferrazFile Deleted: 32938.sql
2016-06-20 12:38aferrazFile Added: 32938.sql
2016-10-17 12:51ngarciaRelationship addedrelated to 0032061

Notes
(0087312)
aferraz   
2016-06-15 17:09   
Attached query to fix data