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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0050910
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 04. Warehouse managementmajoralways2022-11-08 14:392022-12-16 12:13
ReporterAtulOpenbravoView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in VersionPR22Q4.1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget VersionPR22Q4.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0050910: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0050776 closedTriage Omni WMS Error in InventoryCountProcess - constraint "m_storage_detail_check1" violation 

-  Notes
(0143638)
hgbot (developer)
2022-11-15 18:14

 Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/763 [^]
(0143639)
hgbot (developer)
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 (developer)
2022-11-15 18:15

 Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/763 [^]

- Issue History
Date Modified Username Field Change
2022-11-15 17:09 vmromanos Type defect => backport
2022-11-15 17:09 vmromanos Target Version => PR22Q4.1
2022-11-15 18:14 hgbot Note Added: 0143638
2022-11-15 18:15 hgbot Merge Request Status open => approved
2022-11-15 18:15 hgbot Resolution open => fixed
2022-11-15 18:15 hgbot Status scheduled => closed
2022-11-15 18:15 hgbot Fixed in Version => PR22Q4.1
2022-11-15 18:15 hgbot Note Added: 0143639
2022-11-15 18:15 hgbot Note Added: 0143640
2022-12-16 12:13 AtulOpenbravo Assigned To Triage Omni WMS => AtulOpenbravo

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker