0028962: [Cost Adjustments] Orphan Lines cost calculation fails under certain circumstances

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0028962

Openbravo ERP

04. Warehouse management

public

2015-02-16 19:12

2015-03-09 09:30

Reporter

umartirena

Assigned To

umartirena

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

aferraz

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

0028962: [Cost Adjustments] Orphan Lines cost calculation fails under certain circumstances

Description

Orphan Lines cost calculation cannot calculate the cost of a return from customer when is a backdated transaction.

Steps To Reproduce

In F&B:
* Enable "RM Allow Orphan Line" preference.
* Have a valid average costing rule for F&B España org.
* Create a Product
* Add a Costing Record:
  - Org: F&B España
  - Cost: 5
  - Cost Type: Average
  - Starting Date: 01/01/2014
  - Ending Date: 31/12/9999
* Create a Goods Shipment:
  - Org: F&B España
  - Business Partner: Alimentos y Supermercados
  - Movement Date: 10/02/2015
* Add a Line:
  - Product: The new product
  - Qty: 10
  - Storage Bin: RN 0-0-0
* Complete it
* Go to Return from Customer window
* Create a Header:
  - Org: F&B España
  - Business Partner: Alimentos y Supermercados
  - Order Date: 05/02/2015
* Click on "Insert Orphan Line":
  - Product: The new product
  - Returned: 5
  - Unit Price: 12
  - Tax: Arrendamiento 21% (Cobros) - IVA Normal
* Click OK and Book it
* Go to Return Material Receipt:
* Create a Header:
  - Org: F&B España
  - Business Partner: Alimentos y Supermercados
  - Movement Date: 05/02/2015
* Click on Pick/Edit Lines:
* Select the line created in previous Return from Customer
  - Returned: 5
  - Storage Bin: RN 0-0-0
* Click Done and Complete it
* Go to Process Request window
* Run Costing Background process

* Realize that the process ends successfully but the following message is obtained in Process Log:

"No average cost found for the product on a date"

Proposed Solution

The process should be able to calculate the cost of the product on that case looking at Costing tab of the Product and finding a valid Average Cost.

Additional Information