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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006913
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalhave not tried2009-01-15 14:142009-04-21 11:05
ReporternetworkbView Statuspublic 
Assigned Toeduardo_Argal 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision11964
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.35MP9SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006913: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0006922 closededuardo_Argal Error in the initial acctouting entry process (in period window) 
depends on backport 0006923 closededuardo_Argal Error in the initial acctouting entry process (in period window) 

-  Notes
(0012247)
svnbot (reporter)
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 (manager)
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

- Issue History
Date Modified Username Field Change
2009-01-15 14:14 networkb New Issue
2009-01-15 14:14 networkb Assigned To => rafaroda
2009-01-15 14:14 networkb sf_bug_id 0 => 2509868
2009-01-15 14:14 networkb Regression testing => No
2009-01-15 14:18 jpcalvente Issue Monitored: jpcalvente
2009-01-15 16:35 rafaroda Assigned To rafaroda => eduardo_Argal
2009-01-15 16:35 rafaroda version => 2.35MP9
2009-01-15 16:35 rafaroda Description Updated
2009-01-15 16:36 rafaroda Status new => scheduled
2009-01-15 16:36 rafaroda fix_in_branch => trunk
2009-01-16 12:11 svnbot Checkin
2009-01-16 12:11 svnbot Note Added: 0012247
2009-01-16 12:11 svnbot Status scheduled => resolved
2009-01-16 12:11 svnbot Resolution open => fixed
2009-01-16 12:11 svnbot svn_revision => 11964
2009-01-23 13:42 psarobe Note Added: 0012571
2009-04-21 11:05 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker