0024285: It is necessary to review some reports regarding the product quantity shown

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0024285

Openbravo ERP

04. Warehouse management

public

2013-07-08 17:00

2014-05-12 14:24

Reporter

VictorVillar

Assigned To

dmiguelez

Priority

urgent

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

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

0024285: It is necessary to review some reports regarding the product quantity shown

Description

Steps To Reproduce

It is necessary to review some reports regarding the product quantity shown.
The 'Valued Stock Report' and the 'Stock Report' are taking into account the movement date of the m_transaction table, might be it will be necessary to take into account the transaction process date of the same table.

1) On 1-Nov-12, Product P123 on-hand qty = 100 kpc
2) On 1-Nov-12, Customer Service created a Goods Shipment for Product P123 of 150 kpc.
The Goods Shipment was left in "Draft" status since there wasn't enough qty for the shipment.
3) On 8-Nov-12, 80 kpc were transferred from production to the warehouse. Qty on hand: 180
4) On 8-Nov-12, Customer Service successfully completed the Goods Shipment of 150 kpc for Product P123
without changing the date to 8-Nov-12. So the goods movement date is recorded as 1-Nov-12.

"Valued Stock Report" setting the date to 1-Nov-12,
the report shows 30 kpc for Product P123.

Proposed Solution

The 'Valued Stock Report' and the 'Stock Report' are taking into account the movement date of the m_transaction table, might be it will be necessary to take into account the transaction process date of the same table.
Another option could be: inform the user that the document that is going to be processed has the movement date different from the transaction process date.

Additional Information