Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0040175Openbravo ERP09. Financial managementpublic2019-02-11 12:202023-11-03 04:48
ReporterSandrahuguet 
Assigned Tomarkmm82 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusscheduledResolutionopen 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0040175: Trial balance report should not take into account the closed years
DescriptionTrial balance report should not take into account the closed years.

In selectLines query all lines of the FACT_ACCT are checked before the indicated date. This query should be modified to check FACT_ACCT before the indicated date and in a open year.

If the report is launched by a closed year, the dateacct should be 1-jan of that year.
Steps To ReproduceLaunch report Trial Balance of 2018
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to design defect 0031740 new dmiguelez Report trial balance report is slow with high number of transactions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-02-11 12:20SandrahuguetNew Issue
2019-02-11 12:20SandrahuguetAssigned To => markmm82
2019-02-11 12:20SandrahuguetModules => Core
2019-02-11 12:20SandrahuguetTriggers an Emergency Pack => No
2019-02-11 12:22SandrahuguetDescription Updatedbug_revision_view_page.php?rev_id=18299#r18299
2019-02-11 12:22SandrahuguetTag Attached: Performance
2019-02-11 12:22SandrahuguetRelationship addedrelated to 0031740
2019-02-11 14:38markmm82Statusnew => scheduled
2019-02-11 16:05SandrahuguetDescription Updatedbug_revision_view_page.php?rev_id=18304#r18304
2019-02-13 23:49markmm82Note Added: 0109814
2019-08-22 11:51ngarciaIssue Monitored: ngarcia
2023-11-03 04:48budgetcookieNote Added: 0156654
2023-11-06 10:49shuehnerNote Deleted: 0156654

Notes
(0109814)
markmm82   
2019-02-13 23:49   
Test Plan:
As F&B Group Admin:
  Go to End Year Close.
    Be sure you have closed the following years: 2011, 2012, 2013, 2014 and 2015.
    Be sure you have opened the following years: 2016, 2017, 2018, 2019 and 2020.

Test case A: Filtering dates that belongs to a closed year.
  Go to Trial Balance Report and select dates in a closed year, for example in 2014:
    From: 05/03/2014
    To: 05/11/2014
  Execute the report.
  If you debug the launched query is now filtering all FACT_ACCT starting from 01-01-2014.

Test case B: Filtering dates that belongs to a closed and an open year.
  Go to Trial Balance Report and select the FROM date in a closed year and a TO date in an open year, for example:
    From: 05/03/2013
    To: 05/11/2015
  Execute the report.
  If you debug the launched query is now filtering all FACT_ACCT starting from 01-01-2013.

Test case C1: Filtering dates that belongs to an open year.
  Go to Trial Balance Report and select dates in an open year, for example in 2017:
    From: 05/03/2017
    To: 05/11/2019
  Execute the report.
  If you debug the launched query is now filtering all FACT_ACCT starting from 01-01-2016. In fact it is the first open year after 2015 that is the last closed year. Previous closed years than 2016 are not taken into account.

Test case C2: Filtering dates that belongs to an open year.
  Go to End year and close 2016, 2017 and 2018 years.
  Go to Trial Balance Report and select dates in an open year, for example in 2019:
    From: 05/03/2019
    To: 05/11/2019
  Execute the report.
  If you debug the launched query is now filtering all FACT_ACCT starting from 01-01-2019. In fact it is the first open year after 2018 that is the last closed year. Previous closed years than 2019 are not taken into account.