Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0032938Openbravo ERP07. Sales managementpublic2016-05-12 09:582016-06-20 12:38
ngarcia 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
 
3.0PR16Q3 
aferraz
Core
No
0032938: It is necessary a script to add the 1-1 relation between sales invoice line and goods shipment line
It 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
As 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
No tags attached.
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 Finance Openbravo ERP Partially shipped Goods Shipment Line is linked to completely invoiced Sales Invoice Line 
related to design defect 0032061 new Triage Finance 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 
? 32938.sql (1,034) 2016-06-20 12:38
https://issues.openbravo.com/file_download.php?file_id=9560&type=bug
Issue History
2016-05-12 09:58ngarciaNew Issue
2016-05-12 09:58ngarciaAssigned To => Triage Finance
2016-05-12 09:58ngarciaModules => Core
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