Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0036272 | Openbravo ERP | 09. Financial management | public | 2017-06-19 11:13 | 2017-09-21 16:49 |
|
| Reporter | maite | |
| Assigned To | markmm82 | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q4 | |
| Merge Request Status | |
| Review Assigned To | aferraz |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 47135 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0036272: "End year close" process is grouping by record_id2 so accounting information is difficult to understand |
| Description | "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 |
| Steps To Reproduce | 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 |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-06-19 11:13 | maite | New Issue | |
| 2017-06-19 11:13 | maite | Assigned To | => Triage Finance |
| 2017-06-19 11:13 | maite | OBNetwork customer | => Yes |
| 2017-06-19 11:13 | maite | Modules | => Core |
| 2017-06-19 11:13 | maite | Support ticket | => 47135 |
| 2017-06-19 11:13 | maite | Triggers an Emergency Pack | => No |
| 2017-06-19 11:14 | maite | Issue Monitored: networkb | |
| 2017-06-22 10:42 | maite | Resolution time | => 1499896800 |
| 2017-06-23 20:33 | markmm82 | Assigned To | Triage Finance => markmm82 |
| 2017-06-23 20:33 | markmm82 | Status | new => scheduled |
| 2017-06-26 22:06 | markmm82 | Note Added: 0097685 | |
| 2017-07-03 18:52 | aferraz | Note Edited: 0097685 | bug_revision_view_page.php?bugnote_id=0097685#r15450 |
| 2017-07-03 19:39 | hgbot | Checkin | |
| 2017-07-03 19:39 | hgbot | Note Added: 0097809 | |
| 2017-07-03 19:39 | hgbot | Status | scheduled => resolved |
| 2017-07-03 19:39 | hgbot | Resolution | open => fixed |
| 2017-07-03 19:39 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/2db97bde87bf2e562666d5c6b9b2ad11421e248b [^] |
| 2017-07-03 19:40 | aferraz | Review Assigned To | => aferraz |
| 2017-07-03 19:40 | aferraz | Note Added: 0097810 | |
| 2017-07-03 19:40 | aferraz | Status | resolved => closed |
| 2017-07-03 19:40 | aferraz | Fixed in Version | => 3.0PR17Q4 |
| 2017-09-21 16:49 | hudsonbot | Checkin | |
| 2017-09-21 16:49 | hudsonbot | Note 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
---
|
|
|
|
|
|
|
|
|
|