0004370: Valued Stock Report doesn't include changes made on the selected date

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0004370

Openbravo ERP

04. Warehouse management

public

2008-07-10 12:23

2010-02-24 16:17

Reporter

RenateNieuwkoop

Assigned To

Hennadzi

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.35

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

0004370: Valued Stock Report doesn't include changes made on the selected date

Description

Warehouse Management || Analysis Tools || Valued Stock Report || Valued Stock Report

The report looks at changes made previous to the date you select, rather than to include the changes from that day.

So if you changed a price on a product on a Purchase Order, performed a goods receipt for that product on 10-7-2008, you then run 'Generate Average Costs' and
go to the valued Stock report and select 10-7-2008 as the date and run the report,
the new Average Cost is not reflected on the output.
However, when you click on the Product, to take you to the Costing of the product setup, you do see the changed average cost reflected there.
So you need to run the report for 11-7-2008 to see the changes made on 10-7-2008.

Steps To Reproduce

Enter PO for Product with large quantity and a different price than the default.
Do Goods Receipt for the PO. Run Generate Average Costs. Go to Valued Stock Report and query that product.

Proposed Solution

I think it makes sense to change the logic of the report so that changes =< the date are included in the report, not < date.

Additional Information