Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019831Openbravo ERP09. Financial managementpublic2012-02-22 03:472012-04-02 06:11
Reportergregor1com 
Assigned Toeduardo_Argal 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP10 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesOpenbravo 3.0
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0019831: Fiscal Close should reverse 'temporary' but not 'permanent' account balances
DescriptionWhen you run the fiscal close procedure, inappropriate accounting is taking place. This is due to incorrect design.

In the USA, Canada, and most other countries, a distinction is made between temporary and permanent accounts; this distinction corresponds to "profit and loss" versus "balance sheet". The balance sheet accounts, which are permanent, are not closed at the end of the year. Only temporary accounts are closed through reversal. This means that there should be no closing entries that affect b/s sheet accounts for almost every country. However, this is the only behavior that is supported. the effect is accounting entries that are not understood.
Steps To Reproducego to the fiscal calendar and choose the button to close the fiscal year. When the process completes, look at the generated accounting transactions by selecting include closing entries in the general journal, and no other. This will show you that permanent accounts are closed, which is incorrect.
Proposed SolutionThis needs to be changed through some additional parameter or choice which allows you to include or not include permanent accounts during close.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-02-22 03:47gregor1comNew Issue
2012-02-22 03:47gregor1comAssigned To => vmromanos
2012-02-22 03:47gregor1comModules => Openbravo 3.0
2012-02-28 18:52dalsasuaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=3215#r3215
2012-02-29 13:54eduardo_ArgalStatusnew => scheduled
2012-02-29 13:54eduardo_ArgalAssigned Tovmromanos => eduardo_Argal
2012-02-29 13:54eduardo_Argalfix_in_branch => pi
2012-03-21 17:58hgbotCheckin
2012-03-21 17:58hgbotNote Added: 0046613
2012-03-21 17:58hgbotStatusscheduled => resolved
2012-03-21 17:58hgbotResolutionopen => fixed
2012-03-21 17:58hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a4e4ae163ec3f4b3feeb35cbd0859b0b8c62f5c3 [^]
2012-03-26 16:11eduardo_ArgalNote Added: 0046734
2012-03-28 16:31vmromanosNote Added: 0046839
2012-03-28 16:31vmromanosStatusresolved => closed
2012-03-28 16:31vmromanosFixed in Version => 3.0MP9
2012-03-30 08:28miruritaStatusclosed => new
2012-03-30 08:28miruritaResolutionfixed => open
2012-03-30 08:28miruritaFixed in Version3.0MP9 =>
2012-03-30 08:28miruritaStatusnew => scheduled
2012-03-30 08:28miruritaStatusscheduled => resolved
2012-03-30 08:28miruritaFixed in Version => 3.0MP10
2012-03-30 08:28miruritaResolutionopen => fixed
2012-03-30 08:28miruritaStatusresolved => closed
2012-04-02 06:11hudsonbotCheckin
2012-04-02 06:11hudsonbotNote Added: 0047188

Notes
(0046613)
hgbot   
2012-03-21 17:58   
Repository: erp/devel/pi
Changeset: a4e4ae163ec3f4b3feeb35cbd0859b0b8c62f5c3
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Mar 20 13:31:11 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a4e4ae163ec3f4b3feeb35cbd0859b0b8c62f5c3 [^]

Fixes issue 19831, fixes issue 19829

---
M src-db/database/model/tables/C_ACCTSCHEMA_GL.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct_data.xsql
---
(0046734)
eduardo_Argal   
2012-03-26 16:11   
TESTING PLAN:

1)CREATE CLOSING FOR ORGANIZATION F&B US, Inc. FOR YEAR 2010
2) REVIEW ENTRIES GENERATED IN GENERAL LEDGER JOURNAL
3) MODIFY SETUP FOR ACCOUNTING SCHEMA SO THAT NO ACCOUNTING FOR PERMANENT ENTRIES ARE CREATED (GL TAB IN ACCOUNTING SCHEMA UN-FLAG CHECK BOX)
4) RUN STEPS 1 AND 2 AGAIN FOR REVIEW
(0046839)
vmromanos   
2012-03-28 16:31   
code review + testing OK: closing entries are not generated if Reverse Permanent Account balances flag is not checked in the Accounting Schema configuration.
In case of a multi accounting schema environment, it works also fine.
(0047188)
hudsonbot   
2012-04-02 06:11   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7814864461ac [^]

Maturity status: Test