Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0032470 | Retail Modules | Retail Widgets | public | 2016-03-14 17:40 | 2016-12-01 15:39 |
| Reporter | ngarcia | ||||
| Assigned To | Retail | ||||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | scheduled | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0032470: No data is shown in the Best Selling Product by Store widget if a product is sold and returned and its cost calculated | ||||
| Description | No data is shown in the Best Selling Product by Store widget if a product is sold and returned and its cost calculated: olt.salesOrderLine = sol)) is 0 in the grossmarginpercentage column of the query | ||||
| Steps To Reproduce | In the backend: Create a new product Add it in the Vall Blanca Store assortment and price list Add an average cost to it In the frontend: Sell the product Return the whole ticket In the backend: Launch the Costing Background process and check it finishes successfully Add the Best Selling Product by Store widget in the workspace Check "No Items to Show" message is shown The log shows: ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: division by zero ERROR org.openbravo.service.datasource.DataSourceServlet - could not execute query org.hibernate.exception.DataException: could not execute query... | ||||
| Proposed Solution | sum(sol.lineNetAmount + (select sum(taxAmount) from OrderLineTax olt where | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2016-03-14 17:40 | ngarcia | New Issue | |||
| 2016-03-14 17:40 | ngarcia | Assigned To | => Retail | ||
| 2016-03-14 17:40 | ngarcia | Resolution time | => 1460671200 | ||
| 2016-03-14 17:40 | ngarcia | Triggers an Emergency Pack | => No | ||
| 2016-07-08 09:04 | ngarcia | Resolution time | 1460671200 => 1469570400 | ||
| 2016-07-08 09:13 | ngarcia | Issue Monitored: networkb | |||
| 2016-07-11 12:58 | ngarcia | Resolution time | 1469570400 => | ||
| 2016-11-17 07:24 | shivum039 | Assigned To | Retail => shivum039 | ||
| 2016-11-17 07:24 | shivum039 | Status | new => scheduled | ||
| 2016-11-17 07:28 | shivum039 | Note Added: 0091617 | |||
| 2016-12-01 15:39 | jorge-garcia | Assigned To | shivum039 => Retail | ||
| Notes | |||||
|
|
|||||
|
|
||||