Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026150Openbravo ERP09. Financial managementpublic2014-04-02 16:122015-02-25 18:17
Reportermalsasua 
Assigned Todmiguelez 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026150: reset accounting process does not work with "date from" and "date to"
DescriptionReset accounting process does not work when it is executed with "date from" and "date to" are dates of distinct months
Steps To Reproducein F&B
. run reset accounting process
  . table c_invoice
  . date from: 01/02/2014
  . date to: 31/03/2014

0 records are deleted
Proposed Solutionthe 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
TagsNo tags attached.
Relationships
related to defect 00261303.0PR14Q3 closed pramakrishnan Reset Accounting is not working fine filling the Starting Date and Ending Date 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-04-02 16:12malsasuaNew Issue
2014-04-02 16:12malsasuaAssigned To => dmiguelez
2014-04-02 16:12malsasuaWeb browser => Google Chrome
2014-04-02 16:12malsasuaModules => Core
2014-04-02 16:12malsasuaOBNetwork customer => No
2014-04-02 16:12malsasuaTriggers an Emergency Pack => No
2014-05-09 11:30ngarciaRelationship addedrelated to 0026130
2015-02-25 18:17eduardo_ArgalStatusnew => closed
2015-02-25 18:17eduardo_ArgalResolutionopen => unable to reproduce

There are no notes attached to this issue.