Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031626Retail ModulesWeb POSpublic2015-12-01 11:442015-12-07 13:10
Reporteramayavicente 
Assigned Tomario_castello 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR16Q1 
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
Summary0031626: [SERQA 350] Error entering a payment in cash while voiding a layaway
DescriptionError entering a payment in cash while voiding a layaway
Steps To Reproduce1. Create a layaway without payments.
2. Search the layaway crated previously in 'Layaways'.
3. In the menu, click 'Void this layaway' and before confirm, enter a payment of 1000 in CASH.
4. Confirm the void.
5. Log into the backend and search the voided layaway
ERROR: The status of the layaway is still 'Booked'. In the window 'Data Import Entry' there is an error "org.codehaus.jettison.json.JSONException: JSONObject["id"] not found."
Proposed Solution
Additional Information
TagsSER-QA
Relationships
related to defect 0031328 closed ranjith_qualiantech_com [SERQA 343] It is possible to do a return using a cash payment method without having any cash 
has duplicate defect 0031612 closed mario_castello [SERQA 350] Void layaway allow to make payments 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-12-01 11:44amayavicenteNew Issue
2015-12-01 11:44amayavicenteAssigned To => Retail
2015-12-01 11:44amayavicenteResolution time => 1450134000
2015-12-01 11:44amayavicenteTriggers an Emergency Pack => No
2015-12-01 11:45amayavicenteTag Attached: SER-QA
2015-12-01 13:03ageteSummary[SERQA 350]Error entering a payment in cash while voiding a layaway => [SERQA 350] Error entering a payment in cash while voiding a layaway
2015-12-01 13:40OrekariaRelationship addedrelated to 0031612
2015-12-01 14:04OrekariaStatusnew => acknowledged
2015-12-01 15:23mario_castelloAssigned ToRetail => mario_castello
2015-12-01 15:23mario_castelloStatusacknowledged => scheduled
2015-12-01 19:34mario_castelloNote Added: 0082499
2015-12-01 19:41mario_castelloNote Added: 0082500
2015-12-01 19:42mario_castelloStatusscheduled => feedback
2015-12-02 16:27OrekariaStatusfeedback => scheduled
2015-12-02 16:32OrekariaRelationship addedrelated to 0031328
2015-12-04 14:37hgbotCheckin
2015-12-04 14:37hgbotNote Added: 0082572
2015-12-04 14:37hgbotStatusscheduled => resolved
2015-12-04 14:37hgbotResolutionopen => fixed
2015-12-04 14:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d14cce94d562569c9a1183a0b267fb4a9e78e5b4 [^]
2015-12-05 22:52hgbotCheckin
2015-12-05 22:52hgbotNote Added: 0082581
2015-12-07 10:30OrekariaReview Assigned To => guilleaer
2015-12-07 13:10guilleaerStatusresolved => closed
2015-12-07 13:10guilleaerFixed in Version => RR16Q1
2015-12-09 13:19OrekariaRelationship replacedhas duplicate 0031612

Notes
(0082499)
mario_castello   
2015-12-01 19:34   
2015-12-01 18:15:44,652 [Import Entry - 4] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into FIN_Finacc_Transaction (AD_Client_ID, AD_Org_ID, Created, Createdby, Updated, Updatedby, Isactive, C_Currency_ID, Fin_Financial_Account_ID, Line, Fin_Payment_ID, DateAcct, Status, Paymentamt, Depositamt, Processed, Processing, Posted, Trxtype, Statementdate, Description, CreatedByAlgorithm, C_Bpartner_ID, EM_APRM_Modify, EM_Aprm_Processed, Fin_Finacc_Transaction_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', '2015-12-01 18:15:44.630000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2015-12-01 18:15:44.630000 +01:00:00', '3073EDF96A3C42CC86C7069E379522D2', 'Y', '102', 'F37A1534BB6C4BB9AC8564B7850792D4', 400, '8689DD135951400A9C174E880ED22BAA', '2015-12-01 00:00:00.000000 +01:00:00', 'RDNC', '0.00', '0', 'Y', 'N', 'N', 'BPW', '2015-12-01 00:00:00.000000 +01:00:00', 'Order No.: VBS1/0000111
', 'N', 'ABD91C9D3BC94175B876FBBE9CACA008', 'N', 'P', 'FE3A192FEB8C49879A3165168A2EDF82') was aborted. Call getNextException to see the cause.
2015-12-01 18:15:44,660 [Import Entry - 4] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: new row for relation "fin_finacc_transaction" violates check constraint "fin_trans_amounts_chk"
2015-12-01 18:15:44,662 [Import Entry - 4] ERROR org.openbravo.base.exception.OBException - There was an error voiding the orde Layaway:
org.postgresql.util.PSQLException: ERROR: new row for relation "fin_finacc_transaction" violates check constraint "fin_trans_amounts_chk"
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
    at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
    at org.openbravo.dal.service.OBDal.flush(OBDal.java:205)
    at org.openbravo.dal.service.OBDal.getConnection(OBDal.java:146)
    at org.openbravo.retail.posterminal.ProcessVoidLayaway.saveRecord(ProcessVoidLayaway.java:192)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:206)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:163)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:95)
    at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:41)
    at org.openbravo.retail.posterminal.importprocess.VoidLayawayEntryProcessor$VoidLayawayRunnable.processEntry(VoidLayawayEntryProcessor.java:71)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:364)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:289)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
2015-12-01 18:15:44,674 [Import Entry - 4] ERROR org.openbravo.retail.posterminal.importprocess.VoidLayawayEntryProcessor$VoidLayawayRunnable - JSONObject["id"] not found.
org.codehaus.jettison.json.JSONException: JSONObject["id"] not found.
    at org.codehaus.jettison.json.JSONObject.get(JSONObject.java:360)
    at org.codehaus.jettison.json.JSONObject.getString(JSONObject.java:487)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:238)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:163)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:95)
    at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:41)
    at org.openbravo.retail.posterminal.importprocess.VoidLayawayEntryProcessor$VoidLayawayRunnable.processEntry(VoidLayawayEntryProcessor.java:71)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:364)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:289)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
(0082500)
mario_castello   
2015-12-01 19:41   
This error is in live but the check constraint "fin_trans_amounts_chk" is correct.
(0082572)
hgbot   
2015-12-04 14:37   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d14cce94d562569c9a1183a0b267fb4a9e78e5b4
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Fri Dec 04 07:36:18 2015 -0600
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d14cce94d562569c9a1183a0b267fb4a9e78e5b4 [^]

Fixed issue 31626: Validate payment for voided layaway

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M web/org.openbravo.retail.posterminal/js/model/order.js
---
(0082581)
hgbot   
2015-12-05 22:52   
Repository: tools/automation/pi-mobile
Changeset: 88c275fd3a4028f868b266aac6a5e536c12ac9a5
Author: Mario Castello <mario.castello <at> peoplewalking.com>
Date: Sat Dec 05 15:51:47 2015 -0600
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/88c275fd3a4028f868b266aac6a5e536c12ac9a5 [^]

Related to issue 31626: Added automated test

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/layaway/I31626_VoidLayawayAddPayment.java
---