Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006712Openbravo ERP09. Financial managementpublic2008-12-22 13:022009-04-21 11:04
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006712: Project is not included in fact_acct when a bank statement is posted
DescriptionFirstly, a manual settlement is created. In "Create payment" tab a project is selected. The manual settlement is processed and posted.

After that, a bank statement is created using the previous manual settlement. It is processed and posted.

If you have a look to FACT_ACCT table, no c_project_id is inserted in both cases.
Steps To Reproduce1. create a manual settlement
2. create the payment
4. choose a project and fill the amount field
5. create de balance payment selecting a g/l item and fill the amount field
6. process the settlement
7. make a bank statement selecting the previous settlement, process and post it.
8. at last, make sure the cancel settelment is also posted.
9. In fact_acct table, the c_project_id field is empty.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006748 closed eduardo_Argal Project is not included in fact_acct when a bank statement is posted 
depends on defect 0006755 closed vmromanos Unable to post a manual settlement 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-22 13:02networkbNew Issue
2008-12-22 13:02networkbAssigned To => rafaroda
2008-12-22 13:02networkbsf_bug_id0 => 2458383
2008-12-22 13:02networkbRegression testing => No
2008-12-28 18:28rafarodaStatusnew => scheduled
2008-12-28 18:28rafarodaAssigned Torafaroda => dalsasua
2008-12-28 18:28rafarodafix_in_branch => trunk
2008-12-29 21:25vmromanosAssigned Todalsasua => vmromanos
2008-12-29 22:06vmromanosRelationship addeddepends on 0006755
2008-12-30 11:28vmromanosNote Added: 0011756
2008-12-30 11:30svnbotCheckin
2008-12-30 11:30svnbotNote Added: 0011757
2008-12-30 11:30svnbotStatusscheduled => resolved
2008-12-30 11:30svnbotResolutionopen => fixed
2008-12-30 11:30svnbotsvn_revision => 11607
2009-01-29 12:10eduardo_ArgalStatusresolved => new
2009-01-29 12:10eduardo_ArgalResolutionfixed => open
2009-01-29 12:10eduardo_ArgalStatusnew => scheduled
2009-01-29 12:10eduardo_ArgalAssigned Tovmromanos => eduardo_Argal
2009-01-29 12:50svnbotCheckin
2009-01-29 12:50svnbotNote Added: 0012808
2009-01-29 12:50svnbotStatusscheduled => resolved
2009-01-29 12:50svnbotResolutionopen => fixed
2009-01-29 12:50svnbotsvn_revision11607 => 12465
2009-04-21 11:04psarobeStatusresolved => closed

Notes
(0011756)
vmromanos   
2008-12-30 11:28   
The bug 0006755 blocks this bug, so in order to test the fix I have commented from line 531 to line 534 of the AcctServer.java file:

/*for (int i = 0; i < m_fact.length; i++)
            if (m_fact[i] != null
                    && (m_fact[i].getLines() == null || m_fact[i].getLines().length == 0))
                return false;*/


This workaround has allowed me to test the fix for this immediate bug.
(0011757)
svnbot   
2008-12-30 11:30   
Repository: openbravo
Revision: 11607
Author: vmromanos
Date: 2008-12-30 11:30:03 +0100 (Tue, 30 Dec 2008)

Fixed bug 6712: Project is not included in fact_acct when a bank statement is posted

---
U trunk/src/org/openbravo/erpCommon/ad_forms/DocBank.java
U trunk/src/org/openbravo/erpCommon/ad_forms/DocLineBank_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11607&sc=1 [^]
(0012808)
svnbot   
2009-01-29 12:50   
Repository: openbravo
Revision: 12465
Author: eduardoargal
Date: 2009-01-29 12:50:56 +0100 (Thu, 29 Jan 2009)

Fixes bug 0006712: Project is not included in fact_acct when a bank statement is posted

---
U trunk/src/org/openbravo/erpCommon/ad_forms/DocBank.java
U trunk/src/org/openbravo/erpCommon/ad_forms/DocLinePayment_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=12465&sc=1 [^]