0017535: Fiscal Year closing process do not take into account all the accounting dimensions

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0017535

Openbravo ERP

09. Financial management

public

2011-06-07 11:46

2011-07-14 13:56

Reporter

dalsasua

Assigned To

dalsasua

Priority

high

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 10.10

Product Version

Target Version

Fixed in Version

2.50MP32

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0017535: Fiscal Year closing process do not take into account all the accounting dimensions

Description

When 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