Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012787Openbravo ERP07. Sales managementpublic2010-03-24 11:082010-05-18 21:43
Reporternetworkb 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP13 
Target Version2.50MP17Fixed 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
Summary0012787: Error in Shipment Report
DescriptionThe Shipment Report does not group properly.

File attached.
Steps To Reproduce- Go to Sales Management || Transactions || Goods Shipment
-Create a new record:
    - Bussines Partner: McGiver.
- Save and go to lines:
    - Hammer
    - Donuts
    - Marble
    - Screwdriver
- Save and complete.

-Create a new record:
    - Business Partner: McGiver.
- Save and go to lines:
    - Hammer
    - Shirts
    - Paint
-Save and complete
-Go to Sales Management || Analysis Tools || Shipment Report
    -Business Partner: McGiver
    -From date: Today
-See the file attached.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespdf ReportShipmentEdition.jrxml.pdf (3,275) 2010-03-24 11:08
https://issues.openbravo.com/file_download.php?file_id=2375&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-03-24 11:08networkbNew Issue
2010-03-24 11:08networkbAssigned To => adrianromero
2010-03-24 11:08networkbFile Added: ReportShipmentEdition.jrxml.pdf
2010-03-31 16:49adrianromeroStatusnew => scheduled
2010-03-31 16:49adrianromeroNote Added: 0025839
2010-03-31 16:49adrianromerofix_in_branch => pi
2010-05-06 17:03hgbotCheckin
2010-05-06 17:03hgbotNote Added: 0026995
2010-05-06 17:03hgbotStatusscheduled => resolved
2010-05-06 17:03hgbotResolutionopen => fixed
2010-05-06 17:03hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d199c75c450822485cf49e8cd5c3bd498b6e1b06 [^]
2010-05-06 17:06adrianromeroNote Added: 0026996
2010-05-11 18:19jpabloaeTarget Version2.50MP16 => 2.50MP17
2010-05-12 08:51arunkumarNote Added: 0027156
2010-05-12 08:51arunkumarStatusresolved => closed
2010-05-13 00:00anonymoussf_bug_id0 => 3000768
2010-05-18 21:43hudsonbotCheckin
2010-05-18 21:43hudsonbotNote Added: 0027488

Notes
(0025839)
adrianromero   
2010-03-31 16:49   
Probably the fix consist in modifying the 'ORDER BY' clause in the SQL sentence to allow the report engine group consistently.
(0026995)
hgbot   
2010-05-06 17:03   
Repository: erp/devel/pi
Changeset: d199c75c450822485cf49e8cd5c3bd498b6e1b06
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu May 06 17:02:57 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d199c75c450822485cf49e8cd5c3bd498b6e1b06 [^]

Fixes issue 0012787: Error in Shipment Report

---
M src/org/openbravo/erpCommon/ad_reports/InoutEdition_data.xsql
---
(0026996)
adrianromero   
2010-05-06 17:06   
* Steps to test
Just follow the steps to reproduce and notice that in the report all shipments documents appear properly grouped listing all the shipment lines

* Explanation of the changeset
It just has been added to the ORDER BY section of the SQL sentence of the report the field DOCUMENTNO to allow the report engine group consistently.

* Other areas affected.
It has been modified only the SQL sentence of this report. There is no other area impacted.
(0027156)
arunkumar   
2010-05-12 08:51   
Tested Working fine
(0027488)
hudsonbot   
2010-05-18 21:43   
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/d199c75c4508 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]