Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044058Openbravo ERP03. Procurement managementpublic2020-05-13 22:052020-06-12 13:36
Reportersdossantos 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR20Q3 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0044058: The Creation Date,  Created By, Update Date, Updated By fields appear blank in the Create Line from Order and Create Line from R
DescriptionWhen the Create line from order or Create line from receipt processes are used in the Purchase Invoice window, the Creation Date,  Created By, Update Date, Updated By fields appear blank.
Steps To Reproduce1 - Create a purchase order with a business partner X, add a line and complete it.
2 - Create a Good Receipt with a business partner X, add a line and complete it.
3 - Create a Purchase Invoice with a business partner X, and press the button Create line from Order, you will see the purchase order created in point 1, display the columns Creation Date,  Created By, Update Date, Updated By. These columns will be displayed empty4 -  Do the same when pressing the create line from the receipt button.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0044270 new Triage Platform Base Audit columns are added by default in HQL/Datasource based grids when columns not present 
Attached Files? Bug-2020-05-13_16.20.57.mkv (4,563,034) 2020-05-13 22:05
https://issues.openbravo.com/file_download.php?file_id=14479&type=bug
Issue History
Date ModifiedUsernameFieldChange
2020-05-13 22:05sdossantosNew Issue
2020-05-13 22:05sdossantosAssigned To => Triage Finance
2020-05-13 22:05sdossantosFile Added: Bug-2020-05-13_16.20.57.mkv
2020-05-13 22:05sdossantosModules => Core
2020-05-13 22:05sdossantosTriggers an Emergency Pack => No
2020-05-22 10:33ngarciaResolution time => 1591912800
2020-05-25 12:55dmiguelezAssigned ToTriage Finance => inigo_lerga
2020-05-25 15:23inigo_lergaStatusnew => scheduled
2020-05-28 11:26inigo_lergaNote Added: 0120391
2020-06-01 22:23lbressanIssue Monitored: achaves
2020-06-03 09:41cbernerRelationship addedrelated to 0044270
2020-06-10 18:21dmiguelezAssigned Toinigo_lerga => AtulOpenbravo
2020-06-11 11:11AtulOpenbravoNote Edited: 0120391bug_revision_view_page.php?bugnote_id=0120391#r21177
2020-06-12 13:34hgbotCheckin
2020-06-12 13:34hgbotNote Added: 0120825
2020-06-12 13:34hgbotStatusscheduled => resolved
2020-06-12 13:34hgbotResolutionopen => fixed
2020-06-12 13:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f79f06b119f167e3e7333a622e283a516d758864 [^]
2020-06-12 13:34hgbotCheckin
2020-06-12 13:34hgbotNote Added: 0120826
2020-06-12 13:36dmiguelezReview Assigned To => dmiguelez
2020-06-12 13:36dmiguelezNote Added: 0120827
2020-06-12 13:36dmiguelezStatusresolved => closed
2020-06-12 13:36dmiguelezFixed in Version => 3.0PR20Q3

Notes
(0120391)
inigo_lerga   
2020-05-28 11:26   
(edited on: 2020-06-11 11:11)
--Test Plan Mantis--

As the F&B International Group Admin wole in Backend:
  - Go to Purchase Invoice window and select any record available.
    Press the Create Lines From Order buton and a grid will appear.
    If no records are shown press the clean filters button.
    To see the new columns (Creation Date, Created By, Update and Updated By)
    right click in the top of the grid, press Columns option and select
    the mentioned new fields.
    Now the fields are displayed and filled with the correct data.
    Try to sort or filter data with created/updated/createdBy/updatedBy column
    Sorting and Filtering works properly.

  - Repeating this process with the Create Lines From Receipt will show also
    the new fields filled with the correct data.
(0120825)
hgbot   
2020-06-12 13:34   
Repository: erp/devel/pi
Changeset: f79f06b119f167e3e7333a622e283a516d758864
Author: Iñigo Lerga <inigo.lerga <at> openbravo.com>
Date: Mon Jun 01 10:25:56 2020 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f79f06b119f167e3e7333a622e283a516d758864 [^]

Fixes BUG-44058:Added Creation Date, Created By, Update and Updated By

Added these values to the hql query of M_InOutLine_PE_HQL and
C_OrderLine_PE_HQL tables. Also, fields and columns are defined in
Aplication Dictionary for these values, added proper ENTITY_ALIAS

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/common/datasource/InOutLinePEHQLTransformer.java
M src/org/openbravo/common/datasource/OrderLinePEHQLTransformer.java
---
(0120826)
hgbot   
2020-06-12 13:34   
Repository: erp/devel/pi
Changeset: 1c5b851491ba7cd1dec9dcc88a96c3e4dd62bacf
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Jun 11 08:55:59 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/1c5b851491ba7cd1dec9dcc88a96c3e4dd62bacf [^]

Related to BUG-44058:The Creation Date, Created By, Update Date,
Updated By fields appear blank in the Create Line from Order and
Create Line from Receipt

**Fetch creationDate, updated, createdBy name, updatedBy name
from OrderLine object e in HQL query for both Create Line from
Order and Receipt datasources, modify the entity alias, set
proper lengths to columns, add them in group by clause
in respective HQL transformers

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_TABLE.xml
M src/org/openbravo/common/datasource/InOutLinePEHQLTransformer.java
M src/org/openbravo/common/datasource/OrderLinePEHQLTransformer.java
---
(0120827)
dmiguelez   
2020-06-12 13:36   
Code Review + Testing Ok