Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0044058
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 03. Procurement managementmajoralways2020-05-13 22:052020-06-12 13:36
ReportersdossantosView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in VersionPR20Q3
StatusclosedFix in branchFixed in SCM revisionf79f06b119f1
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0044058: 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.
TagsNo tags attached.
Attached Files? file icon Bug-2020-05-13_16.20.57.mkv [^] (4,563,034 bytes) 2020-05-13 22:05

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0044270 newTriage Platform Base Audit columns are added by default in HQL/Datasource based grids when columns not present 

-  Notes
(0120391)
inigo_lerga (reporter)
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 (developer)
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 (developer)
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 (developer)
2020-06-12 13:36

 Code Review + Testing Ok

- Issue History
Date Modified Username Field Change
2020-05-13 22:05 sdossantos New Issue
2020-05-13 22:05 sdossantos Assigned To => Triage Finance
2020-05-13 22:05 sdossantos File Added: Bug-2020-05-13_16.20.57.mkv
2020-05-13 22:05 sdossantos Modules => Core
2020-05-13 22:05 sdossantos Triggers an Emergency Pack => No
2020-05-22 10:33 ngarcia Resolution time => 1591912800
2020-05-25 12:55 dmiguelez Assigned To Triage Finance => inigo_lerga
2020-05-25 15:23 inigo_lerga Status new => scheduled
2020-05-28 11:26 inigo_lerga Note Added: 0120391
2020-06-01 22:23 lbressan Issue Monitored: achaves
2020-06-03 09:41 cberner Relationship added related to 0044270
2020-06-10 18:21 dmiguelez Assigned To inigo_lerga => AtulOpenbravo
2020-06-11 11:11 AtulOpenbravo Note Edited: 0120391 View Revisions
2020-06-12 13:34 hgbot Checkin
2020-06-12 13:34 hgbot Note Added: 0120825
2020-06-12 13:34 hgbot Status scheduled => resolved
2020-06-12 13:34 hgbot Resolution open => fixed
2020-06-12 13:34 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f79f06b119f167e3e7333a622e283a516d758864 [^]
2020-06-12 13:34 hgbot Checkin
2020-06-12 13:34 hgbot Note Added: 0120826
2020-06-12 13:36 dmiguelez Review Assigned To => dmiguelez
2020-06-12 13:36 dmiguelez Note Added: 0120827
2020-06-12 13:36 dmiguelez Status resolved => closed
2020-06-12 13:36 dmiguelez Fixed in Version => 3.0PR20Q3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker