Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0040175Openbravo ERP09. Financial managementpublic2019-02-11 12:202019-02-13 23:49
Sandrahuguet 
markmm82 
normalmajorhave not tried
scheduledopen 
30Openbravo Appliance 14.04
 
 
Core
No
0040175: Trial balance report should not take into account the closed years
Trial 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.
Launch report Trial Balance of 2018
Performance
related to design defect 0031740 new dmiguelez Report trial balance report is slow with high number of transactions 
Issue History
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

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.