0030430: No price correction adjustment is created whenever a receipt is not created from an invoice but from the order related.

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0030430

Openbravo ERP

03. Procurement management

public

2015-07-27 09:59

2018-01-19 14:38

Reporter

psanjuan

Assigned To

Triage Omni OMS

Priority

urgent

Severity

major

Reproducibility

have not tried

Status

new

Resolution

open

Platform

OS Version

Ubuntu 8.04.1

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

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

0030430: No price correction adjustment is created whenever a receipt is not created from an invoice but from the order related.

Description

No price correction adjustment is created whenever a receipt is not created from an invoice but from the order related, regardless corresponding purchase invoice has a product price change.

Steps To Reproduce

In F&B International, verify that Costing Background process an Price Correction process are both scheduled, and there is a Costing Rule setup for F&B US under "Average" costing method algorithm.

Go to product window and create a new product with below setup:
Organization = F&B US
Search key and Name = A
Product type = Item
Stocked checkbox = selected
Go to price tab and create a new record:
Select "Other services" purchase price list and enter a unit/list price = 25.00

Go to purchase order window and create a new one for F&B US and Product "A" dated on "current date".
Enter 580.00 units of Product A.
Complete and Book the order.

Go to purchase invoice window and create a new one for F&B US dated on "current date" + 3 days.
Use the option "Create Lines From" process button and select the order just created.
Complete and post the invoice.

Go to the Goods Receipt window and create a new one for F&B US dated on "current date" + 6 days.
Use the option "Create Lines From" process button and select the order just created.
Receipt 80 units.

Complete and post the receipt once costing background process has been executed, therefore receipt transaction cost has been already calculated.

Go to product window, search by product "A" and realize that the cost of the transaction (80 units * 25 = 2000) and the cost of the product (25) are calculated.

Go to the purchase invoice window and update the actual price to 20.
For doing that you need to unpost the invoice, reactivate it, change the price to 20 and complete and post once again the invoice. Keep the same invoice accounting date.

Make sure that the purchase price correction has been executed.

Go to product window and realize that the cost of the transaction has been adjusted. There is a cost adjustment line for an amount of -400.

That is correct.

Go now to the Goods Receipt window and create a new one for F&B US dated on "current date" + 6 days.
Use the option "Create Lines From" process button and select the order just created.
Receipt 500 units.

Complete and post the receipt once costing background process has been executed, therefore receipt transaction cost has been already calculated.

Go to product window, costing tab. Realize that the cost of the product has not been recalculated to 20 but to 24.3103345 which is not correct.

Besides that the cost of the second receipt transaction has not been recalculated. No cost adjustment has been created.

On the other hand, if second good receipt is created from the invoice (not from the order) both product cost and transaction cost are correctly calculated as the corresponding cost adjustment is then created.

Proposed Solution

Price correction cost adjustment should have been created regardless second goods receipt is not created from the invoice but from the order, because finally the invoice related has a price correction.

Actual product cost should have been recalculated to 20
Actual transaction cost should have been recalculated to 2500 = (500*25 -500 *20)

Additional Information