Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0051983
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2023-03-27 13:412023-04-21 07:59
ReporterngarciaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityurgentResolutionfixedFixed in VersionRR23Q3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket61256
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0051983: Cash Up is processed but not updated in Errors While Importing POS Data if a previous cash up is in Error

DescriptionCash Up is processed but not updated in Errors While Importing POS Data if a previous cash up is in Error
Steps To ReproduceIn https://livebuilds.openbravo.com/retail_pi_pgsql/web/org.openbravo.retail.posterminal/?terminal=VBS-1 [^]

1) Create an order, add a product, add disc_fixed_5_perc discount, do not complete the order

2) Remove the discount in the Discounts and Promotions window

3) Complete the order in the POS
4) Check it is stuck in Errors While Importing POS Data with the following error:

insert or update on table "c_orderline_offer" violates foreign key constraint "c_orderline_offer_m_offer"
  Detail: Key (m_offer_id)=(...) is not present in table "m_offer".

5) Do the cash up twice
6) Check they are stuck in EWIPD window with the following error:

org.openbravo.base.exception.OBException: There are errors related to non-created customers, orders, or cash management movements pending to be processed. Process them before processing the cash ups

7) Create the discount again in the Discounts and Promotions window

8) Edit the JSON of the order in the EWIPD window and replace the old m_offer_id with the new one. Save the record again and check it is imported

9) Remove the complete id property for the cashTaxInfo section. For instance
"id":"00AF20570D3F86866DEABCFFD9ADEBEC",

10) Confirm the records in the EWIPD are sorted by creation date

11) Select the two cash-ups and save them again

12) The first one will fail with:

org.codehaus.jettison.json.JSONException: JSONObject["id"] not found.

13) The other cashup will still have the previous error, but if you navigate to the Channel Touchpoint - Cash Up History window, you will see it was processed. The Cash Up Report button appears

14) Set the removed part to the first JSON and confirm it is imported correctly

15) Save the second cash up and check the error message changes to:

org.openbravo.base.exception.OBException: Cash up was already processed
    at org.openbravo.retail.posterminal.UpdateCashup.getAndUpdateCashUp(UpdateCashup.java:76)
    at org.openbravo.retail.posterminal.ProcessCashClose.saveRecord(ProcessCashClose.java:99)
Proposed SolutionIf a cash up fails, the rest of the cash ups shouldn't be processed
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0148613)
hgbot (developer)
2023-04-20 04:33

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1148 [^]
(0148674)
hgbot (developer)
2023-04-21 07:59

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: bf8b5c1ccfd89f1724dc5ad77ce43afc6d9cc0bd
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 21-04-2023 04:36:53
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/bf8b5c1ccfd89f1724dc5ad77ce43afc6d9cc0bd [^]

Fixed ISSUE-51983: Previous Cashup should be processed before current cashup

---
M src/org/openbravo/retail/posterminal/ProcessCashClose.java
---
(0148675)
hgbot (developer)
2023-04-21 07:59

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1148 [^]

- Issue History
Date Modified Username Field Change
2023-03-27 13:41 ngarcia New Issue
2023-03-27 13:41 ngarcia Assigned To => Retail
2023-03-27 13:41 ngarcia OBNetwork customer => Gold
2023-03-27 13:41 ngarcia Support ticket => 61256
2023-03-27 13:41 ngarcia Triggers an Emergency Pack => No
2023-03-27 13:41 ngarcia Issue Monitored: networkb
2023-03-27 15:02 maite Issue Monitored: maite
2023-03-29 09:45 guillermogil Assigned To Retail => alainperez
2023-04-05 14:57 alainperez Status new => scheduled
2023-04-17 07:18 marvintm Assigned To alainperez => ranjith_qualiantech_com
2023-04-20 04:33 hgbot Merge Request Status => open
2023-04-20 04:33 hgbot Note Added: 0148613
2023-04-21 07:59 hgbot Merge Request Status open => approved
2023-04-21 07:59 hgbot Resolution open => fixed
2023-04-21 07:59 hgbot Status scheduled => closed
2023-04-21 07:59 hgbot Fixed in Version => RR23Q3
2023-04-21 07:59 hgbot Note Added: 0148674
2023-04-21 07:59 hgbot Note Added: 0148675


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker