Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0036272Openbravo ERP09. Financial managementpublic2017-06-19 11:132017-09-21 16:49
maite 
markmm82 
highminoralways
closedfixed 
5
 
3.0PR17Q4 
aferraz
Core
No
0036272: "End year close" process is grouping by record_id2 so accounting information is difficult to understand
"Closing entry" information is grouped by accounting dimension information (which is right) but it is also grouped by record_id2 information (which is wrong). This is not causing error in calculating the final balance for an account but it difficult to understand numbers shown in general ledger report
1. Register Sales Invoice for "Alimentos y Supermercados". Process and Post it
2. Run "Add payment" process from sales invoice and process payment.
3. Access related Financial Account and post transaction (so invoice is not an open balance)
4. Register Sales Invoice for "Alimentos y Supermercados". Process and Post it (do not register payment so invoice is an open balance)
5. Access "End year close" window and close year
6. Run "General Ledger Report" and realize that 2 lines with description "Closing entry" has been created because process is grouping by record_id2 value
No tags attached.
Issue History
2017-06-19 11:13maiteNew Issue
2017-06-19 11:13maiteAssigned To => Triage Finance
2017-06-19 11:13maiteModules => Core
2017-06-19 11:13maiteTriggers an Emergency Pack => No
2017-06-19 11:14maiteIssue Monitored: networkb
2017-06-22 10:42maiteResolution time => 1499896800
2017-06-23 20:33markmm82Assigned ToTriage Finance => markmm82
2017-06-23 20:33markmm82Statusnew => scheduled
2017-06-26 22:06markmm82Note Added: 0097685
2017-07-03 18:52aferrazNote Edited: 0097685bug_revision_view_page.php?bugnote_id=0097685#r15450
2017-07-03 19:39hgbotCheckin
2017-07-03 19:39hgbotNote Added: 0097809
2017-07-03 19:39hgbotStatusscheduled => resolved
2017-07-03 19:39hgbotResolutionopen => fixed
2017-07-03 19:39hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2db97bde87bf2e562666d5c6b9b2ad11421e248b [^]
2017-07-03 19:40aferrazReview Assigned To => aferraz
2017-07-03 19:40aferrazNote Added: 0097810
2017-07-03 19:40aferrazStatusresolved => closed
2017-07-03 19:40aferrazFixed in Version => 3.0PR17Q4
2017-09-21 16:49hudsonbotCheckin
2017-09-21 16:49hudsonbotNote Added: 0099228

Notes
(0097685)
markmm82   
2017-06-26 22:06   
(edited on: 2017-07-03 18:52)
Test Plan 1:
1. Register Sales Invoice for "Alimentos y Supermercados". Process and Post it
2. Run "Add payment" process from sales invoice and process payment.
3. Access related Financial Account and post transaction (so invoice is not an open balance)
4. Register Sales Invoice for "Alimentos y Supermercados". Process and Post it (do not register payment so invoice is an open balance)
5. Access "End year close" window and close year
6. Run "General Ledger Report" and realize that only 1 line with description "Closing entry" has been created.

(0097809)
hgbot   
2017-07-03 19:39   
Repository: erp/devel/pi
Changeset: 2db97bde87bf2e562666d5c6b9b2ad11421e248b
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Jun 26 15:07:39 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/2db97bde87bf2e562666d5c6b9b2ad11421e248b [^]

Fixes issue 36272: "End year close" process is grouping by record_id2

The "End year close" process was grouping by record_id2 so it was making more
difficult to understand numbers shown in general ledger report.

To fix it, all references to RECORD_ID2 were removed from EndYearCloseUtility_data.xsql.

---
M src/org/openbravo/erpCommon/businessUtility/EndYearCloseUtility.java
M src/org/openbravo/erpCommon/businessUtility/EndYearCloseUtility_data.xsql
---
(0097810)
aferraz   
2017-07-03 19:40   
Code review + Testing OK
(0099228)
hudsonbot   
2017-09-21 16:49   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9750b78d3e5c [^]
Maturity status: Test