Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0049238 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
design defect | [Openbravo ERP] 07. Sales management | minor | always | 2022-05-05 14:43 | 2022-10-06 14:48 | |||||||
Reporter | kousalya_r | View Status | public | |||||||||
Assigned To | Triage Omni OMS | |||||||||||
Priority | normal | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | PR20Q3.2 | SCM revision | ||||||||||
Merge Request Status | ||||||||||||
Review Assigned To | ||||||||||||
OBNetwork customer | OBPS | |||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Support ticket | 41937 | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0049238: Sales Order DeliveryStatus field shows 100% when it is not | |||||||||||
Description | In version PR20Q3.2, the Shipping Status field is rounding up to show that it is already 100% shipped, when it really is not. I enclose an image with an example of an order, this order is sent at 99.671%, since there are 4 lines to send but it shows 100%. | |||||||||||
Steps To Reproduce | Create sales order and deliver few quantities and check deliver status field is rounding up but it should not | |||||||||||
Proposed Solution | Use DeliveryStatus column reference from 'Integer' to 'Amount' and change SQL logic as below (coalesce((select case when sum(abs(ol.qtyordered)) = 0 or iscancelled = 'Y' or cancelledorder_id is not null then 0 else round(coalesce(sum(abs(ol.qtydelivered)), 0)/sum(abs(ol.qtyordered)) * 100, 2) end from c_orderline ol where ol.c_order_id=c_order_id and ol.c_order_discount_id is null),0)) | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ![]() ![]() | |||||||||||
![]() |
|
![]() |
|
(0137612) aferraz (viewer) 2022-05-23 13:49 |
Severity changed to minor as delivery status is an informative field that shows the approximate delivered percentage. Changing the reference of the column will create an API change. Besides, delivered field already displays if the order has been fully delivered or not. Attached a diff to change the rounding and the reference of Delivery Status, Invoice Status and Payment Status columns in case the customer wants to apply it. |
![]() |
|||
Date Modified | Username | Field | Change |
2022-05-05 14:43 | kousalya_r | New Issue | |
2022-05-05 14:43 | kousalya_r | Assigned To | => Triage Omni OMS |
2022-05-05 14:43 | kousalya_r | File Added: see100.jpg | |
2022-05-05 14:43 | kousalya_r | OBNetwork customer | => No |
2022-05-05 14:43 | kousalya_r | Modules | => Core |
2022-05-05 14:43 | kousalya_r | Triggers an Emergency Pack | => No |
2022-05-05 14:46 | kousalya_r | Support ticket | => 41937 |
2022-05-05 14:53 | eugeni | Issue Monitored: eugeni | |
2022-05-06 07:55 | kousalya_r | OBNetwork customer | No => Gold |
2022-05-06 09:33 | kousalya_r | OBNetwork customer | Gold => OBPS |
2022-05-23 13:49 | aferraz | Note Added: 0137612 | |
2022-05-23 13:50 | aferraz | Severity | major => minor |
2022-05-23 13:50 | aferraz | File Added: 49238.diff | |
2022-10-06 14:48 | aferraz | Type | defect => design defect |
Copyright © 2000 - 2009 MantisBT Group |