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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0027884
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2014-10-16 10:592014-12-30 23:23
ReporterpsanjuanView Statuspublic 
Assigned Toumartirena 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision25c3153c137c
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0027884: New lines created in costing tab which should not be there

DescriptionNew lines created in costing tab which should not be there
Steps To ReproduceIn QA testing Client, go to Product window and create a new one named "Costing V11".
Go to Price tab, select purchase price list and enter a unit/list price of 20.

Go to purchase order and create a new one for the product and for Spain org dated on 11/10/2014. Enter 100 units. Book the order. Total order amount 2000.

Create another purchase order and create a new one for the same product and org dated on 15/10/2014. This time change the price to 15. Enter 200 units. Book the order. Total order amount 3000.

Go to Goods receipt window and create a new one for Spain org, dated on 20/10/1014, create lines from the orders and select first order, enter a storage bin. Repeat the process with second order.
Above means to receipt all quantity, that is 300 units. Complete the receipt.

Go to process request window and run costing background process.

Go to product window, search the product and go to "Costing" tab. Realize that there are two lines as explained below:

Line 1 - inventory transaction V+ 20/10/2014 Cost 15 Quantity 200. Total Qty 200.
Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 100. Total Qty 300. Ending date 31-12-9999


Go back to goods receipt and post the receipt. Realize that the value is 5000 (300 *16.67). Average Cost calculated is correct (2000 €+3000€/300 units).

Go to goods shipment window and create a new one dated on 25/10/2014 for Spain and product Costing V11, for a total amount of 150 units. Complete shipment.

Go to process request window and run costing background process.

Go back to goods shipment window and post the shipment. Realize that the value is 2500.50 (150 *16.67).

Go to purchase invoice window and create a new invoice dated on 22/10/2014 for Spain org. Create lines from order dated on 11/10/2014, that means 100 units at 20 €/unit. Change the price to 25 €/unit. Complete and Post the invoice.

Go to process request window and run price correction background process.

Go to product window, search the product and go to "Costing" tab. Realize that there are three lines as explained below:

Line 1 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 100
Line 2 - inventory transaction V+ 20/10/2014 Cost 16.67 Quantity 200. Total Qty 300
Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150. Ending date 31-12-9999

(this is not correct)

Correct should be:

Line 1 - inventory transaction V+ 20/10/2014 Cost 15 Quantity 200. Total Qty 200.
Line 2 - inventory transaction V+ 20/10/2014 Cost 18.33 Quantity 100. Total Qty 300. Ending date 31-12-9999

Go to purchase invoice window and create a new invoice dated on 24/10/2014 for Spain org. Create lines from order dated on 15/10/2014, that means 200 units at 15 €/unit. Change the price to 20 €/unit. Complete and Post the invoice.

Go to process request window and run price correction background process.

Go to product window, search the product and go to "Costing" tab. Realize that there are four lines as explained below:

Line 1 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 100. Total Qty 100
Line 2 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 200. Total Qty 300
Line 3 - no inventory transaction Cost 18.33 Total movement quantity 150.
Line 4 - no inventory transaction Cost 21.67 Total movement quantity 150. Ending date 31-12-2014

(this is not correct)

Correct should be:

Line 1 - inventory transaction V+ 20/10/2014 Cost 20 Quantity 200. Total Qty 200.
Line 2 - inventory transaction V+ 20/10/2014 Cost 21.67 Quantity 100. Total Qty 300. Ending date 31-12-9999


Proposed SolutionSee above.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0070989)
psanjuan (viewer)
2014-10-16 12:13

 To change order by in Costing background java class.
(0071058)
hgbot (developer)
2014-10-20 17:56

 Repository: erp/devel/pi
Changeset: 25c3153c137c66d01ed33051b8cdec206870f233
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon Oct 20 17:54:22 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/25c3153c137c66d01ed33051b8cdec206870f233 [^]

Fixes Issue 27884: New lines created in costing tab which should not be there

---
M src/org/openbravo/costing/CostingBackground.java
---
(0071076)
psanjuan (viewer)
2014-10-21 12:00

 Verified. See https://docs.google.com/a/openbravo.com/spreadsheets/d/1Ilm1oct0vH4iKFlI1I0VbmYM-r8fdo1moK02jd2Zigg/edit#gid=1025660841 [^]
Product: Costing V11
(0072952)
hudsonbot (viewer)
2014-12-30 23:23

 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/6525fe229e06 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-10-16 10:59 psanjuan New Issue
2014-10-16 10:59 psanjuan Assigned To => dmiguelez
2014-10-16 10:59 psanjuan OBNetwork customer => No
2014-10-16 10:59 psanjuan Modules => Core
2014-10-16 10:59 psanjuan Triggers an Emergency Pack => No
2014-10-16 11:06 psanjuan Steps to Reproduce Updated View Revisions
2014-10-16 11:18 psanjuan Assigned To dmiguelez => umartirena
2014-10-16 11:18 psanjuan Steps to Reproduce Updated View Revisions
2014-10-16 11:24 psanjuan Steps to Reproduce Updated View Revisions
2014-10-16 11:26 psanjuan Steps to Reproduce Updated View Revisions
2014-10-16 11:36 psanjuan Steps to Reproduce Updated View Revisions
2014-10-16 12:05 psanjuan Steps to Reproduce Updated View Revisions
2014-10-16 12:10 psanjuan Steps to Reproduce Updated View Revisions
2014-10-16 12:10 psanjuan Proposed Solution updated
2014-10-16 12:13 psanjuan Note Added: 0070989
2014-10-20 17:56 hgbot Checkin
2014-10-20 17:56 hgbot Note Added: 0071058
2014-10-20 17:56 hgbot Status new => resolved
2014-10-20 17:56 hgbot Resolution open => fixed
2014-10-20 17:56 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/25c3153c137c66d01ed33051b8cdec206870f233 [^]
2014-10-21 12:00 psanjuan Note Added: 0071076
2014-10-21 12:00 psanjuan Status resolved => closed
2014-10-23 08:46 psanjuan Steps to Reproduce Updated View Revisions
2014-12-30 23:23 hudsonbot Checkin
2014-12-30 23:23 hudsonbot Note Added: 0072952

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker