0033927: In Warehouse Control Report Movement type is not shown for products included in Work Efforts

Description

In Warehouse Control Report Movement type is not shown for products included in Work Efforts.

The problem is that the query is taking the M_PRODUCT.NAME column as a description and it is null for work efforts (not for Bill Of Material Production)

Steps To Reproduce

As group admin role:
   Create a new product and set it as Bill Of Materials and Stocked
   Add a product in the Bill Of Materials tab and Verify BOM
   Create a Bill Of Materials Production, add the previously created product, create and process it (the Create/Process Production process should be launched twice)
   Launch the Warehouse Control Report and check the name and date of the production is shown in Movement type field for the product produced in the BOM production
   Create a product and set it as Production and Stocked
   Assign an Storage Bin in the Manufacturing tab
   Create an Activity
   Create a Process Plan, Version and Operation
   Add the previously created product in I/O Products tab
   Create a Work Requirement, assign the previously created Process Plan and Process it
   Create a Work Effort from it
   Validate it
   Launch the Warehouse Control Report and check no value is shown in Movement type field for the product produced in the work effort

Proposed Solution

The report should show the name for Bill Of Materials production (m_production.issotrx = 'Y') and the documentno for Work Efforts (m_production.issotrx = 'N')

Issue History
Date Modified	Username	Field	Change
2016-09-08 14:29	ngarcia	New Issue
2016-09-08 14:29	ngarcia	Assigned To	=> Triage Finance
2016-09-08 14:29	ngarcia	Modules	=> Core
2016-09-08 14:29	ngarcia	Triggers an Emergency Pack	=> No
2016-09-08 14:29	ngarcia	Issue Monitored: networkb
2016-09-09 01:04	Integritas	Issue Monitored: Integritas

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.