0035337: [Negative Stock Correction]: Costing Background Process finishes with error if Warehouse dimension is selected in costing rule

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0035337

Openbravo ERP

04. Warehouse management

public

2017-02-22 12:06

2017-03-15 20:19

Reporter

ngarcia

Assigned To

collazoandy4

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

3.0PR17Q2

Merge Request Status

Review Assigned To

markmm82

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

0035337: [Negative Stock Correction]: Costing Background Process finishes with error if Warehouse dimension is selected in costing rule

Description

[Negative Stock Correction]: Costing Background Process finishes with error if Warehouse dimension is selected in costing rule

Steps To Reproduce

As group admin role:
As group admin role:
   Set the Enable Negative Stock Corrections preference to Y
   Select the Allow negative stock option at Client level
   Validate a Costing Rule in F&B España S.A. with warehouse dimension selected
   Create a new product
   Create a purchase order
   Add 10 units of the previously created product with a price of 5
   Create the goods receipt in España Region Norte warehouse from it
   Launch the Costing Background process and check it finishes with the following error:
      could not resolve property: storageBin.warehouse.id of: MaterialMgmtMaterialTransaction
   The log shows:
      ERROR org.openbravo.costing.CostingBackground - could not resolve property: storageBin.warehouse.id of: MaterialMgmtMaterialTransaction
org.hibernate.QueryException: could not resolve property: storageBin.warehouse.id of: MaterialMgmtMaterialTransaction
    at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:81)
        ...
    at org.openbravo.dal.service.OBCriteria.uniqueResult(OBCriteria.java:129)
    at org.openbravo.costing.CostingUtils.existsProcessedTransactions(CostingUtils.java:810)
    at org.openbravo.costing.CostingServer.checkCostAdjustments(CostingServer.java:334)
    at org.openbravo.costing.CostingServer.process(CostingServer.java:132)
    at org.openbravo.costing.CostingBackground.doExecute(CostingBackground.java:129)
        ...

Proposed Solution

Use an alias in the criteria for the MaterialTransaction.PROPERTY_STORAGEBIN in existsProcessedTransactions function of CostingUtils class

Additional Information