0026150: reset accounting process does not work with "date from" and "date to"

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0026150

Openbravo ERP

09. Financial management

public

2014-04-02 16:12

2015-02-25 18:17

Reporter

malsasua

Assigned To

dmiguelez

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

unable to reproduce

Platform

OS Version

Community Appliance

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Google Chrome

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0026150: reset accounting process does not work with "date from" and "date to"

Description

Reset accounting process does not work when it is executed with "date from" and "date to" are dates of distinct months

Steps To Reproduce

in F&B
. run reset accounting process
  . table c_invoice
  . date from: 01/02/2014
  . date to: 31/03/2014

0 records are deleted

Proposed Solution

the error is in the file ResetAccounting.java
in the process getOpenPeriods:
the query created in this function is wrong because it is searching periods with
starting date <= dateFrom
and
ending date >= dateTo
and it occurs only when dateFrom and dateTo belong to the same month, there are not periods that dateFrom and dateTo belong to distinct months

Additional Information