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

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

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.