Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0050910Openbravo ERP04. Warehouse managementpublic2022-11-08 14:392022-12-16 12:13
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionPR22Q4.1Fixed in VersionPR22Q4.1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0050910: Error in InventoryCountProcess - constraint "m_storage_detail_check1" violation
DescriptionWhen updating Inventory Count using InventoryCountProcess, DB constraint
m_storage_detail_check1 is not satisfied when m_product_uom_id IS NULL

qtyorderonhand IS NULL AND m_product_uom_id IS NULL AND preqtyorderonhand IS NULL

OR

qtyorderonhand IS NOT NULL AND m_product_uom_id IS NOT NULL AND preqtyorderonhand IS NOT NULL
Steps To Reproduce-
Proposed SolutionUse similar condition to set parameters to be sent to M_UPDATE_INVENTORY procedure i.e qtyorderonhand and preqtyorderonhand as in the parameter m_product_uom_id

invCountLine.getOrderUOM() != null ? BigDecimal.ZERO : null
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0050776 closed Triage Omni WMS Error in InventoryCountProcess - constraint "m_storage_detail_check1" violation 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-11-15 17:09vmromanosTypedefect => backport
2022-11-15 17:09vmromanosTarget Version => PR22Q4.1
2022-11-15 18:14hgbotNote Added: 0143638
2022-11-15 18:15hgbotResolutionopen => fixed
2022-11-15 18:15hgbotStatusscheduled => closed
2022-11-15 18:15hgbotFixed in Version => PR22Q4.1
2022-11-15 18:15hgbotNote Added: 0143639
2022-11-15 18:15hgbotNote Added: 0143640
2022-12-16 12:13AtulOpenbravoAssigned ToTriage Omni WMS => AtulOpenbravo

Notes
(0143638)
hgbot   
2022-11-15 18:14   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/763 [^]
(0143639)
hgbot   
2022-11-15 18:15   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 64a9aa517045b2b90180fe4273c30f8b235407b8
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 15-11-2022 18:10:24
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/64a9aa517045b2b90180fe4273c30f8b235407b8 [^]

Fixes BUG-0050910: Error in InventoryCountProcess - constraint
"m_storage_detail_check1" violation

**To fulfill DB m_storage_detail_check1 when OrderUOM is null,
QtyOrderOnHand and PreQtyOrderOnHand should be also null when
updating the inventory

---
M src/org/openbravo/materialmgmt/InventoryCountProcess.java
---
(0143640)
hgbot   
2022-11-15 18:15   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/763 [^]