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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018606
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] Z. Othersmajoralways2011-08-23 11:372011-10-06 19:01
ReportermiruritaView Statuspublic 
Assigned Tomirurita 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision59de9c3ad920
ProjectionnoneETAnoneTarget Version2.50MP35
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018606: Bank Statement document gets locked when trying to post

DescriptiongetDocumentConfirmation 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 Reproduce1) 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00183393.0MP4 closedmirurita Bank Statement document gets locked when trying to post 

-  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 (viewer)
2011-10-06 19:01

 verified

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker