Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0032470 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Retail Modules] Retail Widgets | major | always | 2016-03-14 17:40 | 2016-12-01 15:39 | |||||||
| Reporter | ngarcia | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | ||||||||
| Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| 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 | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0091617) shivum039 (developer) 2016-11-17 07:28 |
The above issue belongs to the org.openbravo.retail.widget module , As of now team(Retail Bug Team ) not fixing issues belongs to that particular Module . |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |