Openbravo Issue Tracking System - Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035161 | Modules | Analytics | public | 2017-02-03 14:36 | 2022-02-01 08:05 |
| Reporter | ngarcia | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Regression date | |||||
| Regression introduced by commit | |||||
| Regression level | |||||
| Review Assigned To | |||||
| Support ticket | |||||
| OBNetwork customer | |||||
| Regression introduced in release | |||||
| Summary | 0035161: Sales Details Fact Cube is showing a cost of 0 for not stocked products (items, services...) | ||||
| Description | Sales Details Fact Cube is showing a cost of 0 for not stocked products (items, services...) | ||||
| Steps To Reproduce | As group admin role: Create a product and set it as Service Add a price in a sales price to it Add a standard cost to it Create a Sales Order and include the already created product Create the associated Goods Shipment and Sales Invoice As system admin role: Schedule the 'Update Time Dimension Refs + Tree Closure Table' process to Run Immediately (Process Request window) As group admin role: Schedule the 'Forward Update Analytics Fact Tables' process to Run Immediately (Process Request window) Go to Analytics Sales Detail view window and check the record associated to the previously created invoice. Check the cost is shown as 0 and thus the linenetcost and gross margin are not correct Launch the Sales Invoice Dimensional Report with Documentno and Product dimensions and check that the cost is not 0 and the margin is correctly calculated | ||||
| Proposed Solution | In OBAnalyticsFactOrderUpdater class, only the records from the m_transaction are taken into account for calculating the cost. Not stocked products included in goods shipments do not have an associated entry in the m_transaction table | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2017-02-03 14:36 | ngarcia | New Issue | |||
| 2017-02-03 14:36 | ngarcia | Assigned To | => platform | ||
| 2017-02-03 14:36 | ngarcia | Issue Monitored: networkb | |||
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |