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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031626
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2015-12-01 11:442015-12-07 13:10
ReporteramayavicenteView Statuspublic 
Assigned Tomario_castello 
PriorityhighResolutionfixedFixed in VersionRR16Q1
StatusclosedFix in branchFixed in SCM revisiond14cce94d562
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toguilleaer
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031626: [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."
TagsSER-QA
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0031328 closedranjith_qualiantech_com [SERQA 343] It is possible to do a return using a cash payment method without having any cash 
has duplicate defect 0031612 closedmario_castello [SERQA 350] Void layaway allow to make payments 

-  Notes
(0082499)
mario_castello (developer)
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 (developer)
2015-12-01 19:41

 This error is in live but the check constraint "fin_trans_amounts_chk" is correct.
(0082572)
hgbot (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2015-12-01 11:44 amayavicente New Issue
2015-12-01 11:44 amayavicente Assigned To => Retail
2015-12-01 11:44 amayavicente Resolution time => 1450134000
2015-12-01 11:44 amayavicente Triggers an Emergency Pack => No
2015-12-01 11:45 amayavicente Tag Attached: SER-QA
2015-12-01 13:03 agete Summary [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:40 Orekaria Relationship added related to 0031612
2015-12-01 14:04 Orekaria Status new => acknowledged
2015-12-01 15:23 mario_castello Assigned To Retail => mario_castello
2015-12-01 15:23 mario_castello Status acknowledged => scheduled
2015-12-01 19:34 mario_castello Note Added: 0082499
2015-12-01 19:41 mario_castello Note Added: 0082500
2015-12-01 19:42 mario_castello Status scheduled => feedback
2015-12-02 16:27 Orekaria Status feedback => scheduled
2015-12-02 16:32 Orekaria Relationship added related to 0031328
2015-12-04 14:37 hgbot Checkin
2015-12-04 14:37 hgbot Note Added: 0082572
2015-12-04 14:37 hgbot Status scheduled => resolved
2015-12-04 14:37 hgbot Resolution open => fixed
2015-12-04 14:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d14cce94d562569c9a1183a0b267fb4a9e78e5b4 [^]
2015-12-05 22:52 hgbot Checkin
2015-12-05 22:52 hgbot Note Added: 0082581
2015-12-07 10:30 Orekaria Review Assigned To => guilleaer
2015-12-07 13:10 guilleaer Status resolved => closed
2015-12-07 13:10 guilleaer Fixed in Version => RR16Q1
2015-12-09 13:19 Orekaria Relationship replaced has duplicate 0031612

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker