Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0018606 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] Z. Others | major | always | 2011-08-23 11:37 | 2011-10-06 19:01 | |||
| Reporter | mirurita | View Status | public | |||||
| Assigned To | mirurita | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | 2.50 | Fixed in SCM revision | 59de9c3ad920 | |||
| Projection | none | ETA | none | Target Version | 2.50MP35 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0018606: Bank Statement document gets locked when trying to post | |||||||
| Description | getDocumentConfirmation of DocFINBankStatement returns false if the bank statement posting is not enable in Financial Account || Accounting Configuration. line 629 AcctServer.java getDocumentConfirmation(conn, Record_ID) then when trying to save the record restoring the processing = 'N' the update statement fails because Status is empty ("") line 635 AcctServer.java save(conn, vars.getUser()) Status is "" (empty) AcctServerData.updateSave(conn, tableName, Status, strUser, Record_ID) 3675287 [DefaultQuartzScheduler_Worker-4] ERROR org.openbravo.erpCommon.ad_forms.AcctServerData - SQL error in query: UPDATE FIN_BankStatement SET Posted= ? ,Processing='N', updated=now(), updatedby=? WHERE FIN_BankStatement_ID = ?Exception:org.postgresql.util.PSQLException: ERROR: null value in column "posted" violates not-null constraint 3675288 [DefaultQuartzScheduler_Worker-4] WARN org.openbravo.erpCommon.ad_forms.AcctServer - javax.servlet.ServletException: @CODE=0@ERROR: null value in column "posted" violates not-null constraint javax.servlet.ServletException: @CODE=0@ERROR: null value in column "posted" violates not-null constraint | |||||||
| Steps To Reproduce | 1) Create a manual bank statement 1.1) Create one line of Amount In: 10 2) Do NOT process 3) Don't enable the Bank Statement Posting (Financial Account || Accounting Configuration) 4) Run the acct server background process | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0041527) hgbot (developer) 2011-10-06 12:12 |
Repository: erp/stable/2.50 Changeset: 59de9c3ad920b4b2f535df45b2f12b70aa2af872 Author: Mikel Irurita <mikel.irurita <at> openbravo.com> Date: Fri Sep 23 14:38:48 2011 +0200 URL: http://code.openbravo.com/erp/stable/2.50/rev/59de9c3ad920b4b2f535df45b2f12b70aa2af872 [^] Fixes issue 18606: Bank Statement document gets locked when trying to post --- M src/org/openbravo/erpCommon/ad_forms/DocFINBankStatement.java --- |
|
(0041537) maite (developer) 2011-10-06 19:01 |
verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-09-23 14:37 | mirurita | Type | defect => backport |
| 2011-09-23 14:37 | mirurita | fix_in_branch | => 2.50 |
| 2011-09-27 11:57 | mirurita | Target Version | 3.0MP4 => 2.50MP35 |
| 2011-10-06 12:12 | hgbot | Checkin | |
| 2011-10-06 12:12 | hgbot | Note Added: 0041527 | |
| 2011-10-06 12:12 | hgbot | Status | scheduled => resolved |
| 2011-10-06 12:12 | hgbot | Resolution | open => fixed |
| 2011-10-06 12:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.50/rev/59de9c3ad920b4b2f535df45b2f12b70aa2af872 [^] |
| 2011-10-06 19:01 | maite | Note Added: 0041537 | |
| 2011-10-06 19:01 | maite | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |