Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017534Openbravo ERP09. Financial managementpublic2011-06-07 11:462011-07-14 14:07
Reporterdalsasua 
Assigned Todalsasua 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 10.10
Product Version 
Target VersionFixed in Version3.0MP1 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017534: Fiscal Year closing process do not take into account all the accounting dimensions
DescriptionWhen running "Create Regularization Facts Accounting" process, in the fiscal year window, it's not taking into account all the dimensions.
If a fiscal year is closed, the opening entry looses the trace of some dimensions.
Steps To Reproduce
- Post an invoice with project
- Realize that the entry do save this dimension in accounting (you can check at Accounting Transaction Details)
- Run create reg fact acct process for a given fiscal year
- Locate the opening entry row for the BP of invoice in step 1
- Realize that no information about the project dimension is saved


Proposed Solution
CreateRegFactAcct_data.xsql should change:
- In getAmountsClose SQL statement, the group by clause must also include tax, project, activity, user_1, user_2, campaign, sales region, etc.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0017535 closed dalsasua Fiscal Year closing process do not take into account all the accounting dimensions 
related to defect 00193943.0MP8 closed jecharri Fiscal Year regularization process do not take into account all the accounting dimensions 
related to backport 00193952.50MP39 closed jecharri Fiscal Year regularization process do not take into account all the accounting dimensions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-06-07 11:46dalsasuaNew Issue
2011-06-07 11:46dalsasuaAssigned To => dalsasua
2011-06-07 11:46dalsasuaModules => Core
2011-06-07 11:46dalsasuaOBNetwork customer => Yes
2011-06-07 11:46dalsasuaStatusnew => scheduled
2011-06-07 11:46dalsasuafix_in_branch => pi
2011-06-30 14:04hgbotCheckin
2011-06-30 14:04hgbotNote Added: 0038625
2011-06-30 14:04hgbotStatusscheduled => resolved
2011-06-30 14:04hgbotResolutionopen => fixed
2011-06-30 14:04hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/25364524eac29f06f486513d1edb9a2b877143a6 [^]
2011-07-06 02:42hudsonbotCheckin
2011-07-06 02:42hudsonbotNote Added: 0038834
2011-07-14 14:07dalsasuaStatusresolved => closed
2011-07-14 14:07dalsasuaFixed in Version => 3.0MP1
2011-12-30 11:02jecharriRelationship addedrelated to 0019394
2011-12-30 11:03jecharriRelationship addedrelated to 0019395

Notes
(0038625)
hgbot   
2011-06-30 14:04   
Repository: erp/devel/pi
Changeset: 25364524eac29f06f486513d1edb9a2b877143a6
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Jun 30 13:49:32 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/25364524eac29f06f486513d1edb9a2b877143a6 [^]

Fixes issue 17235. Fixes issue 17665. Fixes issue 17534. Fixes issue 17096. Fixes issue 17830.

---
M src-db/database/sourcedata/AD_MESSAGE.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct.html
M src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct.java
M src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct.xml
M src/org/openbravo/erpCommon/ad_actionButton/CreateRegFactAcct_data.xsql
M src/org/openbravo/erpCommon/ad_actionButton/DropRegFactAcct.html
M src/org/openbravo/erpCommon/ad_actionButton/DropRegFactAcct.java
M src/org/openbravo/erpCommon/ad_actionButton/DropRegFactAcct_data.xsql
A src-db/database/model/triggers/AD_ORG_ACCTSCHEMA_TRG3.xml
---
(0038834)
hudsonbot   
2011-07-06 02:42   
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/f1c481b1a146 [^]

Maturity status: Test