Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0040178 | Openbravo ERP | A. Platform | public | 2019-02-11 13:17 | 2019-10-01 15:12 |
|
| Reporter | JONHM | |
| Assigned To | collazoandy4 | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | scheduled | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0040178: Audit fields of 'Open/Close period control' are not updated when Opening/Closing period |
| Description | When Opening/Closing a period via process in "Open/Close Period Control" Window, audit fields "Updated" and "Updated by" are not updated for C_Period and C_PeriodControl tables. |
| Steps To Reproduce | - As System Administrator, set C_Period and C_PeriodControl tables as 'Fully Audited'.
- As F&B role admin, open window 'Open/Close period control'
- In the grid view, show column "Updated" both in the main tab and in the Documents one.
- Select a period of the current year and close it using the "Close Period" button.
- Notice that the audit trail button in the toolbar is still not enabled and that the Updated column has not changed nor for the period nor all Documents entries. |
| Proposed Solution | Update C_Period_Process procedure (see attached file) to upgrade the updated/updatedby fields to each modified table during this process. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  40178.patch (4,905) 2019-03-04 13:18
https://issues.openbravo.com/file_download.php?file_id=12702&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2019-02-11 13:17 | JONHM | New Issue | |
| 2019-02-11 13:17 | JONHM | Assigned To | => platform |
| 2019-02-11 13:17 | JONHM | Modules | => Core |
| 2019-02-11 13:17 | JONHM | Triggers an Emergency Pack | => No |
| 2019-03-04 08:48 | jarmendariz | Assigned To | platform => jarmendariz |
| 2019-03-04 13:09 | jarmendariz | Note Added: 0110188 | |
| 2019-03-04 13:09 | jarmendariz | Assigned To | jarmendariz => Triage Finance |
| 2019-03-04 13:09 | jarmendariz | Summary | Some audit fields of 'Open/Close period control' window are not registered => Audit fields of 'Open/Close period control' are not updated when Opening/Closing period |
| 2019-03-04 13:09 | jarmendariz | Description Updated | bug_revision_view_page.php?rev_id=18379#r18379 |
| 2019-03-04 13:09 | jarmendariz | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=18381#r18381 |
| 2019-03-04 13:18 | jarmendariz | File Added: 40178.patch | |
| 2019-03-04 13:19 | jarmendariz | Proposed Solution updated | |
| 2019-10-01 06:09 | collazoandy4 | Assigned To | Triage Finance => collazoandy4 |
| 2019-10-01 06:10 | collazoandy4 | Status | new => scheduled |
| 2019-10-01 15:12 | collazoandy4 | Note Added: 0114877 | |
|
Notes |
|
|
|
|
Changed the title and description of this issue because it is not expected to register in the audit trail table the table's audit fields (created, createdby, updated, updatedby). However, those fields should be updated when closing the period |
|
|
|
(0114877)
|
|
collazoandy4
|
|
2019-10-01 15:12
|
|
Test Plan
As System Administrator, set C_Period and C_PeriodControl tables as 'Fully Audited'.
As F&B role admin, open window 'Open/Close period control'
In the grid view, show column "Updated" both in the main tab and in the Documents one.
Select a period of the current year and close it using the "Close Period" button.
Check that the audit trail button in the toolbar is enabled and that the Updated columns has updated |
|