0038157: Receipts originally calculated with avg and adjusted by price difference correction are readjusted if avg cost changes

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0038157

Openbravo ERP

04. Warehouse management

public

2018-03-16 10:51

2018-03-23 21:22

Reporter

gorkaion

Assigned To

collazoandy4

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR18Q2

Merge Request Status

Review Assigned To

dmiguelez

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Pre packaging ( pi )

Regression date

2018-01-15

Regression introduced in release

Regression introduced by commit

https://code.openbravo.com/erp/devel/pi/rev/6fc5c9829dff02db5bb10f5f3b09c2cb137ef0d0 [^]

Triggers an Emergency Pack

Summary

0038157: Receipts originally calculated with avg and adjusted by price difference correction are readjusted if avg cost changes

Description

Having a Goods Receipt with no related Purchase Order but a related Purchase Invoice.

When the cost of the receipt is calculated the current average is used. Later the Price Difference correction process is launched and the cost is adjusted with the invoice price.

Now a previous transaction is adjusted so the average cost changes. The Goods Receipt is adjusted again with the new average cost not taking into account the Invoice Price. This last adjustment should not happen as the cost of the receipt is not based on the average cost anymore.

After fix of issue 0037279 when a incoming transaction is calculated using the
average cost. If the average cost used to calculate it is later changed by some cost adjustment the cost of this transaction is calculated again.

For example:
- Physical Inventories that increase stock and does not have a cost defined.
- Goods Receipts without a related Purchase Order.

Steps To Reproduce

Enable preference to automatically execute Price Difference Correction (Property: "Enable automatic Price Difference Corrections").

On a product with an average cost.
* Create a Purchase Invoice for that product with qty 2000 and price 1.
* Create a Goods Receipt using the Create Lines From to select the created invoice and change the quantity to 1000.
* Repeat previous step to create a second Goods Receipt with the remaining 1000 qty.
* Execute Costing Background process and check in the Product -> Transactions tab that the receipts are calculated with Average Cost and adjusted with the invoice price.
* On the Transactions tab select the first Receipt and click on Manual Adjustment. Set amount=10000, incremental=Yes and Unit Cost = No.
* Check that the second receipt is adjusted again and the cost is based with the new Average Cost.
*

Proposed Solution

When checking if the transaction is based on the average cost take into account Goods Receipts that are already adjusted by the Price Difference Correction.

Additional Information