0028113: [Costing] wrong negative stock correction adjustment

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028113

Openbravo ERP

04. Warehouse management

public

2014-11-06 18:05

2014-12-30 23:26

Reporter

psanjuan

Assigned To

umartirena

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 8.04.1

Product Version

Target Version

Fixed in Version

3.0PR15Q1

Merge Request Status

Review Assigned To

Sandrahuguet

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0028113: [Costing] wrong negative stock correction adjustment

Description

[Costing] wrong negative stock correction adjustment

Steps To Reproduce

In QA Testing Client create a new product named Costing V221.
Select a purchase price list and enter a unit/list price of 15.00

Go to purchase order and create a new one dated on 17/10/2014. Select the product and enter 500 units. Book the order.

Go to purchase order and create a new one dated on 18/10/2014. Select the product and enter 700 units. Change the price to 12.00. Book the order.

Go to goods receipt window and create a new one dated on 19/10/2014. Select the first purchase order and receipt 150 units. Complete the receipt.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 2250 (150 units * 15.00)

Go to goods shipment window and create a new one dated on 20/10/2014. Enter 600 units.

Go to process request window and launch costing background process.

Go to the goods shipment and post it. Realize that the value post is 9000 (600 units * 15.00)

Go to goods receipt window and create a new one dated on 22/10/2014. Select the second purchase order and receipt 500 units.

Go to process request window and launch costing background process.

Go to the goods receipt and post it. Realize that the value post is 6000 (500 units * 12.00)

Go to Cost adjustment window and realize that negative stock correction one has been created for an adjustment amount of X= 1350 (2250-9000+6000+X)/50 = 12

Go to Product window, search the product and navigate to Costing tab. Realize that cost shown is 12, Total mov quty = 50

Go to purchase invoice window and create a new one dated on 30/10/2014. Create purchase lines by using "Create Lines From" button, selecting both purchase order.

Change 150 units line price from 15.00 to 20.00
Change 500 units line price from 12.00 to 18.00

Complete and post the invoice.

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

Go to Cost adjustment window and realize that a price difference correction has been created including below adjustments:

1.- Vendor receipt dated on 19/10/2014 - Adj Amount 750.00 (150 units * 20.00 - 150 units * 15.00)
2.- Vendor receipt dated on 22/10/2014 - Adj Amount 3000.00 (500 units * 18.00 - 500 units * 12.00)
3.- Customer Shipment dated on 20/10/2014 - Adj Amount 3000.00 (600 units * 20.00 - 600 units * 15.00)
4 - Vendor receipt dated on 22/10/2014 - Set as Negative Stock Correction- Adj Amount -315 - this last adjustment is not correct.

Correct negative stock correction adjustment should be: -450 = (2250+750-9000-3000+6000+1350+3000+X)/50 = 18

Go to the product window, search the product and navigate to costing tab. Realize that there are two lines.

Line 1 related to Vendor receipt 19/10/2014 inventory transaction - Cost 20 - total mov quantity - 150 - this is correct

Line 2 related to Vendor receipt 22/10/2014 inventory transaction - Cost 20.7 - total mov quanity - 50 - this is NOT correct as it should have a cost of 18.00

Proposed Solution

Correct negative stock correction adjustment should be: -450 = (2250+750-9000-3000+6000+1350+3000+X)/50 = 18

Go to the product window, search the product and navigate to costing tab.
There should be below two lines.

Line 1 related to Vendor receipt 19/10/2014 inventory transaction - Cost 20 - total mov quantity - 150

Line 2 related to Vendor receipt 22/10/2014 inventory transaction - Cost 18.00 - total mov quanity - 50

Additional Information