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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0032676

Openbravo ERP

04. Warehouse management

public

2016-04-15 11:18

Reporter

aferraz

Assigned To

Triage Omni WMS

Priority

normal

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Professional Appliance

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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;

Proposed Solution

Additional Information