Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013899Openbravo ERPZ. Otherspublic2010-07-06 11:032010-07-24 00:00
Reporternetworkb 
Assigned Toeduardo_Argal 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP19 
Target VersionFixed in Version 
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
Summary0013899: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-07-06 11:03networkbNew Issue
2010-07-06 11:03networkbAssigned To => eduardo_Argal
2010-07-06 11:03networkbOBNetwork customer => No
2010-07-06 11:14eduardo_ArgalStatusnew => scheduled
2010-07-06 11:14eduardo_Argalfix_in_branch => pi
2010-07-06 11:16hgbotCheckin
2010-07-06 11:16hgbotNote Added: 0029086
2010-07-06 11:16hgbotStatusscheduled => resolved
2010-07-06 11:16hgbotResolutionopen => fixed
2010-07-06 11:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8a5a8720b4a331a4c87d12445f60656b4099b3cc [^]
2010-07-07 12:38hudsonbotCheckin
2010-07-07 12:38hudsonbotNote Added: 0029116
2010-07-13 22:13sureshbabuNote Added: 0029275
2010-07-23 11:35sureshbabuNote Added: 0029519
2010-07-23 11:35sureshbabuStatusresolved => closed
2010-07-23 11:36sureshbabuNote Edited: 0029519bug_revision_view_page.php?bugnote_id=0029519#r612
2010-07-24 00:00anonymoussf_bug_id0 => 3033810

Notes
(0029086)
hgbot   
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   
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   
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   
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