Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049426Openbravo ERP04. Warehouse managementpublic2022-05-27 09:232022-07-01 14:34
Reporterprakashmurugesan88 
Assigned ToTriage Omni WMS 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0049426: Openbravo API to support Distribution Order
DescriptionCreate API to:
1. Import Distribution Order into Openbravo
2. Export Distribution Order from Openbravo
Steps To ReproduceNA
Proposed SolutionExtend the Openbravo API to support importing/exporting Distribution Order documents
Additional Information
TagsFASH
Relationships
related to feature request 0049651 new Triage Platform Conn Modules Unable to validate the whether the object is new (created) or not (updated) on the after flush hook in Import API 
related to defect 0049779 closed Triage Omni WMS Modules Distribution Order API bug when close DOi after update "qtyIssued" 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-05-27 09:23prakashmurugesan88New Issue
2022-05-27 09:23prakashmurugesan88Assigned To => Triage Omni WMS
2022-05-27 09:23prakashmurugesan88Modules => Core
2022-05-27 09:23prakashmurugesan88Triggers an Emergency Pack => No
2022-05-28 11:54hgbotNote Added: 0137838
2022-06-03 07:31hgbotNote Added: 0138011
2022-06-03 07:32hgbotNote Added: 0138012
2022-06-07 16:49hgbotNote Added: 0138120
2022-06-09 19:46vmromanosNote Deleted: 0137838
2022-06-09 19:46vmromanosNote Deleted: 0138012
2022-06-09 20:30hgbotNote Added: 0138230
2022-06-10 16:22hgbotNote Added: 0138279
2022-06-10 16:22hgbotResolutionopen => fixed
2022-06-10 16:22hgbotStatusnew => closed
2022-06-10 16:22hgbotNote Added: 0138280
2022-06-10 16:22hgbotNote Added: 0138281
2022-06-10 16:22hgbotNote Added: 0138282
2022-06-10 16:22hgbotNote Added: 0138283
2022-06-10 16:22hgbotNote Added: 0138284
2022-06-10 16:22hgbotNote Added: 0138285
2022-06-10 16:22hgbotNote Added: 0138286
2022-06-10 16:22hgbotNote Added: 0138287
2022-06-10 16:22hgbotNote Added: 0138288
2022-06-13 16:14hgbotNote Added: 0138316
2022-06-14 11:16hgbotNote Added: 0138332
2022-06-16 12:59hgbotNote Added: 0138414
2022-06-16 12:59hgbotNote Added: 0138415
2022-06-16 12:59hgbotNote Added: 0138416
2022-06-16 12:59hgbotNote Added: 0138417
2022-06-17 12:34hgbotNote Added: 0138491
2022-06-17 13:02hgbotNote Added: 0138492
2022-06-17 14:48hgbotNote Added: 0138524
2022-06-17 14:48hgbotNote Added: 0138525
2022-06-17 15:42rafarodaTag Attached: FASH
2022-06-18 11:32hgbotNote Added: 0138535
2022-06-27 10:20caristuRelationship addedrelated to 0049651
2022-07-01 14:32hgbotNote Added: 0138933
2022-07-01 14:32hgbotNote Added: 0138934
2022-07-01 14:33hgbotNote Added: 0138935
2022-07-01 14:33hgbotNote Added: 0138936
2022-07-01 14:34hgbotNote Added: 0138937
2022-07-01 14:34hgbotNote Added: 0138938
2022-07-11 14:49avicenteRelationship addedrelated to 0049779

Notes
(0138011)
hgbot   
2022-06-03 07:31   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/1 [^]
(0138120)
hgbot   
2022-06-07 16:49   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/18 [^]
(0138230)
hgbot   
2022-06-09 20:30   
Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/10 [^]
(0138279)
hgbot   
2022-06-10 16:22   
Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/10 [^]
(0138280)
hgbot   
2022-06-10 16:22   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder [^]
Changeset: 2e7b155d8f411ae1b46ce41d18a0b3c0fc42f7b6
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 10-06-2022 16:19:14
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/commit/2e7b155d8f411ae1b46ce41d18a0b3c0fc42f7b6 [^]

Fixed ISSUE-49426: Openbravo API to support Distribution Order

---
A src/org/openbravo/distributionorder/hooks/AfterUpdateDistributionOrderFromGoodsMovementHook.java
A src/org/openbravo/distributionorder/hooks/AfterUpdateDistributionOrderFromGoodsMovementHookRunner.java
M src/org/openbravo/distributionorder/erpCommon/utility/DistributioOrderUtils.java
M src/org/openbravo/distributionorder/erpCommon/utility/ProcessDistributionOrderUtil.java
---
(0138281)
hgbot   
2022-06-10 16:22   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api [^]
Changeset: cdec8ebacadc24562245873ee6632c0defb4028c
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 10-06-2022 16:16:23
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/commit/cdec8ebacadc24562245873ee6632c0defb4028c [^]

Fixed ISSUE-49426: Openbravo API to support Distribution Order

---
A examples/Distribution Order API.postman_collection.json
A examples/README
A src-db/database/sourcedata/AD_MODULE.xml
A src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
A src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
A src-db/database/sourcedata/API_EXPORT_FILTER.xml
A src-db/database/sourcedata/API_EXPORT_FILTER_PARAM.xml
A src-db/database/sourcedata/CNC_PUBLIC_EVENTS.xml
A src-db/database/sourcedata/OBEI_ENTITY_MAPPING.xml
A src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
A src/org/openbravo/distributionorder/api/event/distributionorder/DistributionOrderLinesEventHandler.java
A src/org/openbravo/distributionorder/api/hook/distributionorder/ImportDOBaseOBObjectFetcher.java
A src/org/openbravo/distributionorder/api/hook/distributionorder/ImportedDOBaseOBObjectAfterFlushHook.java
A src/org/openbravo/distributionorder/api/hook/distributionorderline/ImportDOLineOBObjectInitializer.java
A src/org/openbravo/distributionorder/api/mappings/distributionorder/ExportDOJavaPropertyMappingHandler.java
A src/org/openbravo/distributionorder/api/mappings/distributionorder/ImportDOJavaPropertyMappingHandler.java
A src/org/openbravo/distributionorder/api/mappings/distributionorderline/ImportDOLineJavaPropertyMappingHandler.java
A src/org/openbravo/distributionorder/api/push/UpdateDOQuantitiesEvent.java
A src/org/openbravo/distributionorder/api/push/UpdateDOStatusEvent.java
---
(0138282)
hgbot   
2022-06-10 16:22   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/1 [^]
(0138283)
hgbot   
2022-06-10 16:22   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: 71bc3b4d41dc0406d0e1b1772dc4059306f0925c
Author: Prakash M <prakash@qualiantech.com>
Date: 09-06-2022 16:03:18
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/71bc3b4d41dc0406d0e1b1772dc4059306f0925c [^]

Related to ISSUE-49426: Added test for Distribution Order API Import and Export

---
A src-test/data/export/filter/distributionorder/DOByDocumentNo.json
A src-test/data/export/filter/distributionorder/DOById.json
A src-test/data/importer/DistributionOrderIssue.json
A src-test/data/importer/DistributionOrderReceipt.json
A src-test/org/openbravo/api/tests/export/ApiExportDistributionOrderFilters.java
A src-test/org/openbravo/api/tests/importer/ImportDistributionOrder.java
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src-test/org/openbravo/api/tests/StandaloneTestSuite.java
M src-test/org/openbravo/api/tests/util/ApiTestConstants.java
---
(0138284)
hgbot   
2022-06-10 16:22   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: b4a8e278d2185e3325e63702af06718c7164d410
Author: Prakash M <prakash@qualiantech.com>
Date: 09-06-2022 16:03:23
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/b4a8e278d2185e3325e63702af06718c7164d410 [^]

Related to ISSUE-49426: Added new verification to Distribution Order API Import Test

---
M src-test/org/openbravo/api/tests/importer/ImportDistributionOrder.java
---
(0138285)
hgbot   
2022-06-10 16:22   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: ef8787140eebc96f6d98223fb21a4ee5820a51ec
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 09-06-2022 18:25:50
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/ef8787140eebc96f6d98223fb21a4ee5820a51ec [^]

Related to ISSUE-49426: Enabled DO import tests

---
M src-test/org/openbravo/api/tests/StandaloneTestSuite.java
---
(0138286)
hgbot   
2022-06-10 16:22   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: b775f7e68bd44aa1ea66ade6e6e4abd25a5d83e7
Author: Prakash M <prakash@qualiantech.com>
Date: 10-06-2022 18:39:29
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/b775f7e68bd44aa1ea66ade6e6e4abd25a5d83e7 [^]

Related to ISSUE-49426: Fixes DO API tests

---
M src-test/data/export/filter/distributionorder/DOByDocumentNo.json
M src-test/data/export/filter/distributionorder/DOById.json
M src-test/data/importer/DistributionOrderIssue.json
M src-test/data/importer/DistributionOrderReceipt.json
M src-test/org/openbravo/api/tests/export/ApiExportDistributionOrderFilters.java
---
(0138287)
hgbot   
2022-06-10 16:22   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: 638ce4cdb4fe201e8a2f127b52b5cdb158fbfba4
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 10-06-2022 16:21:16
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/638ce4cdb4fe201e8a2f127b52b5cdb158fbfba4 [^]

Fixed ISSUE-49426: Openbravo API to support Distribution Order

---
A src-test/data/export/filter/distributionorder/DOByDocumentNo.json
A src-test/data/export/filter/distributionorder/DOById.json
A src-test/data/importer/DistributionOrderIssue.json
A src-test/data/importer/DistributionOrderReceipt.json
A src-test/org/openbravo/api/tests/export/ApiExportDistributionOrderFilters.java
A src-test/org/openbravo/api/tests/importer/ImportDistributionOrder.java
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
M src-test/org/openbravo/api/tests/StandaloneTestSuite.java
M src-test/org/openbravo/api/tests/util/ApiTestConstants.java
---
(0138288)
hgbot   
2022-06-10 16:22   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/18 [^]
(0138316)
hgbot   
2022-06-13 16:14   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/2 [^]
(0138332)
hgbot   
2022-06-14 11:16   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/19 [^]
(0138414)
hgbot   
2022-06-16 12:59   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api [^]
Changeset: b279db80e51733c681db4a7d0698cab2697fda73
Author: Prakash M <prakash@qualiantech.com>
Date: 16-06-2022 10:59:05
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/commit/b279db80e51733c681db4a7d0698cab2697fda73 [^]

Related to ISSUE-49426: Manage Close DO from API

---
A src/org/openbravo/distributionorder/api/hook/distributionorder/ImportDOUtils.java
A src/org/openbravo/distributionorder/api/hook/distributionorderline/ImportDOLineBaseOBObjectFetcher.java
M examples/Distribution Order API.postman_collection.json
M src/org/openbravo/distributionorder/api/hook/distributionorder/ImportDOBaseOBObjectFetcher.java
M src/org/openbravo/distributionorder/api/hook/distributionorder/ImportedDOBaseOBObjectAfterFlushHook.java
M src/org/openbravo/distributionorder/api/mappings/distributionorder/ImportDOJavaPropertyMappingHandler.java
M src/org/openbravo/distributionorder/api/mappings/distributionorderline/ImportDOLineJavaPropertyMappingHandler.java
---
(0138415)
hgbot   
2022-06-16 12:59   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/2 [^]
(0138416)
hgbot   
2022-06-16 12:59   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: ebad074887e8767d81f9715f326ac421ba8d1169
Author: Prakash M <prakash@qualiantech.com>
Date: 16-06-2022 10:59:22
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/ebad074887e8767d81f9715f326ac421ba8d1169 [^]

Related to ISSUE-49426: Manage Close DO from API

---
A src-test/data/importer/DistributionOrderIssueBook.json
A src-test/data/importer/DistributionOrderIssueClose.json
A src-test/data/importer/DistributionOrderIssueDraft.json
A src-test/data/importer/DistributionOrderReceiptBook.json
A src-test/data/importer/DistributionOrderReceiptClose.json
A src-test/data/importer/DistributionOrderReceiptDraft.json
M src-test/org/openbravo/api/tests/importer/ImportDistributionOrder.java
---
(0138417)
hgbot   
2022-06-16 12:59   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/19 [^]
(0138491)
hgbot   
2022-06-17 12:34   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/3 [^]
(0138492)
hgbot   
2022-06-17 13:02   
Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/11 [^]
(0138524)
hgbot   
2022-06-17 14:48   
Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder [^]
Changeset: a36ab5d37d3742bfc6cd045c2480e235bb2431ce
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 17-06-2022 14:45:01
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/commit/a36ab5d37d3742bfc6cd045c2480e235bb2431ce [^]

Related to ISSUE-49426: Moved runAfterDistributionOrderProcessedHooks

It's launched at updateDistributionOrder, which is the real place where
the lines are updated

---
M src/org/openbravo/distributionorder/erpCommon/utility/DistributioOrderUtils.java
---
(0138525)
hgbot   
2022-06-17 14:48   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api [^]
Changeset: d73d165e099a54a33781dcfc03f62e9f4536aa6a
Author: Víctor Martínez Romanos <victor.martinez@openbravo.com>
Date: 17-06-2022 14:48:41
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/commit/d73d165e099a54a33781dcfc03f62e9f4536aa6a [^]

Related to ISSUE-49426: OBDOAPI_UpdateDOQuantities event points to DO entity

Previously it was pointing to Goods Movement entity, which was wrong definition

---
M src-db/database/sourcedata/CNC_PUBLIC_EVENTS.xml
---
(0138535)
hgbot   
2022-06-18 11:32   
Merge Request created: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/20 [^]
(0138933)
hgbot   
2022-07-01 14:32   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api [^]
Changeset: 912ed19d41a47898009651483a343477100a5419
Author: Prakash M <prakash@qualiantech.com>
Date: 01-07-2022 12:32:56
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/commit/912ed19d41a47898009651483a343477100a5419 [^]

Related to ISSUE-49426: Allow to update Distribution Orders
* Distribution order is auto confirmed while importing to minimize the complexity of update process
* Update can be done only in ScheduledDeliveryDate, issueQty, receivedQty
* Updating issueQty, receivedQty will update its related order
* Added validations for issueQty, receivedQty
* Added postman example
* Auto update Issued/Received statuses at DO header

---
M examples/Distribution Order API.postman_collection.json
M src/org/openbravo/distributionorder/api/hook/distributionorder/ImportDOBaseOBObjectFetcher.java
M src/org/openbravo/distributionorder/api/hook/distributionorder/ImportDOUtils.java
M src/org/openbravo/distributionorder/api/hook/distributionorder/ImportedDOBaseOBObjectAfterFlushHook.java
M src/org/openbravo/distributionorder/api/hook/distributionorderline/ImportDOLineBaseOBObjectFetcher.java
M src/org/openbravo/distributionorder/api/hook/distributionorderline/ImportDOLineOBObjectInitializer.java
M src/org/openbravo/distributionorder/api/mappings/distributionorder/ImportDOJavaPropertyMappingHandler.java
M src/org/openbravo/distributionorder/api/mappings/distributionorderline/ImportDOLineJavaPropertyMappingHandler.java
---
(0138934)
hgbot   
2022-07-01 14:32   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.distributionorder.api/-/merge_requests/3 [^]
(0138935)
hgbot   
2022-07-01 14:33   
Merge request merged: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/20 [^]
(0138936)
hgbot   
2022-07-01 14:33   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: 416e6601f566221f26e16b25cc574eb3b9b3c10f
Author: Prakash M <prakash@qualiantech.com>
Date: 01-07-2022 12:33:23
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/416e6601f566221f26e16b25cc574eb3b9b3c10f [^]

Related to ISSUE-49426: Added and Modified Distribution Order API Test to verify updation

---
A src-test/data/importer/DistributionOrderIssue.json
A src-test/data/importer/DistributionOrderIssueCreate.json
A src-test/data/importer/DistributionOrderIssueCreate2.json
A src-test/data/importer/DistributionOrderIssueUpdate.json
A src-test/data/importer/DistributionOrderReceipt.json
A src-test/data/importer/DistributionOrderReceiptCreate.json
A src-test/data/importer/DistributionOrderReceiptCreate2.json
A src-test/data/importer/DistributionOrderReceiptUpdate.json
M src-test/data/importer/DistributionOrderIssueClose.json
M src-test/data/importer/DistributionOrderReceiptClose.json
M src-test/org/openbravo/api/tests/importer/ImportDistributionOrder.java
---
(0138937)
hgbot   
2022-07-01 14:34   
Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/11 [^]
(0138938)
hgbot   
2022-07-01 14:34   
Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder [^]
Changeset: 3f23560c868a6a5b0e79263f960777eb5577ff18
Author: Prakash M <prakash@qualiantech.com>
Date: 18-06-2022 15:06:41
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/commit/3f23560c868a6a5b0e79263f960777eb5577ff18 [^]

Related to ISSUE-49426: Included ReceivedQty and IssuedQty while creating mirror document

---
M src/org/openbravo/distributionorder/erpCommon/utility/ProcessDistributionOrderUtil.java
---