Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0031126Openbravo ERP07. Sales managementpublic2015-10-09 14:012015-10-09 14:01
ngarcia 
Triage Finance 
highminoralways
newopen 
5
 
 
Core
No
0031126: It would be fine if it could be configured the delivery status of sales order not to be higher than 100%
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
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%
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))
No tags attached.
related to defect 0036552 scheduled collazoandy4 Sales Order as not Delivered when a product configured as Is Quantity Variable is included on it and more quantity is delivered 
Issue History
2015-10-09 14:01ngarciaNew Issue
2015-10-09 14:01ngarciaAssigned To => Triage Finance
2015-10-09 14:01ngarciaModules => Core
2015-10-09 14:01ngarciaTriggers an Emergency Pack => No
2017-07-31 17:43ngarciaRelationship addedrelated to 0036552

There are no notes attached to this issue.