0022913: Second UOM not shown when creating a receipt from an order that has been partially received

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0022913

Openbravo ERP

03. Procurement management

public

2013-01-28 16:20

2013-03-02 05:48

Reporter

ngarcia

Assigned To

jecharri

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0MP21

Fixed in Version

3.0MP21

Merge Request Status

Review Assigned To

ngarcia

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

0022913: Second UOM not shown when creating a receipt from an order that has been partially received

Description

Second UOM not shown when creating a receipt from an order that has been partially received

Steps To Reproduce

As system admin role:
   Activate the following tabs:
      Product - UOM
      Unit of Measure - Conversion
   and display at least the following fields:
      Purchase Order - Lines - Order Quantity
      Purchase Order - Lines - Order UOM
      Goods shipment - Lines - Order Quantity
      Goods shipment - Lines - Order UOM
As group admin role:
   Create a new product
   Define a purchase price list to it
   Configure a second unit of measure in the UOM tab
   Configure the conversion between the 1st and 2nd UOM in the Unit of Measure window
   Create a Sales Order and include a line with the product (fill the Order UOM and Order Quantity fields)
   Book it
   Create a Goods Receipt from it (Create Lines From)
   In the pop-up decrease the Order Quantity (2nd UOM)
   Complete it
   Create a new receipt from the same order
   Notice that the 2nd UOM field is empty

Proposed Solution

In CreateFrom_Shipment_data.xsql selectFromPO function, the secQty value is obtained using the c_uom_convert function

C_UOM_CONVERT(SUM(COALESCE(m.Qty,0)), l.C_UOM_ID, l.M_PRODUCT_UOM_ID, 'Y')

It takes as third attribute the m_product_uom_id column of the c_orderline table instead of the c_uom_id column of the m_product_uom table with the m_product_uom_id value.

Additional Information