Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031126
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 07. Sales managementminoralways2015-10-09 14:012015-10-09 14:01
ReporterngarciaView Statuspublic 
Assigned ToTriage Finance 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

DescriptionIt 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 ReproduceAs 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 SolutionThe 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))
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0036552 scheduledcollazoandy4 Sales Order as not Delivered when a product configured as Is Quantity Variable is included on it and more quantity is delivered 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-10-09 14:01 ngarcia New Issue
2015-10-09 14:01 ngarcia Assigned To => Triage Finance
2015-10-09 14:01 ngarcia Modules => Core
2015-10-09 14:01 ngarcia Triggers an Emergency Pack => No
2017-07-31 17:43 ngarcia Relationship added related to 0036552


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker