Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0036825 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 04. Warehouse management | major | always | 2017-09-11 15:21 | 2017-09-21 16:50 | |||
Reporter | ngarcia | View Status | public | |||||
Assigned To | AtulOpenbravo | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | 3.0PR17Q4 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 6db8cd340ee2 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | aferraz | |||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | 47904 | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0036825: Warehouse field of Inventory Amount Update Lines is not shown after saving the record although it has a value | |||||||
Description | Warehouse field of Inventory Amount Update Lines is not shown after saving the record although it has a value The problem is that iswarehousedimension auxiliary input has a value of 'N' and the callout SL_InvAmtUpd_ProductRefDate is not launched as there is not any change on product or reference date fields | |||||||
Steps To Reproduce | As group admin role: Create a new costing rule, set Warehouse Dimension to Y Validate it Create a new Inventory Amount Update Add a line to it Select a warehouse, add a product and a cost to it Save it Check the Warehouse field disappears | |||||||
Proposed Solution | Remove iswarehousedimension calculation in SL_InvAmtUpd_ProductRefDate callout. Move this logic to warehouse field display logic. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(0099054) AtulOpenbravo (viewer) 2017-09-14 23:18 |
Test Plan - Login as group admin role. - In Costing rule realize that for F&B US Inc Org, Warehouse dimension is set as No. - Create a new Inventory Amount Update. - Add a line to it. - Check the Warehouse field is not displayed. - Remove Inventory Amount Update record created. - Create a new costing rule for F&B US Inc organization, set Warehouse Dimension to Y and validate it. - Create a new Inventory Amount Update in F&B US Inc Org. - Add a line to it. - Check the Warehouse field is displayed. - Select a warehouse, add a product and a cost to it and save it. - Check the Warehouse field is still displayed. |
(0099099) hgbot (developer) 2017-09-18 12:02 |
Repository: erp/devel/pi Changeset: 6db8cd340ee21fe8a4a84acb146999d14b2b8641 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Fri Sep 15 04:46:11 2017 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/6db8cd340ee21fe8a4a84acb146999d14b2b8641 [^] Fixes issue 36825: Warehouse field of Inventory Amount Update Lines not shown Warehouse field of Inventory Amount Update Lines is not shown after saving the record although it has a value Set SQL based value for auxiliar input iswarehousedimension in inventory amount update line tab. It is calculated on organization and reference date in the line tab. --- M src-db/database/sourcedata/AD_AUXILIARINPUT.xml --- |
(0099100) hgbot (developer) 2017-09-18 12:02 |
Repository: erp/devel/pi Changeset: cebdb602a9f11f904a99d38327f3074ed5bf14e8 Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com> Date: Mon Sep 18 11:40:40 2017 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/cebdb602a9f11f904a99d38327f3074ed5bf14e8 [^] Related to issue 36825: Code review improvements Use min to retrieve only one record. Remove coalesce as Warehouse_Dimension is a not null column. Rename alias with a shorter name. Remove IsActive condition. Remove exists condition and change datefrom and dateto conditions to retrieve always the current costing rule. SL_InvAmtUpd_ProductRefDate callout will remove warehouse value in case auxiliary input retrieves false. --- M src-db/database/sourcedata/AD_AUXILIARINPUT.xml M src/org/openbravo/erpCommon/ad_callouts/SL_InvAmtUpd_ProductRefDate.java --- |
(0099102) aferraz (viewer) 2017-09-18 12:05 |
Code review + Testing OK |
(0099403) hudsonbot (viewer) 2017-09-21 16:50 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9750b78d3e5c [^] Maturity status: Test |
(0099404) hudsonbot (viewer) 2017-09-21 16:50 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9750b78d3e5c [^] Maturity status: Test |
![]() |
|||
Date Modified | Username | Field | Change |
2017-09-11 15:21 | ngarcia | New Issue | |
2017-09-11 15:21 | ngarcia | Assigned To | => Triage Finance |
2017-09-11 15:21 | ngarcia | OBNetwork customer | => Yes |
2017-09-11 15:21 | ngarcia | Modules | => Core |
2017-09-11 15:21 | ngarcia | Support ticket | => 47904 |
2017-09-11 15:21 | ngarcia | Resolution time | => 1504303200 |
2017-09-11 15:21 | ngarcia | Triggers an Emergency Pack | => No |
2017-09-11 15:21 | ngarcia | Issue Monitored: networkb | |
2017-09-11 16:39 | ngarcia | Resolution time | 1504303200 => 1506895200 |
2017-09-11 16:49 | aferraz | Assigned To | Triage Finance => AtulOpenbravo |
2017-09-11 16:51 | aferraz | Proposed Solution updated | |
2017-09-14 20:06 | AtulOpenbravo | Status | new => scheduled |
2017-09-14 23:18 | AtulOpenbravo | Note Added: 0099054 | |
2017-09-18 12:02 | hgbot | Checkin | |
2017-09-18 12:02 | hgbot | Note Added: 0099099 | |
2017-09-18 12:02 | hgbot | Status | scheduled => resolved |
2017-09-18 12:02 | hgbot | Resolution | open => fixed |
2017-09-18 12:02 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/6db8cd340ee21fe8a4a84acb146999d14b2b8641 [^] |
2017-09-18 12:02 | hgbot | Checkin | |
2017-09-18 12:02 | hgbot | Note Added: 0099100 | |
2017-09-18 12:05 | aferraz | Review Assigned To | => aferraz |
2017-09-18 12:05 | aferraz | Note Added: 0099102 | |
2017-09-18 12:05 | aferraz | Status | resolved => closed |
2017-09-18 12:05 | aferraz | Fixed in Version | => 3.0PR17Q4 |
2017-09-21 16:50 | hudsonbot | Checkin | |
2017-09-21 16:50 | hudsonbot | Note Added: 0099403 | |
2017-09-21 16:50 | hudsonbot | Checkin | |
2017-09-21 16:50 | hudsonbot | Note Added: 0099404 |
Copyright © 2000 - 2009 MantisBT Group |