0032676: It would be nice to have a process to calculate old cumqty values in m_coting table

Description

In issue 0032504 m_costing cumqty column will be recreated to initialize it with null values, in order to make sure it is correctly calculated starting from this point (in the past this column was not used but starting from 0032504 it will).

It would be nice to have a process to calculate old cumqty values setted as null and update them with the correct value.

The same could be done with cumcost column created while fixing issue 0032504.

Steps To Reproduce

Execute the following query and realize there are some m_costing records with null value in cumqty column:
select count(1) from m_costing where cumqty is null;

Execute the following query and realize there are some m_costing records with null value in cumcost column:
select count(1) from m_costing where cumcost is null;

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on

defect

0032504

3.0PR16Q3

closed

aferraz

Huge performance problem in the costing background process and using the Negative stock correction too

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2016-04-15 11:18	aferraz	New Issue
2016-04-15 11:18	aferraz	Assigned To	=> Triage Finance
2016-04-15 11:18	aferraz	Modules	=> Core
2016-04-15 11:18	aferraz	Triggers an Emergency Pack	=> No
2016-04-15 11:18	aferraz	Relationship added	depends on 0032504