Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012787
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2010-03-24 11:082010-05-18 21:43
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisiond199c75c4508
ProjectionnoneETAnoneTarget Version2.50MP17
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP13SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012787: 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.
TagsNo tags attached.
Attached Filespdf file icon ReportShipmentEdition.jrxml.pdf [^] (3,275 bytes) 2010-03-24 11:08

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0025839)
adrianromero (manager)
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 (developer)
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 (manager)
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 (reporter)
2010-05-12 08:51

Tested Working fine
(0027488)
hudsonbot (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-03-24 11:08 networkb New Issue
2010-03-24 11:08 networkb Assigned To => adrianromero
2010-03-24 11:08 networkb File Added: ReportShipmentEdition.jrxml.pdf
2010-03-31 16:49 adrianromero Status new => scheduled
2010-03-31 16:49 adrianromero Note Added: 0025839
2010-03-31 16:49 adrianromero fix_in_branch => pi
2010-05-06 17:03 hgbot Checkin
2010-05-06 17:03 hgbot Note Added: 0026995
2010-05-06 17:03 hgbot Status scheduled => resolved
2010-05-06 17:03 hgbot Resolution open => fixed
2010-05-06 17:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d199c75c450822485cf49e8cd5c3bd498b6e1b06 [^]
2010-05-06 17:06 adrianromero Note Added: 0026996
2010-05-11 18:19 jpabloae Target Version 2.50MP16 => 2.50MP17
2010-05-12 08:51 arunkumar Note Added: 0027156
2010-05-12 08:51 arunkumar Status resolved => closed
2010-05-13 00:00 anonymous sf_bug_id 0 => 3000768
2010-05-18 21:43 hudsonbot Checkin
2010-05-18 21:43 hudsonbot Note Added: 0027488


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker