Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048685Retail ModulesRetail APIpublic2022-02-28 15:322022-03-14 14:45
Reporterprakashmurugesan88 
Assigned Toprakashmurugesan88 
PrioritynormalSeveritymajorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR22Q2 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0048685: Retail API Extension for Orders and Cashup
Description1. Extend Retail API to allow exporting Orders:

There are several APIs that are already making references to order-related information.
For example, existing Discounts engine webservice receives a simplified order as input.
External Order Loader does the same, although in this case it requires a significantly greater amount of properties.

Define a Retail API mapping for orders, to be used later for general export of transactions out of Openbravo.
At the same time, we also want to homogeneize all references to orders in our APIs.
Currently we have some inconsistencies in some properties, and this makes using different APIs confusing for users.

If we need to adjust some properties, we will do so without breaking compatibility with older versions of our APIs, to ensure current users can still operate them without issues.

https://docs.google.com/document/d/1f5XqBcKKY7XNe-J_rXc6E_xBiwm64uTb/edit [^]

2. Retail API extension: Cashup information

Extend Retail API to allow exporting the Cashup Information
This entity will essentially include all the information currently stored in the “Cashup History” tab of the Channel Touchpoint entity in the backoffice.

https://docs.google.com/document/d/1PAg4ChwPLxNI1Nvi32k84jc-Hm3iA50L/edit# [^]
Steps To ReproduceNA
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-02-28 15:32prakashmurugesan88New Issue
2022-02-28 15:32prakashmurugesan88Assigned To => prakashmurugesan88
2022-02-28 15:32prakashmurugesan88Triggers an Emergency Pack => No
2022-02-28 15:33prakashmurugesan88Statusnew => scheduled
2022-03-03 14:28hgbotNote Added: 0135430
2022-03-07 14:22ivancaceresIssue Monitored: ivancaceres
2022-03-09 08:49prakashmurugesan88Note Added: 0135569
2022-03-09 12:00hgbotResolutionopen => fixed
2022-03-09 12:00hgbotStatusscheduled => closed
2022-03-09 12:00hgbotFixed in Version => RR22Q2
2022-03-09 12:00hgbotNote Added: 0135579
2022-03-09 12:10hgbotNote Added: 0135580
2022-03-09 12:15hgbotNote Added: 0135581
2022-03-09 12:19hgbotNote Added: 0135582
2022-03-09 12:19hgbotNote Added: 0135583
2022-03-09 12:19hgbotNote Added: 0135584
2022-03-09 12:22hgbotNote Added: 0135585
2022-03-10 11:10hgbotNote Added: 0135616
2022-03-10 16:16hgbotNote Added: 0135626
2022-03-14 13:41hgbotNote Added: 0135689
2022-03-14 13:43hgbotNote Added: 0135690
2022-03-14 14:45hgbotNote Added: 0135693

Notes
(0135430)
hgbot   
2022-03-03 14:28   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/35 [^]
(0135569)
prakashmurugesan88   
2022-03-09 08:49   
Created following Merge Request,
      https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/merge_requests/21 [^]
      https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/740 [^]
      https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/4 [^]
      https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/35 [^]
      https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/merge_requests/2 [^]
(0135579)
hgbot   
2022-03-09 12:00   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 3244742a8491e1b0488c19117c467f1385b868be
Author: Prakash M <prakash@qualiantech.com>
Date: 09-03-2022 16:23:19
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/3244742a8491e1b0488c19117c467f1385b868be [^]

Fixed ISSUE-48685: Included following cashup related tables in sample data
* OBPOS_Paymentmethodcashup
* OBPOS_Paymentcashup_Events
* OBPOS_Taxcashup
* OBPOS_Cashup_Approval

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0135580)
hgbot   
2022-03-09 12:10   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 9e1318d2903237bf1502b2177e849614f99364b3
Author: Prakash M <prakash@qualiantech.com>
Date: 09-03-2022 16:39:35
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/9e1318d2903237bf1502b2177e849614f99364b3 [^]

Fixed ISSUE-48685: Included CashUp Sample Data

---
A referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml
A referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTCASHUP_EVENTS.xml
A referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml
A referencedata/sampledata/The_White_Valley_Group/OBPOS_TAXCASHUP.xml
M referencedata/sampledata/The_White_Valley_Group/AD_SEQUENCE.xml
M referencedata/sampledata/The_White_Valley_Group/C_INVOICE.xml
M referencedata/sampledata/The_White_Valley_Group/C_INVOICELINE.xml
M referencedata/sampledata/The_White_Valley_Group/C_INVOICELINETAX.xml
M referencedata/sampledata/The_White_Valley_Group/C_INVOICETAX.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINETAX.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERTAX.xml
M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINACC_TRANSACTION.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_FINANCIAL_ACCOUNT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_DETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULEDETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_RECONCILIATION.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUT.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml
M referencedata/sampledata/The_White_Valley_Group/M_INVENTORY.xml
M referencedata/sampledata/The_White_Valley_Group/M_STOCK_PROPOSED.xml
M referencedata/sampledata/The_White_Valley_Group/M_STORAGE_DETAIL.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION.xml
M referencedata/sampledata/The_White_Valley_Group/M_TRANSACTION_COST.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APPLICATIONS.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_CASHUP.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_APP_PAYMENT_TYPE.xml
---
(0135581)
hgbot   
2022-03-09 12:15   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: 52422273303e7757d9fba7b9a1a63b67a37c7e95
Author: Prakash M <prakash@qualiantech.com>
Date: 09-03-2022 16:42:42
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/52422273303e7757d9fba7b9a1a63b67a37c7e95 [^]

Fixed ISSUE-48685: Added Retail API Mapping for Order Export

---
---
(0135582)
hgbot   
2022-03-09 12:19   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api [^]
Changeset: 929685ed998028f40aafc29529cadc21cf699666
Author: Prakash M <prakash@qualiantech.com>
Date: 04-03-2022 08:28:50
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/commit/929685ed998028f40aafc29529cadc21cf699666 [^]

Related to FR-48685: Added examples to the Postman file for Order and Cashup APIs

---
M examples/Retail API.postman_collection.json
---
(0135583)
hgbot   
2022-03-09 12:19   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api [^]
Changeset: a8a9c85b32cc34b26162b426276e688f58874539
Author: Prakash M <prakash@qualiantech.com>
Date: 09-03-2022 16:48:03
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/commit/a8a9c85b32cc34b26162b426276e688f58874539 [^]

Fixed ISSUE-48685: Added Retail API Mapping for CashUp Export

---
M examples/Retail 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
---
(0135584)
hgbot   
2022-03-09 12:19   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.api/-/merge_requests/35 [^]
(0135585)
hgbot   
2022-03-09 12:22   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests [^]
Changeset: 652c688c1978000cf1d38a8f3a7b49b2b1aa3211
Author: Prakash M <prakash@qualiantech.com>
Date: 09-03-2022 16:51:23
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.api.tests/-/commit/652c688c1978000cf1d38a8f3a7b49b2b1aa3211 [^]

Fixed ISSUE-48685: Added Export Order and Export CashUp API tests

---
A src-test/data/export/filter/cashUp/CashUpById.json
A src-test/data/export/filter/cashUp/byCashUpOrg.json
A src-test/data/export/filter/cashUp/byCashUpTerminal.json
A src-test/data/export/filter/order/OrderByDocumentNo.json
A src-test/data/export/filter/order/OrderById.json
A src-test/data/export/filter/order/OrderByOrgOrderDate.json
A src-test/org/openbravo/api/tests/export/ApiExportCashUpFilters.java
A src-test/org/openbravo/api/tests/export/ApiExportOrderFilters.java
M src-test/data/export/filter/bpartner/BPartnerByBPartnerCategory.json
M src-test/data/export/filter/bpartner/BPartnerById.json
M src-test/data/export/filter/bpartner/BPartnerByName.json
M src-test/data/export/filter/bpartner/BPartnerByOrg.json
M src-test/data/export/filter/bpartner/BPartnerBySearchKey.json
M src-test/data/export/filter/bpartner/BPartnerByStoreId.json
M src-test/data/export/filter/bpartner/BPartnerByStoreName.json
M src-test/data/export/filter/bpartner/BPartnerByStoreSearchKey.json
M src-test/data/export/filter/product/ProductById.json
M src-test/data/importer/Product.json
M src-test/org/openbravo/api/tests/StandaloneTestSuite.java
M src-test/org/openbravo/api/tests/util/ApiTestConstants.java
---
(0135616)
hgbot   
2022-03-10 11:10   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 9ed70dc07068936eeb1723a80e25ebf39e56e810
Author: Prakash M <prakash@qualiantech.com>
Date: 10-03-2022 15:40:25
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/9ed70dc07068936eeb1723a80e25ebf39e56e810 [^]

Related ISSUE-48685: Fixes SAMPLEDATA dbconsinstency

---
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml
---
(0135626)
hgbot   
2022-03-10 16:16   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: af7231d9671872ec5dae486d5869bd55e1f5dfef
Author: Prakash M <prakash@qualiantech.com>
Date: 10-03-2022 20:05:55
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/af7231d9671872ec5dae486d5869bd55e1f5dfef [^]

Revert "Related ISSUE-48685: Fixes SAMPLEDATA dbconsinstency"

This reverts commit 9ed70dc07068936eeb1723a80e25ebf39e56e810.

---
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml
---
(0135689)
hgbot   
2022-03-14 13:41   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing [^]
Changeset: 9e4a8ab2ee26c90e436a316dfeee8d49850a674f
Author: Prakash M <prakash@qualiantech.com>
Date: 14-03-2022 12:41:38
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing/-/commit/9e4a8ab2ee26c90e436a316dfeee8d49850a674f [^]

Related to ISSUE-48685: Fixes tests failing after adding new orders in sample data

Fixed by adding hardcoded order IDs to ensure new sampledata orders don't affect tests.

---
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRBlockchainTestBase.java
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRaTicketBlockchain.java
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRbTicketTaxBlockchain.java
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRcTicketReprintBlockchain.java
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRdTicketAggDayBlockchain.java
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFReTicketAggMonthBlockchain.java
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRfTicketAggYearBlockchain.java
M src-test/org/openbravo/certification/france/testing/blockchain/test/OBCFRgTerminalMonitorBlockchain.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRaIssueTicket.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRbIssueTicketTax.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRcIssueTicketReprint.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRdIssueTerminalMonitor.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFReIssueTicketAggDay.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRfIssueTicketAggMonth.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRgIssueTicketAggYear.java
M src-test/org/openbravo/certification/france/testing/issue/test/OBCFRhIssueArchivingLog.java
M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRTicketTestBase.java
M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRTicketTestSuite.java
M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRaTicketCreateData.java
M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRbTicketInitializationBackground.java
M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRfTicketRemoveData.java
M src-test/org/openbravo/certification/france/testing/utils/OBCFRTicketUtils.java
---
(0135690)
hgbot   
2022-03-14 13:43   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata [^]
Changeset: 9c7ea70bfc1bc0839018098886abd7316ed33ead
Author: Prakash M <prakash@qualiantech.com>
Date: 11-03-2022 13:36:27
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.test.mobile.sampledata/-/commit/9c7ea70bfc1bc0839018098886abd7316ed33ead [^]

Revert "Revert "Related ISSUE-48685: Fixes SAMPLEDATA dbconsinstency""

This reverts commit af7231d9671872ec5dae486d5869bd55e1f5dfef.

---
M referencedata/sampledata/The_White_Valley_Group/C_ORDER.xml
M referencedata/sampledata/The_White_Valley_Group/C_ORDERLINE.xml
M referencedata/sampledata/The_White_Valley_Group/FACT_ACCT.xml
M referencedata/sampledata/The_White_Valley_Group/FIN_PAYMENT_SCHEDULE.xml
M referencedata/sampledata/The_White_Valley_Group/M_INOUTLINE.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_CASHUP_APPROVAL.xml
M referencedata/sampledata/The_White_Valley_Group/OBPOS_PAYMENTMETHODCASHUP.xml
---
(0135693)
hgbot   
2022-03-14 14:45   
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing [^]
Changeset: 1c7cb91d7033bffc2c8f290efe89b84835dda616
Author: Álvaro Ferraz <alvaro.ferraz@openbravo.com>
Date: 14-03-2022 14:44:21
URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.testing/-/commit/1c7cb91d7033bffc2c8f290efe89b84835dda616 [^]

Related to ISSUE-48685: Avoid ORA-01873 error in Oracle

---
M src-test/org/openbravo/certification/france/testing/ticket/test/OBCFRTicketTestBase.java
---