0006923: Error in the initial acctouting entry process (in period window)

Description

When 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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0006913

closed

eduardo_Argal

Error in the initial acctouting entry process (in period window)

Notes
(0012266) svnbot (reporter) 2009-01-16 18:11	Repository: openbravo Revision: 11978 Author: eduardoargal Date: 2009-01-16 18:11:32 +0100 (Fri, 16 Jan 2009) Fixes bug 0006923: Error in the initial acctouting entry process (in period window) --- U branches/r2.3x/src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct_data.xsql --- https://dev.openbravo.com/websvn/openbravo/?rev=11978&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2009-01-15 16:36	rafaroda	Type	defect => backport
2009-01-15 16:36	rafaroda	fix_in_branch	=> 2.3x
2009-01-16 18:11	svnbot	Checkin
2009-01-16 18:11	svnbot	Note Added: 0012266
2009-01-16 18:11	svnbot	Status	scheduled => resolved
2009-01-16 18:11	svnbot	Resolution	open => fixed
2009-01-16 18:11	svnbot	svn_revision	=> 11978
2009-01-27 13:04	psarobe	Status	resolved => closed