0036194: Cannot select an order line in Create Lines From of Goods Receipt window if it uses secondary UOM

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0036194

Openbravo ERP

04. Warehouse management

public

2017-06-06 13:55

2017-06-09 13:27

Reporter

ngarcia

Assigned To

markmm82

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0PR17Q2.1

Fixed in Version

3.0PR17Q2.1

Merge Request Status

Review Assigned To

aferraz

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

47038

Regression level

Production - Confirmed Stable

Regression date

2016-12-02

Regression introduced in release

3.0PR17Q1

Regression introduced by commit

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

Triggers an Emergency Pack

Summary

0036194: Cannot select an order line in Create Lines From of Goods Receipt window if it uses secondary UOM

Description

Cannot select an order line in Create Lines From of Goods Receipt window if it uses secondary UOM

Steps To Reproduce

As system admin role:
   Set as displayed the 'Order Quantity' and 'Order UOM' fields of at least purchase order and goods receipt lines
   Set as active 'Product - UOM' and 'Unit Of Measure - Conversion' tabs

As group admin role:
   Create a new product
   Add a purchase price list to it
   Set a unit in the UOM tab, for example Kg
   Define a conversion between Kg and Unit
   Create a purchase order, add a line to it and include the previously created order
   Select Kg in Order UOM field and set the quantity in Order Quantity field
   Book it
   Create a Goods Receipt header
   Click on Create Lines From and select the already created order line
   Add a storage bin and click on OK
   Check the following error message is shown:

     "This record cannot be deleted because it is associated with other existing elements. Please see Linked Items"

   The logs shows:

   ERROR org.openbravo.erpCommon.ad_actionButton.CreateFromShipmentData - SQL error in query: INSERT INTO M_INOUTLINE ...

Exception:org.postgresql.util.PSQLException: ERROR: insert or update on table "m_inoutline" violates foreign key constraint "m_inoutline_m_product_uom"
  Detail: Key (m_product_uom_id)=(72BA247D31F745F3AF11F74A5E2CCBEF) is not present in table "m_product_uom".

Proposed Solution

Additional Information