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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013899
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminoralways2010-07-06 11:032010-07-24 00:00
ReporternetworkbView Statuspublic 
Assigned Toeduardo_Argal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision8a5a8720b4a3
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP19SCM 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

0013899: Error inserting a new record in Financial Account

DescriptionAn error occurs when a new record is inserted in Financial Account:

ERROR: el valor null para la columna «fin_bankrevaluationgain_acct» viola la restricción not null

This is due to the fact that the trigger fin_financial_account_trg is trying insert in fin_bankrevaluationgain_acct the value B_SettlementGain_Acct, what is null and is not active.
Steps To Reproduce1. Openbravo version 2.50mp19
2. Advanced Payables & Receivables version 1.0.2
3. Professional Spanish Localization Pack
4. Create a new Client with accounting and chart of accounts.
5. Create a new Organization LWA.
6. Go to Financial Management || Receivables & Payables || Transactions || Financial Account || Account
7. Create a new record and save.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0029086)
hgbot (developer)
2010-07-06 11:16

 Repository: erp/devel/pi
Changeset: 8a5a8720b4a331a4c87d12445f60656b4099b3cc
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Jul 06 11:16:18 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8a5a8720b4a331a4c87d12445f60656b4099b3cc [^]

Fixes bug 0013899: Error inserting a new record in Financial Account

---
M src-db/database/model/triggers/FIN_FINANCIAL_ACCOUNT_TRG.xml
---
(0029116)
hudsonbot (viewer)
2010-07-07 12:38

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/8a5a8720b4a3 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/d555a35070ee [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17817.obx [^]
(0029275)
sureshbabu (viewer)
2010-07-13 22:13

 @Edu, please let me know your findings..still i am finding the same issue appears in the context even the COA file do have the in_bankrevaluationgain_acct value
(0029519)
sureshbabu (viewer)
2010-07-23 11:35
edited on: 2010-07-23 11:36

 verified now i can able to create a new record in Financial account

- Issue History
Date Modified Username Field Change
2010-07-06 11:03 networkb New Issue
2010-07-06 11:03 networkb Assigned To => eduardo_Argal
2010-07-06 11:03 networkb OBNetwork customer => No
2010-07-06 11:14 eduardo_Argal Status new => scheduled
2010-07-06 11:14 eduardo_Argal fix_in_branch => pi
2010-07-06 11:16 hgbot Checkin
2010-07-06 11:16 hgbot Note Added: 0029086
2010-07-06 11:16 hgbot Status scheduled => resolved
2010-07-06 11:16 hgbot Resolution open => fixed
2010-07-06 11:16 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8a5a8720b4a331a4c87d12445f60656b4099b3cc [^]
2010-07-07 12:38 hudsonbot Checkin
2010-07-07 12:38 hudsonbot Note Added: 0029116
2010-07-13 22:13 sureshbabu Note Added: 0029275
2010-07-23 11:35 sureshbabu Note Added: 0029519
2010-07-23 11:35 sureshbabu Status resolved => closed
2010-07-23 11:36 sureshbabu Note Edited: 0029519 View Revisions
2010-07-24 00:00 anonymous sf_bug_id 0 => 3033810

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker