Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004908Openbravo ERP04. Warehouse managementpublic2008-09-09 17:262009-03-03 17:16
RenateNieuwkoop 
Hennadzi 
normalminoralways
closedfixed 
5
2.35 
 
Core
No
0004908: Valued Stock Report doesn't include changes made on the selected date
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.

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.
I think it makes sense to change the logic of the report so that changes =< the date are included in the report, not < date.
No tags attached.
blocks defect 0004370 closed Hennadzi Valued Stock Report doesn't include changes made on the selected date 
Issue History
2008-09-09 17:26anonymousNew Issue
2008-09-09 17:26anonymousAssigned To => Hennadzi
2008-09-09 17:26anonymousStatusnew => scheduled
2008-09-09 17:26anonymousfix_in_branch => 2.40
2008-09-16 15:37cromeroAssigned ToHennadzi => cromero
2008-11-10 13:04cromeroAssigned Tocromero => rafaroda
2008-11-13 21:45rafarodaAssigned Torafaroda => Hennadzi
2008-11-25 13:07svnbotCheckin
2008-11-25 13:07svnbotNote Added: 0010637
2008-11-25 13:07svnbotStatusscheduled => resolved
2008-11-25 13:07svnbotResolutionopen => fixed
2008-11-25 13:07svnbotsvn_revision => 10534
2008-11-26 17:24svnbotCheckin
2008-11-26 17:24svnbotNote Added: 0010729
2008-11-26 17:24svnbotsvn_revision10534 => 10628
2009-02-02 16:20rafarodaNote Deleted: 0010729
2009-03-03 17:16psarobeStatusresolved => closed

Notes
(0010637)
svnbot   
2008-11-25 13:07   
Repository: openbravo
Revision: 10534
Author: hennadzi
Date: 2008-11-25 13:07:40 +0100 (Tue, 25 Nov 2008)

Fixed bug 0004908: Valued Stock Report doesn't include changes made on the selected date

---
U branches/r2.40/src-db/database/model/functions/GET_PRODUCT_COST.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10534&sc=1 [^]