Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006913Openbravo ERP09. Financial managementpublic2009-01-15 14:142009-04-21 11:05
Reporternetworkb 
Assigned Toeduardo_Argal 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS Version
Product Version2.35MP9 
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
Summary0006913: Error in the initial acctouting entry process (in period window)
DescriptionWhen creating the closing and opening entry in the general ledger using the process button in the calendar-year windows, the process doesn´t create the entry correctly, because there are some entries of the fact_acct table that are not taken into account due to an error in the sql query that selects the entries. (see CreateRegFactAcct_data.xsql file).
This error cause a very important error in p&l and balance of the customer, because results are not correct.

What we expect about the resolution of this issue is:
1. fix the bug
2. why it has occurred, because we could have many customers with the same problem
3. how to regularize the accounting situation in customers with
3.1 two different accounting plans 2007, 2008 with opening, closing and regularization made, and also with all the accounting information delivered to the government
3.2 fiscal implications of these error: how a customer should register these differences in the accounting. Imagine the case that the customer has not presented the real losses or benefits during the fiscal year due to this error. How can we explain them what has happened, and to solve ....

So, in the end, we expect not only the fix for the bug.

Regards
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006922 closed eduardo_Argal Error in the initial acctouting entry process (in period window) 
depends on backport 0006923 closed eduardo_Argal Error in the initial acctouting entry process (in period window) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-15 14:14networkbNew Issue
2009-01-15 14:14networkbAssigned To => rafaroda
2009-01-15 14:14networkbsf_bug_id0 => 2509868
2009-01-15 14:14networkbRegression testing => No
2009-01-15 14:18jpcalventeIssue Monitored: jpcalvente
2009-01-15 16:35rafarodaAssigned Torafaroda => eduardo_Argal
2009-01-15 16:35rafarodaversion => 2.35MP9
2009-01-15 16:35rafarodaDescription Updated
2009-01-15 16:36rafarodaStatusnew => scheduled
2009-01-15 16:36rafarodafix_in_branch => trunk
2009-01-16 12:11svnbotCheckin
2009-01-16 12:11svnbotNote Added: 0012247
2009-01-16 12:11svnbotStatusscheduled => resolved
2009-01-16 12:11svnbotResolutionopen => fixed
2009-01-16 12:11svnbotsvn_revision => 11964
2009-01-23 13:42psarobeNote Added: 0012571
2009-04-21 11:05psarobeStatusresolved => closed

Notes
(0012247)
svnbot   
2009-01-16 12:11   
Repository: openbravo
Revision: 11964
Author: eduardoargal
Date: 2009-01-16 12:11:27 +0100 (Fri, 16 Jan 2009)

Fixes bug 0006913: Error in the initial accouting entry process (in period window)

---
U trunk/src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=11964&sc=1 [^]
(0012571)
psarobe   
2009-01-23 13:42   
Steps to reproduce:

1. Create an invoice of customer A, for example
2. Modify customer A accounts combination. (Create a new value combination [1] using a strange account so will be easy to track it)
3. Post the invoice
4. Go to the customer and remove the associated valid combination [1] assigning another one
5. Go to valid combination window and remove it
6. Go to Calendar/year and execute closing process
7. Verify the account[1] is not included in the closing entry in the general ledger journal (31/12/...). There will be two journal entries one for profits and revenues and another one