Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014852Openbravo ERP07. Sales managementpublic2010-10-11 13:572010-12-09 16:07
Reporternetworkb 
Assigned Torsuresh 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP22 
Target Version2.50MP23Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014852: Error in report Invoiced Sales Order Report
DescriptionError in report Invoiced Sales Order Report
Steps To Reproduce1. Sales Management || Transactions || Sales Order || Header : create sales order for any BP and for any product and set Invoice terms= immediate
2. Sales Management || Transactions || Sales Invoice || Header : create associated sales invoice
3. execute Sales Management || Analysis Tools || Invoiced Sales Order Report || Invoiced Sales Order Report setting valid dates and realize that your order does not appear

Having a look at the query is checking that "HAVING SUM(C_ORDERLINE.QTYDELIVERED) > 0" which make no sense as this report is INVOICED Sales Order Report (there is another called DELIVERED Sales Order Report)
Proposed Solutionchange clause
HAVING SUM(C_ORDERLINE.QTYDELIVERED) > 0
by
HAVING SUM(C_ORDERLINE.QTYINVOICED) > 0
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-10-11 13:57networkbNew Issue
2010-10-11 13:57networkbAssigned To => adrianromero
2010-10-11 13:57networkbOBNetwork customer => Yes
2010-10-26 10:36rsureshAssigned Toadrianromero => rsuresh
2010-10-27 06:55hgbotCheckin
2010-10-27 06:55hgbotNote Added: 0032241
2010-10-27 06:55hgbotStatusnew => resolved
2010-10-27 06:55hgbotResolutionopen => fixed
2010-10-27 06:55hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/85e337e455943fe969521645fbaa6b41a3ddfa48 [^]
2010-10-27 07:08rsureshNote Added: 0032242
2010-11-05 12:44hudsonbotCheckin
2010-11-05 12:44hudsonbotNote Added: 0032423
2010-11-12 07:07sureshbabuNote Added: 0032572
2010-11-12 07:07sureshbabuStatusresolved => closed
2010-12-09 16:07anonymoussf_bug_id0 => 3133511

Notes
(0032241)
hgbot   
2010-10-27 06:55   
Repository: erp/devel/pi
Changeset: 85e337e455943fe969521645fbaa6b41a3ddfa48
Author: Ratnakaram Suresh <ratnakaram.suresh <at> openbravo.com>
Date: Wed Oct 27 10:24:42 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/85e337e455943fe969521645fbaa6b41a3ddfa48 [^]

Fixes issue 0014852: Error in report Invoiced Sales Order Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
---
(0032242)
rsuresh   
2010-10-27 07:08   
Steps to test:
* Create Sales Order with a BP and select any Product and set Invoice Terms=immediate
* Do NOT make Shipment (NOTE: if we do not do shipment then issue can be reproducable)
* Create associated Sales Invoice
* Click on Invoiced Sales Order Report with selecting valid dates, now the report shows the order, before this fix it was not showing


Root cause:

* It has condition in xsql as HAVING SUM(C_ORDERLINE.QTYDELIVERED) > 0, where it was supposed to be be HAVING SUM(C_ORDERLINE.QTYINVOICED) > 0

Impact:
* No Impact will be there, as this is related to this report only
(0032423)
hudsonbot   
2010-11-05 12:44   
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/85e337e45594 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f2cf138fa03c [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.18797.obx [^]
(0032572)
sureshbabu   
2010-11-12 07:07   
verified, now sales order details rightly displayed even when sales invoice is created without creating the Goods Shipment