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

Description

New lines created in costing tab which should not be there

Steps To Reproduce

In 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 Solution

See above.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0070989) psanjuan (manager) 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 (manager) 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 (developer) 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	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