Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010749
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementminoralways2009-09-24 17:442009-10-27 00:00
ReporternetworkbView Statuspublic 
Assigned Togorkaion 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionf12253b7af5c
ProjectionnoneETAnoneTarget Version2.40MP11
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP6SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010749: Generate average cost does not calculate properly end date

DescriptionEnd dates are not properly calculated when generate average cost is executed.

In our scenario a permanent cost is introduced. Then a purchase order + good receipt is created. After executing it, end dates are the same.

Also it happens if more purchase orders + good receipts are created.

Please, see attached file
Steps To ReproduceGo to Master Data Management > Product. Create a new one and select Average as Cost type.
Go to Costing tab and generate a new record. Select Permanent, and Manual.
Enter as Starting date, quantity and price.
Go to Procurement management > Transactions > Purchase Order. Create a new one with this product. Process it.
Go to Procurement management > Transactions > Good Receipt. Create a new one with same partner. Use "Create lines from" button to enter its lines. Select the previous Order to select it line.
Complete it.
Go to Warehouse Management > Transactions > Generate average cost. Execute it.
Go back to Costing tab, in Product window. See end dates. They are wrong.
Tags250MP8, main
Attached Filespng file icon Pantallazo.png [^] (222,655 bytes) 2009-09-24 17:44

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00107512.40MP11 closedgorkaion Generate average cost does not calculate properly end date 
related to defect 00110202.40MP11 closedgorkaion Generate Average cost does not work properly if products have ad_client_id = 0 

-  Notes
(0020346)
networkb (viewer)
2009-09-24 17:45

 It also has been tested in MP9, and also it fails
(0020347)
hgbot (developer)
2009-09-24 19:13

 Repository: erp/devel/pi
Changeset: f12253b7af5cbcf024bea1456e607c36cd646616
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Sep 24 19:11:57 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^]

Fixed issue 10749. Changed the initial dateTo calculation.

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0020511)
hgbot (developer)
2009-09-29 14:18

 Repository: erp/devel/pi-pageddatagrid
Changeset: f12253b7af5cbcf024bea1456e607c36cd646616
Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
Date: Thu Sep 24 19:11:57 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^]

Fixed issue 10749. Changed the initial dateTo calculation.

---
M src-db/database/model/functions/M_GENERATE_AVERAGE_COSTS.xml
---
(0020814)
sureshbabu (viewer)
2009-10-07 09:48
edited on: 2009-10-08 08:59

 Hi Gorka,

Kindly let me know what is the fix here, since i am not finding any difference to the one reported by the user.
(0021094)
networkb (viewer)
2009-10-16 09:38

 Please, reopen the issue because the solution provided is not right.
(0021122)
gorkaion (viewer)
2009-10-16 17:10

 Hi,

suresh, to reproduce the issue you have the date of the first fixed cost has to be later than the firs receipt.

good receipt 2009-09-10
fixed cost 2009-10-10
good receipt 2009-11-10

the solution to the issue described is right so I won't open this one. Please open a new one in order to study why it is still failing.
(0021123)
networkb (viewer)
2009-10-16 17:15

 Function fails when products were created with ad_client_id = 0, and are used in diferent clients.
(0021240)
arunkumar (viewer)
2009-10-21 08:36
edited on: 2009-10-21 08:41

 Still I see the end dates are 31-12-9999 for the created Goods Receipt.I do not find the fix here.
(0021363)
gorkaion (viewer)
2009-10-23 14:02

 Go to Master Data Management > Product. Create a new one and select Average as Cost type.
Go to Costing tab and generate a new record. Select Permanent, and Manual.
Enter as Starting date=01-10-2009, quantity=10, price=10 and cost=10.
Go to Procurement management > Transactions > Purchase Order. Create a new one with this product with date ordered 01-09-2009. Process it.
Go to Procurement management > Transactions > Good Receipt. Create a new one with same partner with date 01-09-2009. Use "Create lines from" button to enter its lines. Select the previous Order to select it line.
Complete it.
Create a new order and receipt following previous steps with date 01-11-2009.
Go to Warehouse Management > Transactions > Generate average cost. Execute it.
Go back to Costing tab, in Product window to check the results. Expected results are:

good receipt. datefrom 01-09-2009 dateto 01-10-2009
fixed cost datefrom 01-10-2009 dateto 01-11-2009
good receipt datefrom 01-11-2009 dateto 31-12-9999

- Issue History
Date Modified Username Field Change
2009-09-24 17:44 networkb New Issue
2009-09-24 17:44 networkb Assigned To => rafaroda
2009-09-24 17:44 networkb File Added: Pantallazo.png
2009-09-24 17:44 networkb OBNetwork customer => Yes
2009-09-24 17:45 networkb Target Version => 2.40MP11
2009-09-24 17:45 networkb Note Added: 0020346
2009-09-24 18:04 psarobe Status new => scheduled
2009-09-24 18:04 psarobe Assigned To rafaroda => gorkaion
2009-09-24 18:04 psarobe fix_in_branch => pi
2009-09-24 19:13 hgbot Checkin
2009-09-24 19:13 hgbot Note Added: 0020347
2009-09-24 19:13 hgbot Status scheduled => resolved
2009-09-24 19:13 hgbot Resolution open => fixed
2009-09-24 19:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^]
2009-09-25 07:05 rafaroda Priority immediate => high
2009-09-25 07:05 rafaroda fix_in_branch pi =>
2009-09-29 14:18 hgbot Checkin
2009-09-29 14:18 hgbot Note Added: 0020511
2009-09-29 14:18 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/f12253b7af5cbcf024bea1456e607c36cd646616 [^]
2009-10-07 09:48 sureshbabu Note Added: 0020814
2009-10-08 08:59 sureshbabu Note Edited: 0020814
2009-10-16 09:38 networkb Note Added: 0021094
2009-10-16 17:10 gorkaion Note Added: 0021122
2009-10-16 17:15 networkb Note Added: 0021123
2009-10-16 17:47 gorkaion Relationship added related to 0011020
2009-10-21 08:36 arunkumar Note Added: 0021240
2009-10-21 08:41 sureshbabu Note Edited: 0021240
2009-10-22 19:26 psarobe Tag Attached: main
2009-10-22 19:33 psarobe Tag Attached: 250MP8
2009-10-23 14:02 gorkaion Note Added: 0021363
2009-10-26 11:41 plujan Status resolved => closed
2009-10-27 00:00 anonymous sf_bug_id 0 => 2886771

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker