Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052419Openbravo ERP04. Warehouse managementpublic2023-05-11 12:262023-06-07 11:39
ReporterSandrahuguet 
Assigned ToTriage Omni WMS 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR23Q3 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0052419: Total Physical Inventory creation and stock level export
DescriptionThe aim of this project is to provide the ability of Export the total inventory of the Stores in order to provide it to the third party company in charge of counting the Store total Stock.
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-05-11 12:26SandrahuguetNew Issue
2023-05-11 12:26SandrahuguetAssigned To => Triage Omni WMS
2023-05-11 12:26SandrahuguetOBNetwork customer => No
2023-05-11 12:26SandrahuguetModules => Core
2023-05-11 12:26SandrahuguetTriggers an Emergency Pack => No
2023-05-11 12:56hgbotMerge Request Status => open
2023-05-11 12:56hgbotNote Added: 0149618
2023-05-16 13:16hgbotNote Added: 0149824
2023-05-16 13:51hgbotNote Added: 0149827
2023-05-16 14:19hgbotNote Added: 0149831
2023-05-16 15:05hgbotNote Added: 0149837
2023-05-19 11:35hgbotNote Added: 0149969
2023-05-22 14:49hgbotMerge Request Statusopen => approved
2023-05-31 11:06hgbotNote Added: 0150530
2023-06-01 13:41hgbotResolutionopen => fixed
2023-06-01 13:41hgbotStatusnew => closed
2023-06-01 13:41hgbotFixed in Version => PR23Q3
2023-06-01 13:41hgbotNote Added: 0150594
2023-06-01 13:41hgbotNote Added: 0150595
2023-06-01 13:41hgbotNote Added: 0150596
2023-06-01 13:41hgbotNote Added: 0150597
2023-06-01 13:41hgbotNote Added: 0150598
2023-06-01 13:41hgbotNote Added: 0150599
2023-06-01 13:41hgbotNote Added: 0150600
2023-06-01 13:41hgbotNote Added: 0150601
2023-06-01 13:41hgbotNote Added: 0150602
2023-06-01 13:41hgbotNote Added: 0150603
2023-06-01 13:41hgbotNote Added: 0150604
2023-06-02 08:04hgbotNote Added: 0150628
2023-06-02 08:04hgbotNote Added: 0150629
2023-06-02 08:07hgbotNote Added: 0150630
2023-06-02 08:07hgbotNote Added: 0150631
2023-06-02 12:20hgbotNote Added: 0150655
2023-06-02 13:05hgbotNote Added: 0150669
2023-06-02 13:05hgbotNote Added: 0150670
2023-06-02 14:02hgbotNote Added: 0150671
2023-06-02 15:07hgbotNote Added: 0150673
2023-06-06 09:46hgbotNote Added: 0150777
2023-06-06 09:58hgbotNote Added: 0150778
2023-06-06 13:35hgbotNote Added: 0150805
2023-06-07 08:36hgbotNote Added: 0150845
2023-06-07 08:36hgbotNote Added: 0150846
2023-06-07 08:36hgbotNote Added: 0150847
2023-06-07 08:36hgbotNote Added: 0150848
2023-06-07 11:39hgbotNote Added: 0150861
2023-06-07 11:39hgbotNote Added: 0150862
2023-06-07 11:39hgbotNote Added: 0150863

Notes
(0149618)
hgbot   
2023-05-11 12:56   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/881 [^]
(0149824)
hgbot   
2023-05-16 13:16   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata/-/merge_requests/18 [^]
(0149827)
hgbot   
2023-05-16 13:51   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/76 [^]
(0149831)
hgbot   
2023-05-16 14:19   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/49 [^]
(0149837)
hgbot   
2023-05-16 15:05   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/54 [^]
(0149969)
hgbot   
2023-05-19 11:35   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/146 [^]
(0150530)
hgbot   
2023-05-31 11:06   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/38 [^]
(0150594)
hgbot   
2023-06-01 13:41   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: f04185bc44374726fc056f7c66ac72195f9a3263
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 01-06-2023 13:40:22
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/f04185bc44374726fc056f7c66ac72195f9a3263 [^]

Fixed ISSUE-52419 Merge branch 'fr/52419'

---
A src/org/openbravo/common/actionhandler/ExportPhysicalInventoryLinesToCSV.java
A src/org/openbravo/event/PhysicalInventoryEventHandler.java
M referencedata/sampledata/F_B_International_Group/AD_SEQUENCE.xml
M referencedata/sampledata/F_B_International_Group/C_DOCTYPE.xml
M referencedata/sampledata/QA_Testing/AD_SEQUENCE.xml
M referencedata/sampledata/QA_Testing/C_DOCTYPE.xml
M src-db/database/model/tables/M_INVENTORY.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_REF_LIST.xml
M src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
M src-db/database/sourcedata/OBUIAPP_PROCESS.xml
---
(0150595)
hgbot   
2023-06-01 13:41   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/881 [^]
(0150596)
hgbot   
2023-06-01 13:41   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata [^]
Changeset: 7151daf5a636032c8020678c253b33b50ddc07bb
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 01-06-2023 10:21:08
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/commit/7151daf5a636032c8020678c253b33b50ddc07bb [^]

related to ISSUE-52419 update sampledata

---
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE_TRL.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml
M referencedata/sampledata/The_White_Valley_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0150597)
hgbot   
2023-06-01 13:41   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.sampledata/-/merge_requests/54 [^]
(0150598)
hgbot   
2023-06-01 13:41   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata [^]
Changeset: bf070c8e16aa74061d62d8f06be6759874bc106e
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 01-06-2023 10:24:12
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/commit/bf070c8e16aa74061d62d8f06be6759874bc106e [^]

related to ISSUE-52419 update sampledata

---
M referencedata/sampledata/Retail_Test/AD_SEQUENCE.xml
M referencedata/sampledata/Retail_Test/C_DOCTYPE.xml
M referencedata/sampledata/Retail_Test/C_DOCTYPE_TRL.xml
M referencedata/sampledata/Retail_Test/M_INVENTORY.xml
M referencedata/sampledata/Retail_Test/OBUIAPP_PROCESS_ACCESS.xml
---
(0150599)
hgbot   
2023-06-01 13:41   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.testsampledata/-/merge_requests/49 [^]
(0150600)
hgbot   
2023-06-01 13:41   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 12ff27cbb8c5161b3703808292db2d5f31137268
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 01-06-2023 10:29:23
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/12ff27cbb8c5161b3703808292db2d5f31137268 [^]

related to ISSUE-52419 update sampledata

---
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE.xml
M referencedata/sampledata/The_White_Valley_Group/C_DOCTYPE_TRL.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml
M referencedata/sampledata/The_White_Valley_Group/OBUIAPP_PROCESS_ACCESS.xml
---
(0150601)
hgbot   
2023-06-01 13:41   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/76 [^]
(0150602)
hgbot   
2023-06-01 13:41   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata [^]
Changeset: d2dc212f334a5d904f665495aa43f5011bc20f33
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 16-05-2023 13:14:51
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata/-/commit/d2dc212f334a5d904f665495aa43f5011bc20f33 [^]

related to ISSUE-52419 update m_inventory sequence

---
M referencedata/sampledata/AWO_QA/AD_SEQUENCE.xml
---
(0150603)
hgbot   
2023-06-01 13:41   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata [^]
Changeset: 468f187a9c5aaf4ea594d56890c8016480d25fc5
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 24-05-2023 10:08:39
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata/-/commit/468f187a9c5aaf4ea594d56890c8016480d25fc5 [^]

related to ISSUE-52419 delete not used doctype

---
M referencedata/sampledata/AWO_QA/AD_SEQUENCE.xml
M referencedata/sampledata/AWO_QA/C_DOCTYPE.xml
---
(0150604)
hgbot   
2023-06-01 13:41   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.warehouse.advancedwarehouseoperations.sampledata/-/merge_requests/18 [^]
(0150628)
hgbot   
2023-06-02 08:04   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 20f7979852ddbef3d4e8cf9128c2fde8a1cafc2f
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 02-06-2023 08:03:59
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/20f7979852ddbef3d4e8cf9128c2fde8a1cafc2f [^]

related to ISSUE-52419 added documentNo to the Inventory API

---
M examples/Openbravo 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_PROP_MAP_INSTANCE.xml
---
(0150629)
hgbot   
2023-06-02 08:04   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/146 [^]
(0150630)
hgbot   
2023-06-02 08:07   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: 74b7d1913e9bfa3416953020f5d23bc0a8401fdf
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 02-06-2023 08:06:27
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/74b7d1913e9bfa3416953020f5d23bc0a8401fdf [^]

related to ISSUE-52419 added tests to documentNo filter

---
A src-test/data/export/filter/inventory/InventoryByDocumentNo.json
M src-test/org/openbravo/api/tests/export/ApiExportInventoryFilters.java
M src-test/org/openbravo/api/tests/util/ApiTestConstants.java
---
(0150631)
hgbot   
2023-06-02 08:07   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/38 [^]
(0150655)
hgbot   
2023-06-02 12:20   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms/-/merge_requests/5 [^]
(0150669)
hgbot   
2023-06-02 13:05   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms [^]
Changeset: d3c465d81978f2f789d9903588a31cd9cb767b02
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 02-06-2023 12:55:10
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms/-/commit/d3c465d81978f2f789d9903588a31cd9cb767b02 [^]

related to ISSUE-52419 add mock to avoid the failure in SetDocumentNoHandler

---
M src-test/org/openbravo/oms/test/engine/OMSTestRunner.java
---
(0150670)
hgbot   
2023-06-02 13:05   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms/-/merge_requests/5 [^]
(0150671)
hgbot   
2023-06-02 14:02   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms [^]
Changeset: d4f3192a70ae9cfb785a27156ed7b91de003e22c
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 02-06-2023 14:02:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.oms/-/commit/d4f3192a70ae9cfb785a27156ed7b91de003e22c [^]

related to ISSUE-52419 updated comment

---
M src-test/org/openbravo/oms/test/engine/OMSTestRunner.java
---
(0150673)
hgbot   
2023-06-02 15:07   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: 6220e97192e786daa4632a3c5d905ae5336309de
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 02-06-2023 15:06:55
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/6220e97192e786daa4632a3c5d905ae5336309de [^]

related to ISSUE-52419 disable tests

---
M src-test/org/openbravo/api/tests/export/ApiExportInventoryFilters.java
---
(0150777)
hgbot   
2023-06-06 09:46   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/39 [^]
(0150778)
hgbot   
2023-06-06 09:58   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/81 [^]
(0150805)
hgbot   
2023-06-06 13:35   
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/294 [^]
(0150845)
hgbot   
2023-06-07 08:36   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 287e03e7cdf04b0bcf6efeebb9b2a5a9038872e4
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 06-06-2023 09:57:39
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/287e03e7cdf04b0bcf6efeebb9b2a5a9038872e4 [^]

related to ISSUE-52419 update sampledata

---
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORYLINE.xml
M referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml
---
(0150846)
hgbot   
2023-06-07 08:36   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/81 [^]
(0150847)
hgbot   
2023-06-07 08:36   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: bf816abd9979376e6765623aecc459e1988b9b04
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 06-06-2023 09:45:27
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/bf816abd9979376e6765623aecc459e1988b9b04 [^]

related to ISSUE-52419 fix test

---
M src-test/data/export/filter/inventory/InventoryByDocumentNo.json
M src-test/org/openbravo/api/tests/export/ApiExportInventoryFilters.java
M src-test/org/openbravo/api/tests/util/ApiTestConstants.java
---
(0150848)
hgbot   
2023-06-07 08:36   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/39 [^]
(0150861)
hgbot   
2023-06-07 11:39   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: 2e8f9ba52438e410dbb492e21a721228ba0aac3c
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 06-06-2023 13:35:09
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/2e8f9ba52438e410dbb492e21a721228ba0aac3c [^]

related to ISSUE-52419 fixed oracle failures

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLines.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLinesMultitax.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLinesMultitaxNotIncludeTaxes.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLinesNotIncludeTaxes.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/I35216_VerifyCashUpSplitLines.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/crossstore/I44810_VerifyCheckStockForServices.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/returns/I33274_VerifyReturnWithMultiShipment.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/returns/I33274_VerifyReturnWithMultiShipmentII.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/returns/I46654_VerifyReturnWithMultiShipment.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/sales/I30734_CheckWarehouseByLine.java
---
(0150862)
hgbot   
2023-06-07 11:39   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: 7cab6e3316c2ce1baba46240165c511b0d91a65d
Author: Sandra Huguet <sandra.huguet@openbravo.com>
Date: 07-06-2023 08:26:58
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/7cab6e3316c2ce1baba46240165c511b0d91a65d [^]

related to ISSUE-52419

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLines.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLinesMultitax.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLinesMultitaxNotIncludeTaxes.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/CashUpSplitLinesNotIncludeTaxes.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/cashup/I35216_VerifyCashUpSplitLines.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/crossstore/I44810_VerifyCheckStockForServices.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/returns/I33274_VerifyReturnWithMultiShipment.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/returns/I33274_VerifyReturnWithMultiShipmentII.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/returns/I46654_VerifyReturnWithMultiShipment.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/sales/I30734_CheckWarehouseByLine.java
---
(0150863)
hgbot   
2023-06-07 11:39   
Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/294 [^]