0028192: [Costing] Net Unit Price field in Costing tab is not properly calculated

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028192

Openbravo ERP

04. Warehouse management

public

2014-11-17 15:03

2014-12-30 23:26

Reporter

aferraz

Assigned To

umartirena

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS Version

Professional Appliance

Product Version

Target Version

Fixed in Version

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

0028192: [Costing] Net Unit Price field in Costing tab is not properly calculated

Description

[Costing] Net Unit Price field in Costing tab is not properly calculated

Steps To Reproduce

In QA Testing client create a new product named "Costing GM12". Select a purchase price list. Enter a unit/list price of 11.00

Go to purchase order window and create a new one dated on 29/10/2014. Enter 820 units. Book the order.

Go to goods receipt window and create a new one dated on 3/11/2014. Select the order and receipt 820 units. Complete the receipt

Go to process request window and launch costing background process.

Go back to goods receipt window and post it. Realize that value posted is 9020 ( 820 units * 11.00 €/unit)

Go to Goods Movement Window and create a new one dated on 13/11/2014

Move 400 units from Spain Warehouse to another warehouse named Spain West Warehouse, for instance. Complete the movement.

Go to process request window and launch costing background process.

Go to goods movement and post it. Realize that the value posted is 4400 ( 400 units + 11 €/unit)

Go to product window and search by the product. Go to transaction tab.
Select Movement From transaction and press the button "Manual Cost Adjustment".

In total cost field enter a total cost amount = -400. Enter 18/11/2014 as accounting date, select the flag "Incremental" but do not select the flag "Unit Cost". Press Done/OK.

After this a purchase invoice needs to be created dated on 8/11/2014. Create it by using Create Lines From, select the receipt. Realize that 820 units are shown. Change the price from 11.00 to 15.00. Complete and post the invoice. Realize that total value posted is 12300 (820 units * 15.00 €/unit).

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

Go to product window and search by the product. Go to Transaction tab and realize that there are 3 lines:

- Transaction 1: Movement Quantity 820 - Transaction Original Cost 9,020.00 - Total Cost 12,300.00 - Unit Cost 12,300.00

- Transaction 2: Movement Quantity -400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 6,000.00

- Transaction 3: Movement Quantity 400 - Transaction Original Cost 4,400.00 - Total Cost 5,600.00 - Unit Cost 5,600.00

Go to Costing tab and realize that there are 3 lines:

- Line 1: Cost 15 - Net Unit Price 15.00 - Original Cost 11

- Line 2: Cost 14 - Net Unit Price 14.00 - Original Cost 11

- Line 3: Cost 15.9524 - Net Unit Price 6.00 - Original Cost 11.9524

Line 3 is not correct. It should be:

- Line 3: Cost 15.9524 - Net Unit Price 15.95 (because that is the cost of the Movement From transacton) - Original Cost 11.9524

Proposed Solution

See above

Additional Information