Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0058124POS2POSpublic2025-02-27 10:322025-03-11 12:59
Reportermalsasua 
Assigned Tocberner 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version25Q1.1Fixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket122789
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0058124: updating to 24Q4, the invariants stock option is disabled
DescriptionUpdating from 24Q2 to 24Q4, the invariants stock option is disabled in some products (see attachment1).

After update, the following query should not return results:
select count(1)
from m_product
where row_characteristic <> em_obdest_rcharacteristic
or column_characteristic <> em_obdest_ccharacteristic
or characteristicdimensionenabled <> em_obdest_enabled

During the update, the modulescript MigrateDetailedStockColumnsToCharacteristicDimensions was executed
Steps To Reproducein 24Q2
. login in POS2
. add one line
. click in the line -> Product Card -> Other Stock -> 3 points:
the Product Variant Stock option is enabled
update to 24Q4
. login in POS2
. add one line
. click in the line -> Product Card -> Other Stock -> 3 points:
the Product Variant Stock option is disabled

Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0058092 closed cberner updating to 24Q4, the invariants stock option is disabled 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2025-03-03 12:34cbernerTypedefect => backport
2025-03-03 12:34cbernerTarget Version => 25Q1.1
2025-03-10 18:18hgbotMerge Request Status => open
2025-03-10 18:18hgbotNote Added: 0176632
2025-03-11 11:38hgbotMerge Request Statusopen => approved
2025-03-11 12:59hgbotNote Added: 0176662
2025-03-11 12:59hgbotResolutionopen => fixed
2025-03-11 12:59hgbotStatusscheduled => closed
2025-03-11 12:59hgbotNote Added: 0176663

Notes
(0176632)
hgbot   
2025-03-10 18:18   
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/merge_requests/17 [^]
(0176662)
hgbot   
2025-03-11 12:59   
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/merge_requests/17 [^]
(0176663)
hgbot   
2025-03-11 12:59   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock [^]
Changeset: 9e96af5012408f1896870f5369c08ac394555fa3
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 10-03-2025 18:17:48
URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.pos2.detailedstock/-/commit/9e96af5012408f1896870f5369c08ac394555fa3 [^]

Fixes ISSUE-58124: updating to 24Q4, the invariants stock option is disabled

The modulescript was failing to update from 24Q2 to 24Q4 in several
cases, it seems the problem comes from the column check of
characteristicdimensionenabled, when it is null, the where clause
returns false incorrectly.

characteristicdimensionenabled <> em_obdest_enabled -> returns false
when the former is NULL
NULL <> 'N'/'Y' -> Returns false

---
M build/classes/org/openbravo/pos2/detailedstock/modulescript/MigrateDetailedStockColumnsToCharacteristicDimensions.class
M src-util/modulescript/src/org/openbravo/pos2/detailedstock/modulescript/MigrateDetailedStockColumnsToCharacteristicDimensions.java
---