Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040337Retail ModulesCash uppublic2019-03-07 13:412019-03-28 18:01
Reportermalsasua 
Assigned Torqueralta 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR19Q2 
Merge Request Status
Review Assigned Toguilleaer
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040337: Cashup with corrupted data is synced after to update to 18Q3
DescriptionWhen cashup has not been completed in one terminal, and system is updated to 18Q3, the payment method cashup info is corrupted in local database. This info is updated to current balance of financial account of payments.
Steps To ReproduceBO:
. Cash financial account - current balance 0

POS:
. login
. complete cashup -> total to keep for cash payment method: 0
. complete a new sales order SO1 -> amount 10
(Cash financial account - current balance 10)

UPDATE TO 18Q3
POS:
. login
. complete cashup -> starting cash is displaying amount 10 and it should be 0
Proposed SolutionVerify into OB.UTIL.initcashup function if any tables related with the cash up process was rebuilded. If it was done, is necessary eliminate the others related tables, at the beginning of the process. By doing this, we recover all the backend data.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0040484RR19Q1.1 closed rqueralta Cashup with corrupted data is synced after to update to 18Q3 
depends on backport 0040485RR18Q4.3 closed rqueralta Cashup with corrupted data is synced after to update to 18Q3 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-03-07 13:41malsasuaNew Issue
2019-03-07 13:41malsasuaAssigned To => Retail
2019-03-07 13:41malsasuaResolution time => 1552258800
2019-03-07 13:41malsasuaRegression level => Production - Confirmed Stable
2019-03-07 13:41malsasuaTriggers an Emergency Pack => No
2019-03-09 04:51rqueraltaAssigned ToRetail => rqueralta
2019-03-09 04:51rqueraltaStatusnew => scheduled
2019-03-12 10:00ngarciaIssue Monitored: ngarcia
2019-03-14 13:30hgbotCheckin
2019-03-14 13:30hgbotNote Added: 0110438
2019-03-14 13:30hgbotStatusscheduled => resolved
2019-03-14 13:30hgbotResolutionopen => fixed
2019-03-14 13:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c9244988dd029f49c0cf47841c4179b18561d79b [^]
2019-03-14 13:31hgbotCheckin
2019-03-14 13:31hgbotNote Added: 0110439
2019-03-14 13:31hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c9244988dd029f49c0cf47841c4179b18561d79b [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/6fe93e22a3c77d7e9d1fc9f35805b6fdb843ac15 [^]
2019-03-25 12:59guilleaerNote Added: 0110623
2019-03-25 12:59guilleaerStatusresolved => new
2019-03-25 12:59guilleaerResolutionfixed => open
2019-03-25 12:59guilleaerRegression levelProduction - Confirmed Stable =>
2019-03-25 13:02guilleaerNote Edited: 0110623bug_revision_view_page.php?bugnote_id=0110623#r18526
2019-03-25 20:21rqueraltaProposed Solution updated
2019-03-26 11:42egoitzRegression level => Production - Confirmed Stable
2019-03-26 12:11hgbotCheckin
2019-03-26 12:11hgbotNote Added: 0110650
2019-03-26 12:11hgbotStatusnew => resolved
2019-03-26 12:11hgbotResolutionopen => fixed
2019-03-26 12:11hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/6fe93e22a3c77d7e9d1fc9f35805b6fdb843ac15 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d3d5b55bacf27fb7ae575f88aac921986f335df4 [^]
2019-03-26 12:12hgbotCheckin
2019-03-26 12:12hgbotNote Added: 0110651
2019-03-26 12:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d3d5b55bacf27fb7ae575f88aac921986f335df4 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c74d6f059b735e2b45163a54886035c9829cbc49 [^]
2019-03-28 13:30guilleaerReview Assigned To => guilleaer
2019-03-28 13:30guilleaerStatusresolved => closed
2019-03-28 13:30guilleaerFixed in Version => RR19Q2
2019-03-28 15:13guilleaerRegression levelProduction - Confirmed Stable =>
2019-03-28 15:14guilleaerNote Added: 0110901
2019-03-28 17:59guilleaerStatusclosed => new
2019-03-28 17:59guilleaerResolutionfixed => open
2019-03-28 17:59guilleaerFixed in VersionRR19Q2 =>
2019-03-28 18:00guilleaerStatusnew => scheduled
2019-03-28 18:00guilleaerStatusscheduled => resolved
2019-03-28 18:01guilleaerFixed in Version => RR19Q2
2019-03-28 18:01guilleaerResolutionopen => fixed
2019-03-28 18:01guilleaerStatusresolved => closed

Notes
(0110438)
hgbot   
2019-03-14 13:30   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: c9244988dd029f49c0cf47841c4179b18561d79b
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Wed Mar 13 19:45:12 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c9244988dd029f49c0cf47841c4179b18561d79b [^]

Fixed issue 40337: Cashup with corrupted data is synced after to update to 18Q3

- Before add a new record into paymentmethodcashup table is necessary check if
the model was rebuilded to set the startingCash to 0.

---
M web/org.openbravo.retail.posterminal/js/utils/cashUpReportUtils.js
---
(0110439)
hgbot   
2019-03-14 13:31   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 6fe93e22a3c77d7e9d1fc9f35805b6fdb843ac15
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Wed Mar 13 19:45:00 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/6fe93e22a3c77d7e9d1fc9f35805b6fdb843ac15 [^]

Fixed issue 40337: Cashup with corrupted data is synced after to update to 18Q3

- Before add a new record into paymentmethodcashup table is necessary check if
the model was rebuilded to set the startingCash to 0.

---
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
(0110623)
guilleaer   
2019-03-25 12:59   
(edited on: 2019-03-25 13:02)
This fix is not correct (posterminal part)

If payment method cashup information is rebuilded then we need to intialize cashup information from backend. It includes cashup model.

- Remove cashup information and retrieve cashup and payment method cashup information from backend
(0110650)
hgbot   
2019-03-26 12:11   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d3d5b55bacf27fb7ae575f88aac921986f335df4
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Mon Mar 25 22:59:56 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d3d5b55bacf27fb7ae575f88aac921986f335df4 [^]

Fixed issue 40337: Cashup with corrupted data is synced after to update to 18Q3

- Removed this change because it not necessary

---
M web/org.openbravo.retail.posterminal/js/utils/cashUpReportUtils.js
---
(0110651)
hgbot   
2019-03-26 12:12   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: c74d6f059b735e2b45163a54886035c9829cbc49
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Mon Mar 25 23:09:04 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/c74d6f059b735e2b45163a54886035c9829cbc49 [^]

Fixed issue 40337: Cashup with corrupted data is synced after to update to 18Q3

- If one table related to Cash Up process is rebuilded, is necessary rebuild all
the related tables. "relatedTablesToRebuild" function was added to do it. In this
way we reload all Cash Up data from the backend.

---
M web/org.openbravo.mobile.core/source/model/ob-terminal-model.js
---
(0110901)
guilleaer   
2019-03-28 15:14   
Although customer can perceive this problem as a regression it is not a regression in the code. We were not taking into account this situation before.