Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0014852 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 07. Sales management | major | always | 2010-10-11 13:57 | 2010-12-09 16:07 | |||
| Reporter | networkb | View Status | public | |||||
| Assigned To | rsuresh | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 85e337e45594 | ||||
| Projection | none | ETA | none | Target Version | 2.50MP23 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP22 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0014852: Error in report Invoiced Sales Order Report | |||||||
| Description | Error in report Invoiced Sales Order Report | |||||||
| Steps To Reproduce | 1. 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 Solution | change clause HAVING SUM(C_ORDERLINE.QTYDELIVERED) > 0 by HAVING SUM(C_ORDERLINE.QTYINVOICED) > 0 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0032241) hgbot (developer) 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 (reporter) 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 (developer) 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 (reporter) 2010-11-12 07:07 |
verified, now sales order details rightly displayed even when sales invoice is created without creating the Goods Shipment |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2010-10-11 13:57 | networkb | New Issue | |
| 2010-10-11 13:57 | networkb | Assigned To | => adrianromero |
| 2010-10-26 10:36 | rsuresh | Assigned To | adrianromero => rsuresh |
| 2010-10-27 06:55 | hgbot | Checkin | |
| 2010-10-27 06:55 | hgbot | Note Added: 0032241 | |
| 2010-10-27 06:55 | hgbot | Status | new => resolved |
| 2010-10-27 06:55 | hgbot | Resolution | open => fixed |
| 2010-10-27 06:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/85e337e455943fe969521645fbaa6b41a3ddfa48 [^] |
| 2010-10-27 07:08 | rsuresh | Note Added: 0032242 | |
| 2010-11-05 12:44 | hudsonbot | Checkin | |
| 2010-11-05 12:44 | hudsonbot | Note Added: 0032423 | |
| 2010-11-12 07:07 | sureshbabu | Note Added: 0032572 | |
| 2010-11-12 07:07 | sureshbabu | Status | resolved => closed |
| 2010-12-09 16:07 | anonymous | sf_bug_id | 0 => 3133511 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |