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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0049238
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 07. Sales managementminoralways2022-05-05 14:432022-10-06 14:48
Reporterkousalya_rView Statuspublic 
Assigned ToTriage Omni OMS 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionPR20Q3.2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0049238: Sales Order DeliveryStatus field shows 100% when it is not

DescriptionIn 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 ReproduceCreate sales order and deliver few quantities and check deliver status field is rounding up but it should not
Proposed SolutionUse 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))
TagsNo tags attached.
Attached Filesjpg file icon see100.jpg [^] (250,113 bytes) 2022-05-05 14:43


diff file icon 49238.diff [^] (6,075 bytes) 2022-05-23 13:50 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0137612)
aferraz (manager)
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.

- Issue History
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 Modules => Core
2022-05-05 14:43 kousalya_r Triggers an Emergency Pack => No
2022-05-05 14:53 eugeni Issue Monitored: eugeni
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
Powered by Mantis Bugtracker