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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0026130

3.0PR14Q3

closed

pramakrishnan

Reset Accounting is not working fine filling the Starting Date and Ending Date

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2014-04-02 16:12	malsasua	New Issue
2014-04-02 16:12	malsasua	Assigned To	=> dmiguelez
2014-04-02 16:12	malsasua	Web browser	=> Google Chrome
2014-04-02 16:12	malsasua	Modules	=> Core
2014-04-02 16:12	malsasua	OBNetwork customer	=> No
2014-04-02 16:12	malsasua	Triggers an Emergency Pack	=> No
2014-05-09 11:30	ngarcia	Relationship added	related to 0026130
2015-02-25 18:17	eduardo_Argal	Status	new => closed
2015-02-25 18:17	eduardo_Argal	Resolution	open => unable to reproduce