Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009069Openbravo ERP09. Financial managementpublic2009-05-18 12:222009-07-16 17:55
pmagnin 
dalsasua 
urgentminorhave not tried
closedfixed 
5
 
 
Core
No
0009069: Include Provisional Opening Balance
When you generate the balance sheet report for the current year when the previous year is still open, each account balance is calculated considering only the accounting entries for the current year and assuming an opening balance of zero.

Openbravo gives you to combine the period close with the automatic generation of the closing and opening entries by running the corresponding process.
The purpose of the closing and opening entry is to transfer the balance of an account at the end of a period to be beginning of the next period.

This behavior does not meet the operational needs of generating a provisional balance sheet to manage the company at the beginning of a year while the previous year is still being adjusted.


-------------------------------------------------------------------------------
The objective of the presente FR is to change the Balance Sheet report so that:

1 - If the previous year is not closed, instead of assuming zero beginning balances for the accounts, a provisional opening entry is calculated to ensure that the amounts are always correct.

2- In that case, the report output should be considered provisional (because the beginning balance could change as the result of a change in the previous year) and the label "Provisional" will be included in the report output.

3 - To avoid impact to existing customers who are used to the current behavior of the report, the calculation of provisional entries will be controlled by a report option "Include Provisional Opening Balance".
ReleaseCandidate
depends on backport 0009374 closed pjuvara Include Provisional Opening Balance 
Issue History
2009-05-18 12:22pmagninNew Issue
2009-05-18 12:22pmagninAssigned To => rafaroda
2009-05-18 12:22pmagninRegression testing => No
2009-05-19 16:43pjuvaraTag Attached: ReleaseCandidate
2009-05-19 16:43pjuvaraStatusnew => acknowledged
2009-05-19 17:02pjuvaraPriorityimmediate => urgent
2009-05-22 16:11rafarodaAssigned Torafaroda => pjuvara
2009-06-08 12:54dalsasuaStatusacknowledged => scheduled
2009-06-08 12:54dalsasuaAssigned Topjuvara => dalsasua
2009-06-08 12:54dalsasuafix_in_branch => pi
2009-06-09 19:30hgbotCheckin
2009-06-09 19:30hgbotNote Added: 0017151
2009-06-09 19:30hgbotStatusscheduled => resolved
2009-06-09 19:30hgbotResolutionopen => fixed
2009-06-09 19:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3470ed6f5af6c40765359f7621de38c233bf4b24 [^]
2009-06-15 12:30hgbotCheckin
2009-06-15 12:30hgbotNote Added: 0017296
2009-06-15 12:30hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/3470ed6f5af6c40765359f7621de38c233bf4b24 [^] => http://code.openbravo.com/erp/devel/pi/rev/1cdcca71214d8f544cb844fd7ed1253849f6be2b [^]
2009-06-15 13:27hgbotCheckin
2009-06-15 13:27hgbotNote Added: 0017302
2009-06-15 13:27hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/1cdcca71214d8f544cb844fd7ed1253849f6be2b [^] => http://code.openbravo.com/erp/devel/pi/rev/29070df661c26fdc0802bfeb14fe23f0358c29a3 [^]
2009-07-11 08:18pjuvaraStatusresolved => closed
2009-07-16 17:55anonymoussf_bug_id0 => 2822547

Notes
(0017151)
hgbot   
2009-06-09 19:30   
Repository: erp/devel/pi
Changeset: 3470ed6f5af6c40765359f7621de38c233bf4b24
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Jun 09 19:29:58 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3470ed6f5af6c40765359f7621de38c233bf4b24 [^]

Fixes Issue 9069: Include Provisional Opening Balance

---
M referencedata/sampledata/Accounting_Test.xml
M src-db/database/model/tables/C_ACCT_RPT.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-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.html
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.xml
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
M src/org/openbravo/erpCommon/businessUtility/AccountTree_data.xsql
---
(0017296)
hgbot   
2009-06-15 12:30   
Repository: erp/devel/pi
Changeset: 1cdcca71214d8f544cb844fd7ed1253849f6be2b
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Mon Jun 15 12:30:21 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1cdcca71214d8f544cb844fd7ed1253849f6be2b [^]

Fixes issue 9069: Include Provisional Opening Balance. Fixes Issue 9467: api check: build 46 failed

---
M src-db/database/model/tables/C_ACCT_RPT.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.html
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.java
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports.xml
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
---
(0017302)
hgbot   
2009-06-15 13:27   
Repository: erp/devel/pi
Changeset: 29070df661c26fdc0802bfeb14fe23f0358c29a3
Author: Stefan Huehner <stefan.huehner <at> openbravo.com>
Date: Mon Jun 15 13:27:19 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/29070df661c26fdc0802bfeb14fe23f0358c29a3 [^]

Issue 9069. Issue 9467. Fix build error on pgsql introduced in 1cdcca71214d

---
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReports_data.xsql
---