Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0054885ModulesAdvanced Warehouse Operationspublic2024-03-07 17:452024-06-14 11:08
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0054885: Storage Type for Goods Transaction - Data Model
DescriptionStorage Type: Create windows, tabs and fields. This should be done in AWO module

Storage Bin content restrictions: field and tab. Also the trigger to validate the restriction. This should be done in Core
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
causes defect 0055771 closed AtulOpenbravo Openbravo ERP Bins defined with Included Handling Unit Types = "Only those defined" block any transaction of individual items 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-03-07 17:45AtulOpenbravoNew Issue
2024-03-07 17:45AtulOpenbravoAssigned To => Triage Omni WMS
2024-03-07 17:45AtulOpenbravoOBNetwork customer => No
2024-03-07 17:50AtulOpenbravoAssigned ToTriage Omni WMS => AtulOpenbravo
2024-03-07 17:50AtulOpenbravoStatusnew => scheduled
2024-03-07 18:45hgbotMerge Request Status => open
2024-03-07 18:45hgbotNote Added: 0161866
2024-03-08 14:55hgbotNote Added: 0161908
2024-03-19 11:31hgbotNote Added: 0162353
2024-03-19 11:35hgbotNote Added: 0162354
2024-03-19 11:38hgbotNote Added: 0162355
2024-03-19 14:36hgbotNote Added: 0162367
2024-04-08 23:01hgbotMerge Request Statusopen => approved
2024-04-08 23:24hgbotResolutionopen => fixed
2024-04-08 23:24hgbotStatusscheduled => closed
2024-04-08 23:24hgbotNote Added: 0162937
2024-04-08 23:24hgbotFixed in Version => PR24Q3
2024-04-08 23:24hgbotNote Added: 0162938
2024-04-08 23:29hgbotNote Added: 0162939
2024-04-08 23:29hgbotNote Added: 0162940
2024-04-08 23:30hgbotNote Added: 0162941
2024-04-08 23:30hgbotNote Added: 0162942
2024-04-08 23:31hgbotNote Added: 0162943
2024-04-08 23:31hgbotNote Added: 0162944
2024-04-08 23:32hgbotNote Added: 0162946
2024-04-08 23:33hgbotNote Added: 0162947
2024-04-09 14:14hgbotNote Added: 0162992
2024-04-09 14:16hgbotNote Added: 0162993
2024-05-22 10:30hgbotNote Added: 0164937
2024-06-14 11:08vmromanosRelationship addedcauses 0055771

Notes
(0161866)
hgbot   
2024-03-07 18:45   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1163 [^]
(0161908)
hgbot   
2024-03-08 14:55   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/229 [^]
(0162353)
hgbot   
2024-03-19 11:31   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/90 [^]
(0162354)
hgbot   
2024-03-19 11:35   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/127 [^]
(0162355)
hgbot   
2024-03-19 11:38   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/89 [^]
(0162367)
hgbot   
2024-03-19 14:36   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata/-/merge_requests/27 [^]
(0162937)
hgbot   
2024-04-08 23:24   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1163 [^]
(0162938)
hgbot   
2024-04-08 23:24   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: a78d112574e55010efc7bf188f9a76fd2a931856
Author: Martin Taal <martin.taal@openbravo.com>
Date: 08-04-2024 23:24:19
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/a78d112574e55010efc7bf188f9a76fd2a931856 [^]

Fixes ISSUE-54885: Implemented Storage Type Data Model

---
A src-db/database/model/tables/M_LOCATOR_HU_TYPE.xml
A src-db/database/model/triggers/M_LOCATOR_HU_TYPE_TRG.xml
A src-test/src/org/openbravo/test/storageBin/StorageBinTest.java
A src-test/src/org/openbravo/test/storageBin/StorageBinTestUtils.java
M src-db/database/model/tables/M_LOCATOR.xml
M src-db/database/model/triggers/M_LOCATOR_TRG.xml
M src-db/database/model/triggers/M_TRANSACTION_TRG.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-test/src/org/openbravo/test/StandaloneTestSuite.java
M src-test/src/org/openbravo/test/inventoryStatus/InventoryStatusTest.java
M src-test/src/org/openbravo/test/referencedinventory/ReferencedInventoryTest.java
M src-test/src/org/openbravo/test/referencedinventory/ReferencedInventoryTestUtils.java
---
(0162939)
hgbot   
2024-04-08 23:29   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 8a7dd71b2560ffcd6520ac5ef5b97c5de5542ede
Author: Martin Taal <martin.taal@openbravo.com>
Date: 08-04-2024 23:29:02
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/8a7dd71b2560ffcd6520ac5ef5b97c5de5542ede [^]

Fixes ISSUE-54885: Storage Type Data Model

---
A src-db/database/model/modifiedTables/M_REFINVENTORY.xml
A src-db/database/model/tables/OBAWO_STORAGETYPE.xml
A src-db/database/model/tables/OBAWO_STORAGETYPE_PLMSTATUS.xml
A src-db/database/model/tables/OBAWO_STORAGETYPE_PROD.xml
A src-db/database/model/tables/OBAWO_STORAGETYPE_PRODCAT.xml
A src-db/database/model/tables/OBAWO_STORAGETYPE_WH.xml
A src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOst_StorageTypeTest.java
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src-db/database/sourcedata/AD_WINDOW.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-test/org/openbravo/warehouse/advancedwarehouseoperations/test/AWOTestSuite.java
---
(0162940)
hgbot   
2024-04-08 23:29   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/229 [^]
(0162941)
hgbot   
2024-04-08 23:30   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata [^]
Changeset: d53e089d78c17a0525dd1f011d89d7a58c2c45dc
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 08-04-2024 21:29:37
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/commit/d53e089d78c17a0525dd1f011d89d7a58c2c45dc [^]

Related to ISSUE-54885: Add new fields in retail sample data
related to M_Locator i.e Allow Storing Items and Included
Handling Unit Types.

---
M referencedata/sampledata/The_White_Valley_Group/M_LOCATOR.xml
---
(0162942)
hgbot   
2024-04-08 23:30   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/90 [^]
(0162943)
hgbot   
2024-04-08 23:31   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: fd3fd5a4e1ad154564f1696b5383cd897e14a1d3
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 08-04-2024 21:30:46
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/fd3fd5a4e1ad154564f1696b5383cd897e14a1d3 [^]

Related to ISSUE-54885:Add new fields in M_locator sample data
i.e Allow Storing Items and Included Handling Unit Types

---
M referencedata/sampledata/The_White_Valley_Group/M_LOCATOR.xml
---
(0162944)
hgbot   
2024-04-08 23:31   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/127 [^]
(0162946)
hgbot   
2024-04-08 23:32   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/89 [^]
(0162947)
hgbot   
2024-04-08 23:33   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata/-/merge_requests/27 [^]
(0162992)
hgbot   
2024-04-09 14:14   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.api [^]
Changeset: 7351d33e963eb4308e713d62b609f67591dbc84e
Author: Martin Taal <martin.taal@openbravo.com>
Date: 09-04-2024 14:14:09
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations.api/-/commit/7351d33e963eb4308e713d62b609f67591dbc84e [^]

Related to ISSUE-54885: Storage Type API definition

---
M examples/Openbravo AWO API.postman_collection.json
M src-db/database/sourcedata/API_EXPORT_FILTER.xml
M src-db/database/sourcedata/API_EXPORT_FILTER_PARAM.xml
M src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---
(0162993)
hgbot   
2024-04-09 14:16   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: f76644bf2d17fb50ab9601fd1ed8f3f2eb19833b
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 09-04-2024 12:16:32
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/f76644bf2d17fb50ab9601fd1ed8f3f2eb19833b [^]

Related To ISSUE-54885: Add tests for Storage Type API - Import and Export.

---
A src-test/data/export/filter/storagetype/StorageTypeById.json
A src-test/data/export/filter/storagetype/StorageTypeByName.json
A src-test/data/importer/StorageType.json
A src-test/data/importer/StorageTypeWithAllSelectionMode.json
A src-test/org/openbravo/api/tests/export/ApiExportStorageTypeFilters.java
A src-test/org/openbravo/api/tests/importer/ImportStorageType.java
M src-test/org/openbravo/api/tests/StandaloneTestSuite.java
M src-test/org/openbravo/api/tests/util/ApiTestConstants.java
---
(0164937)
hgbot   
2024-05-22 10:30   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 9ef132c272a82e0b3e64f45525997fb63ef22077
Author: Martin Taal <martin.taal@openbravo.com>
Date: 11-04-2024 23:25:27
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/9ef132c272a82e0b3e64f45525997fb63ef22077 [^]

Related to ISSUE-54885: Storage type field in handling unit should not be editable

---
---