0031126: It would be fine if it could be configured the delivery status of sales order not to be higher than 100%

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0031126

Openbravo ERP

07. Sales management

public

2015-10-09 14:01

Reporter

ngarcia

Assigned To

Triage Omni OMS

Priority

high

Severity

minor

Reproducibility

always

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Modules

Core

Support ticket

34290

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0031126: It would be fine if it could be configured the delivery status of sales order not to be higher than 100%

Description

It would be fine if it could be configured the delivery status of sales order not to be higher than 100%. This only happens when a product set as Is Quantity Variable is included.

It should be configurable as there could be customers that would like to see a value higher than 100% where more units have been delivered

Steps To Reproduce

As system admin role:
   Display the Is Quantity Variable field of the Product window
As group admin role:
   Set a product with stock as Is Quantity Variable
   Create a Sales Order
   Include 3 units of that product
   Include 1 unit of another product
   Book it
   Create a Goods Shipment
   Add a line of 4 units associated to the first line of the order
   Complete it
   Go to Sales Order screen and check the Delivery status is 100% while a unit is pending to be delivered
   Create a Goods Shipment for the pending unit and complete it
   Go to Sales Order screen and check the Delivery status is 125%

Proposed Solution

The new Sqllogic of the deliverystatus column of the c_order tables should be something like:

(coalesce((select case when sum(abs(ol.qtyordered)) = 0 then 0 else
trunc(coalesce(sum(abs(least(ol.qtydelivered,ol.qtyordered))), 0)/sum(abs(ol.qtyordered)) * 100) end
from c_orderline ol where ol.c_order_id=c_order_id and ol.c_order_discount_id is null
),0))

Additional Information