Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0046945Openbravo ERP02. Master data managementpublic2021-06-02 10:102021-09-01 15:10
a_singh 
Triage Omni OMS 
normalmajoralways
closedinvalid 
5
3.0PR19Q2 
 
dmiguelez
Core
2021-07-31
No
0046945: In Business Partner Location tab, updating location address fields does not updates the audit fields like updated and updated by
In the business partner window >> location tab, if we try to update the location selector's address fields then save the record.
We found the audit fields like updated and updated by are not updated.
1. Go the Business Partner window, select any record.
2. Then go to the Location tab and open it in form view and check for audit fields like Updated and Updated By
3. Click on the location search selector field and a pop up appears with
   Address 1, Address 2, City, Postal code, Country and Region fields then update any of the fields and press OK button which closes the pop up.
4. Save record in the Business Partner Location tab and then we can check the audit fields Updated and Updated By without any change i.e. its not updated.
No tags attached.
Issue History
2021-06-02 10:10a_singhNew Issue
2021-06-02 10:10a_singhAssigned To => Triage Finance
2021-06-02 10:10a_singhModules => Core
2021-06-02 10:10a_singhRegression date => 2021-06-16
2021-06-02 10:10a_singhTriggers an Emergency Pack => No
2021-06-17 14:56Theo_DelobelNote Added: 0129613
2021-07-19 11:52egoitzRegression date2021-06-16 => 2021-07-31
2021-07-19 12:25dmiguelezReview Assigned To => dmiguelez
2021-07-19 12:25dmiguelezNote Added: 0130564
2021-07-19 12:25dmiguelezStatusnew => closed
2021-07-19 12:25dmiguelezResolutionopen => invalid
2021-09-01 15:08Theo_DelobelNote Added: 0131489
2021-09-01 15:09Theo_DelobelIssue Monitored: Theo_Delobel
2021-09-01 15:10Theo_DelobelIssue End Monitor: Theo_Delobel

Notes
(0129613)
Theo_Delobel   
2021-06-17 14:56   
Hello,
Did you have any new on this subject ?
(0130564)
dmiguelez   
2021-07-19 12:25   
This is not an issue, this is the standard and expected behavior.

The audit fields are updated when the data of the underlying table is updated.
In this case, the main table behind the window is c_bpartner_location, however the table that holds the location information is c_location.

This is a special case in which the system is behaving as expected and is consistent, but from the User experience it can be improved.

The proper way to manage this situation is to report a Feature Request asking for a trigger that updates the audit of the c_bpartner_location table whenever the information of the related c_location record gets updated.
(0131489)
Theo_Delobel   
2021-09-01 15:08   
Hello David,

About this subject, our developper add the trigger as suggested but he getting an error as per attached video.

Can you help us on this subject ?