Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0019605Openbravo ERP04. Warehouse managementpublic2012-01-31 17:012012-06-28 12:42
maite 
jecharri 
urgentmajoralways
closedfixed 
5
 
3.0MP9 
Core
No
0019605: Generate Average Cost process should take into account goods receipts of same day checked as "permanent"
Generate Average Cost process should take into account goods receipts of same day checked as "permanent"
1. Create Physical Inventory for 31-01-2012, to product "Zumo de Pera Bio 0,33L" at zero stock
2. Create Purchase Order for 31-01-2012, Add line for "Zumo de Pera Bio 0,33L" with 1 unit at prices 1 euro and tax exempt. Process.
3. Create Purchase Order for 31-01-2012, Add line for "Zumo de Pera Bio 0,33L" with 1 unit at prices 2 euro and tax exempt. Process.
4. Go to Pending Goods Receipt form, and create receipt setting date 01/02/2012. Choose both lines with for storage bin RN-0-0-0 and other for RN-1-0-0
5. Run Generate Average Cost process.
6. Go to Costing tab for product "Zumo de Pera Bio 0,33L" and realize that 2 lines have been introduces: one with cost=2 and other with cost=1.5 . This is CORRECT.
7. Edit line Costing line of cost=2 and set as "Permanent"
8. Run Generate Average Cost process.
9. Go to Costing tab for product "Zumo de Pera Bio 0,33L" and realize the permanent line has not changed, but the line with Price 1 now has cost=1 . This is NOT CORRECT. As all receipts from same date should be taken into account when calculating average cost at that day.

[Note: You can also verify that Total Movement Qty for both lines is 1, which implies that receipt's line checked as "permanent" has not been considered]
Generate Average cost process should include ALL receipt's line of specific day, when calculating costing for this day. Also receipt's line checked as Permanent.
No tags attached.
depends on backport 00198612.50MP41 closed jecharri Generate Average Cost process should take into account goods receipts of same day checked as "permanent" 
Issue History
2012-01-31 17:01maiteNew Issue
2012-01-31 17:01maiteAssigned To => jonalegriaesarte
2012-01-31 17:01maiteModules => Core
2012-01-31 17:01maiteIssue Monitored: networkb
2012-01-31 17:29maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3116#r3116
2012-02-15 13:22jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-02-23 13:09hgbotCheckin
2012-02-23 13:09hgbotNote Added: 0045407
2012-02-23 13:09hgbotStatusnew => resolved
2012-02-23 13:09hgbotResolutionopen => fixed
2012-02-23 13:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/91dacdd3f33dffa8e3afe1acfb075c0c38b51d0b [^]
2012-02-24 09:07jecharriStatusresolved => new
2012-02-24 09:07jecharriResolutionfixed => open
2012-02-24 09:07jecharriStatusnew => scheduled
2012-02-24 09:07jecharrifix_in_branch => pi
2012-02-24 09:07jecharriStatusscheduled => resolved
2012-02-24 09:07jecharriResolutionopen => fixed
2012-02-28 18:27maiteNote Added: 0045561
2012-02-28 18:27maiteStatusresolved => closed
2012-03-02 15:39hudsonbotCheckin
2012-03-02 15:39hudsonbotNote Added: 0045941
2012-06-27 20:23hgbotCheckin
2012-06-27 20:23hgbotNote Added: 0050200
2012-06-27 20:23hgbotStatusclosed => resolved
2012-06-27 20:23hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/91dacdd3f33dffa8e3afe1acfb075c0c38b51d0b [^] => http://code.openbravo.com/erp/devel/pi/rev/963a92ace9774e82961383a387322680d520ef53 [^]
2012-06-28 08:01hudsonbotCheckin
2012-06-28 08:01hudsonbotNote Added: 0050226
2012-06-28 12:33jecharriStatusresolved => closed

Notes
(0045407)
hgbot   
2012-02-23 13:09   
Repository: erp/devel/pi
Changeset: 91dacdd3f33dffa8e3afe1acfb075c0c38b51d0b
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Feb 23 13:08:35 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/91dacdd3f33dffa8e3afe1acfb075c0c38b51d0b [^]

Fixes issue 19605 , Fixes issue 19606:
Generate Average Cost process should take into account goods receipts of same day checked as "permanent" and
Generate Average cost process is not raising unposting error if all costing lines are set as "permanent".
To solve the first problem I have added the permanets quantitites of the day first and to solve the second problem, now I take the min date from M_INOUT

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0045561)
maite   
2012-02-28 18:27   
verified
(0045941)
hudsonbot   
2012-03-02 15:39   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test
(0050200)
hgbot   
2012-06-27 20:23   
Repository: erp/devel/pi
Changeset: 963a92ace9774e82961383a387322680d520ef53
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Feb 23 13:08:35 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/963a92ace9774e82961383a387322680d520ef53 [^]

Fixes issue 19605 , Fixes issue 19606:
Generate Average Cost process should take into account goods receipts of same day checked as "permanent" and
Generate Average cost process is not raising unposting error if all costing lines are set as "permanent".
To solve the first problem I have added the permanets quantitites of the day first and to solve the second problem, now I take the min date from M_INOUT

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0050226)
hudsonbot   
2012-06-28 08:01   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c66e853c5cf4 [^]

Maturity status: Test