Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047064POS2POSpublic2021-06-11 11:222022-06-03 11:25
Reporterjmelin 
Assigned Toebecerra 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047064: JIRA 2079 - Safebox-Cashup/counting - split by coins/notes not available in BO
DescriptionWhen performing a counting on safebox (initial or closing), the information entered on POS are not available in BO

Steps To Reproduce1. Connect to POS
2. Select a safebox
3. Do initial count
4. Do an order
5. Execute cashup
6. Reconnect to POS
7. select the same safebox and perform closing count, for cash splits by coins and notes

=> safebox is counted in BO, but the data of splits are not available in BO
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0047023 closed AtulOpenbravo JIRA 1821 - Cashup. Allow to switch between split/merge coins and notes views while keeping the data 
related to feature request 0048337 closed Retail Send to BO the initial count for the cash payment methods not used in Safeboxes 
depends on defect 0048338 closed ebecerra When using the Counting Tool for splitted coins and notes only last used is stored 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-06-11 11:22jmelinNew Issue
2021-06-11 11:22jmelinAssigned To => Retail
2021-06-11 11:22jmelinTriggers an Emergency Pack => No
2021-06-23 15:12dmitry_mezentsevRelationship addedrelated to 0047023
2021-07-13 12:44guilleaerNote Added: 0130416
2021-09-20 10:41guilleaerNote Deleted: 0130416
2021-10-18 13:06guilleaerStatusnew => acknowledged
2021-10-25 13:02guilleaerNote Added: 0132604
2021-11-11 11:43ebecerraAssigned ToRetail => ebecerra
2021-11-11 11:43ebecerraStatusacknowledged => scheduled
2021-11-11 11:57guilleaerPriorityurgent => normal
2022-01-11 09:26guilleaerRelationship addedrelated to 0048337
2022-01-11 09:26guilleaerRelationship addeddepends on 0048338
2022-01-11 09:28guilleaerNote Added: 0134193
2022-03-28 13:44hgbotNote Added: 0136095
2022-05-06 09:26guilleaerNote Edited: 0136095bug_revision_view_page.php?bugnote_id=0136095#r24029
2022-05-06 09:26guilleaerNote Edited: 0136095bug_revision_view_page.php?bugnote_id=0136095#r24030
2022-05-06 09:26guilleaerNote Deleted: 0134193
2022-05-06 09:27guilleaerAssigned Toebecerra => AugustoMauch
2022-05-06 09:28guilleaerReview Assigned To => AugustoMauch
2022-05-06 09:28guilleaerAssigned ToAugustoMauch => ebecerra
2022-05-06 09:30hgbotNote Added: 0137008
2022-05-06 09:32guilleaerNote Edited: 0136095bug_revision_view_page.php?bugnote_id=0136095#r24031
2022-05-06 09:39hgbotNote Added: 0137009
2022-05-06 09:53hgbotNote Added: 0137011
2022-05-06 10:08hgbotNote Added: 0137013
2022-05-06 10:15guilleaerNote Deleted: 0137009
2022-05-27 10:32hgbotNote Added: 0137807
2022-06-02 12:05hgbotResolutionopen => fixed
2022-06-02 12:05hgbotStatusscheduled => closed
2022-06-02 12:05hgbotNote Added: 0137968
2022-06-02 12:05hgbotNote Added: 0137969
2022-06-02 12:05hgbotNote Added: 0137970
2022-06-02 12:05hgbotNote Added: 0137971
2022-06-02 12:05hgbotNote Added: 0137972
2022-06-02 12:05hgbotNote Added: 0137973
2022-06-02 12:51hgbotNote Added: 0137975
2022-06-02 13:25hgbotNote Added: 0137983
2022-06-02 13:40hgbotNote Added: 0137985
2022-06-03 10:39hgbotNote Added: 0138024
2022-06-03 11:25hgbotNote Added: 0138030

Notes
(0132604)
guilleaer   
2021-10-25 13:02   
https://docs.google.com/document/d/1aFUkqw_Pf8C_4T8cOuFMW6Op1N0BGxj6a_lD-YK3mw4/edit [^]
(0136095)
hgbot   
2022-03-28 13:44   
(edited on: 2022-05-06 09:32)
Merge Request created:

https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/889 [^]
(0137008)
hgbot   
2022-05-06 09:30   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/789 [^]
(0137011)
hgbot   
2022-05-06 09:53   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/789 [^]
(0137013)
hgbot   
2022-05-06 10:08   
Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/789 [^]
(0137807)
hgbot   
2022-05-27 10:32   
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/196 [^]
(0137968)
hgbot   
2022-06-02 12:05   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: cd4cd9a217b76216a10165dc76685b69fd9bb1a6
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 02-06-2022 12:04:54
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/cd4cd9a217b76216a10165dc76685b69fd9bb1a6 [^]

Fixes FR-47064: Safebox-Cashup/counting - split by coins/notes not available in BO

---
A src-db/database/model/modifiedTables/OBPOS_PAYMENTMETHODCASHUP.xml
A src-db/database/model/modifiedTables/OBPOS_SAFEBOX_COUNT_PM.xml
A src-db/database/model/tables/OBPOS2_PMCASHUP_COINSNOTES.xml
A src-db/database/model/tables/OBPOS2_SBCOUNTPM_COINSNOTES.xml
A src-db/database/model/tables/OBPOS2_SBTP_PM.xml
A src-db/database/model/tables/OBPOS2_SBTP_PM_COINSNOTES.xml
A src/org/openbravo/pos2/UpdateCashupCountCoinsAndNotesHook.java
A src/org/openbravo/pos2/UpdateInitSafeboxCountCoinsAndNotesHook.java
A src/org/openbravo/pos2/UpdateSafeboxCountCoinsAndNotesHook.java
A src/org/openbravo/pos2/hook/orderloader/InitialCountCashup.java
A web-jspack/org.openbravo.pos2/src/model/user-interface/actions/cashup/SetInitialCountCashup.js
A web-jspack/org.openbravo.pos2/src/model/user-interface/utils/preparePayloadCoinsAndNotes.js
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_TAB.xml
M src-db/database/sourcedata/AD_TABLE.xml
M web-jspack/org.openbravo.pos2/src/components/Cashup/utils/getCashupToSend.js
M web-jspack/org.openbravo.pos2/src/model/cashup/CashupExtension.js
M web-jspack/org.openbravo.pos2/src/model/user-interface/actions/cashup/PreparePayloadForFinishCountSafebox.js
M web-jspack/org.openbravo.pos2/src/model/user-interface/actions/cashup/PreparePayloadForFinishInitialCount.js
M web-jspack/org.openbravo.pos2/src/model/user-interface/user-actions/initialCount/SynchronizeStandardInitialCount.js
---
(0137969)
hgbot   
2022-06-02 12:05   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/889 [^]
(0137970)
hgbot   
2022-06-02 12:05   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 76e89c9c7b27108e757151b73a6b87fa1bdcd908
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 02-06-2022 12:04:25
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/76e89c9c7b27108e757151b73a6b87fa1bdcd908 [^]

Related to FR-47064: Safebox-Cashup/counting - split by coins/notes not available in BO

---
A referencedata/standard/Coins_and_notes_for_EUR.xml
A src/org/openbravo/retail/posterminal/InitialCountSafeBoxHook.java
M src-db/database/sourcedata/AD_DATASET.xml
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src/org/openbravo/retail/posterminal/ProcessCountSafeBox.java
---
(0137971)
hgbot   
2022-06-02 12:05   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/789 [^]
(0137972)
hgbot   
2022-06-02 12:05   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: d42559b925c7b70739cb3928540a4187f0f19a9f
Author: Eduardo Becerra (OB) <eduardo.becerra@openbravo.com>
Date: 02-06-2022 12:05:08
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/d42559b925c7b70739cb3928540a4187f0f19a9f [^]

Related FR-47064: Modify test ids

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I31677_VerifyPaymentMethodSelectionII.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I37776_VerifyCreditButton.java
---
(0137973)
hgbot   
2022-06-02 12:05   
Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/196 [^]
(0137975)
hgbot   
2022-06-02 12:51   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: ec0174473849bac05ead1305c4fd1a10184863f0
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 02-06-2022 12:50:45
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/ec0174473849bac05ead1305c4fd1a10184863f0 [^]

Related to FR-47064: Add missing indexes in coins and notes tables

---
M src-db/database/model/tables/OBPOS2_PMCASHUP_COINSNOTES.xml
M src-db/database/model/tables/OBPOS2_SBCOUNTPM_COINSNOTES.xml
M src-db/database/model/tables/OBPOS2_SBTP_PM.xml
M src-db/database/model/tables/OBPOS2_SBTP_PM_COINSNOTES.xml
---
(0137983)
hgbot   
2022-06-02 13:25   
Repository: https://gitlab.com/openbravo/ci/mobile-test [^]
Changeset: a7a4547e65490ac8702d80fe4edb4ce46a89ee59
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 02-06-2022 13:24:21
URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/a7a4547e65490ac8702d80fe4edb4ce46a89ee59 [^]

Revert "Related FR-47064: Modify test ids"

This reverts commit d42559b925c7b70739cb3928540a4187f0f19a9f.

This commit is not required anymore, as the dataset that included cash
payment currency has been reverted in posterminal module.

---
M src-test/org/openbravo/test/mobile/retail/pack/selenium/TestIdPack.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I31677_VerifyPaymentMethodSelectionII.java
M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I37776_VerifyCreditButton.java
---
(0137985)
hgbot   
2022-06-02 13:40   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: 1de452625d135f6de377c8cb17b406e5ada9ad85
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 02-06-2022 13:40:04
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/1de452625d135f6de377c8cb17b406e5ada9ad85 [^]

Related to FR-47064: Fix Index naming with wrong DB Prefix

---
M src-db/database/model/tables/OBPOS2_SBTP_PM.xml
---
(0138024)
hgbot   
2022-06-03 10:39   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: 0db65117f5938ca0e9cdbc3f8af4ef3e14e7884a
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 03-06-2022 10:39:10
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/0db65117f5938ca0e9cdbc3f8af4ef3e14e7884a [^]

Related to ISSUE-47064: Fix duplicate check name on CoinsNotes table

---
M src-db/database/model/tables/OBPOS2_SBCOUNTPM_COINSNOTES.xml
---
(0138030)
hgbot   
2022-06-03 11:25   
Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: 000e6d8ce6386c243627f65ce8ed640e6e0ab68f
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 03-06-2022 11:25:34
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/000e6d8ce6386c243627f65ce8ed640e6e0ab68f [^]

Related to ISSUE-47064: Fix more duplicate DB names on CoinsNotes table

---
M src-db/database/model/tables/OBPOS2_SBCOUNTPM_COINSNOTES.xml
M src-db/database/model/tables/OBPOS2_SBTP_PM.xml
---