Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015287Openbravo ERPZ. Otherspublic2010-11-24 18:312010-12-22 00:00
Reporternetworkb 
Assigned Toadrianromero 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesOrders Awaiting Delivery
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015287: Report Orders Awaiting Delivery
DescriptionThe report does not print all the lines belonging to a certain sales order. Specifically, when the sales order has two lines with the same product and amount, the report only prints one.
Steps To Reproduce1) Install the module and create a sales order with 4 lines: the first one with product Grand Beer and 2 units. The second again with Grand Beer and 2 units. The third with Boots and 3 units. Finally the fourth with again Grand Beer but 1 unit.

2) Complete the Sales Order

3) Execute the report "Orders awaiting delivery" and see that it only shows 3 lines for that sales order:
-Grand Beer 1 unit
-Grand Beer 2 units
-Boots 3 units

*So it is missing one line of Grand Beer 2 units.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0015117 closed adrianromero Modules Some spanish labels are too long for the field 
depends on defect 0015118 closed adrianromero Modules Use of capital letters should be homogeneous 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-11-24 18:31networkbNew Issue
2010-11-24 18:31networkbAssigned To => rafaroda
2010-11-24 18:31networkbOBNetwork customer => Yes
2010-11-24 18:32networkbIssue Monitored: emartinez
2010-11-24 18:34rafarodaAssigned Torafaroda => adrianromero
2010-11-24 18:34rafarodaIssue Monitored: rafaroda
2010-12-21 16:22adrianromeroRelationship addedrelated to 0015117
2010-12-21 16:23adrianromeroRelationship addeddepends on 0015118
2010-12-21 17:22hgbotCheckin
2010-12-21 17:22hgbotNote Added: 0033350
2010-12-21 17:22hgbotStatusnew => resolved
2010-12-21 17:22hgbotResolutionopen => fixed
2010-12-21 17:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/mods/org.openbravo.reports.ordersawaitingdelivery/rev/9544cb138ae5e50afc7e7c342a785cf5925ae1a8 [^]
2010-12-21 17:37adrianromeroNote Added: 0033352
2010-12-21 17:38adrianromeroNote Added: 0033353
2010-12-21 17:38adrianromeroStatusresolved => closed
2010-12-21 17:39adrianromeroNote Added: 0033354
2010-12-22 00:00anonymoussf_bug_id0 => 3141453

Notes
(0033350)
hgbot   
2010-12-21 17:22   
Repository: erp/mods/org.openbravo.reports.ordersawaitingdelivery
Changeset: 9544cb138ae5e50afc7e7c342a785cf5925ae1a8
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Tue Dec 21 17:21:35 2010 +0100
URL: http://code.openbravo.com/erp/mods/org.openbravo.reports.ordersawaitingdelivery/rev/9544cb138ae5e50afc7e7c342a785cf5925ae1a8 [^]

Fixes issue 0015287: Report Orders Awaiting Delivery
It has been added a new field in the group clause to show all the records

---
M src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped_data.xsql
---
(0033352)
adrianromero   
2010-12-21 17:37   
* Testing the issue

Follow the steps to reproduce and verify that now 4 lines appear in the report. It must be tested in both database engines: Oracle and Postgresql.

* Other areas affected

Only the sentence SQL that retrieves the data has been modified. No other area affected.
(0033353)
adrianromero   
2010-12-21 17:38   
Tested and working fine.
(0033354)
adrianromero   
2010-12-21 17:39   
Fixed in 1.0.3 versino of the Orders Awaiting delivery module