Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014610Openbravo ERP04. Warehouse managementpublic2010-09-20 10:252012-04-26 19:32
Reporterjtarbal 
Assigned ToSandrahuguet 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP21 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014610: Warehouse in "Product Movements Report"
DescriptionCurrently, the Warehouse is not showed in the "Product Movements Report" results. Thus, in a multi-warehouse company, one cannot know from which and to which warehouse the movement has been done.
Steps To Reproduce1.- Make sure you have 2 different warehouses (for example, WH1 and WH2)
2.- Make sure each warehouse has at least 1 storage bin (for example, WH1-0-0-0 and WH2-0-0-0).
3.- Make sure you have stock in each one of the above storage bins.
4.- Go to "Warehouse Management > Transactions > Physical Inventory".
5.- Create a new "Physical Inventory" with one line related to the storage bin WH1-0-0-0. Process the "Physical Inventory".
6.- Repeat step 5 with a "Physical Inventory" of storage bin "WH2-0-0-0".
7.- Go to "Warehouse Management > Transactions > Goods Movement".
8.- Create a new "Goods Movement" with a transaction from WH1-0-0-0 to WH2-0-0-0. Process the transaction.
9.- Go to "Warehouse Management > Analysis Tools > Product Movements Report" and look at the 3 transactions created above.
10.- Realize that there is no way to know from which and to which warehouse the transactions were done.
Proposed Solution
Additional Information
TagsVMA-Reviewed
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-09-20 10:25jtarbalNew Issue
2010-09-20 10:25jtarbalAssigned To => adrianromero
2010-09-20 12:00adrianromeroStatusnew => acknowledged
2011-06-03 10:59dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:12dalsasuaAssigned Todalsasua => jonalegriaesarte
2012-04-03 12:20jonalegriaesarteAssigned Tojonalegriaesarte => vmromanos
2012-04-10 13:45vmromanosTag Attached: VMA-Reviewed
2012-04-16 11:08SandrahuguetAssigned Tovmromanos => Sandrahuguet
2012-04-16 11:16SandrahuguetStatusacknowledged => scheduled
2012-04-16 11:16Sandrahuguetfix_in_branch => pi
2012-04-16 17:53SandrahuguetNote Added: 0047596
2012-04-25 16:14hgbotCheckin
2012-04-25 16:14hgbotNote Added: 0047962
2012-04-25 16:14hgbotStatusscheduled => resolved
2012-04-25 16:14hgbotResolutionopen => fixed
2012-04-25 16:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/705c297b4a4e2a4c98fc507c3527542f2ce0d1a3 [^]
2012-04-25 16:18miruritaNote Added: 0047963
2012-04-25 16:18miruritaStatusresolved => closed
2012-04-26 19:32hudsonbotCheckin
2012-04-26 19:32hudsonbotNote Added: 0048096

Notes
(0047596)
Sandrahuguet   
2012-04-16 17:53   
Test Plan:
-Go to Warehouse and Storage Bins
-Make sure you have 2 different warehouses (for example, WH1 and WH2)
-Make sure each warehouse has at least 1 storage bin (for example, WH1-0-0-0 and WH2-0-0-0).
-Make sure you have stock in each one of the above storage bins.
-Go to "Warehouse Management > Transactions > Physical Inventory".
-Create a new "Physical Inventory" with one line related to the storage bin WH1-0-0-0. Process the "Physical Inventory".
-Repeat step 5 with a "Physical Inventory" of storage bin "WH2-0-0-0".
-Go to "Warehouse Management > Transactions > Goods Movement".
-Create a new "Goods Movement" with a transaction from WH1-0-0-0 to WH2-0-0-0. Process the transaction.
-Go to "Warehouse Management > Analysis Tools > Product Movements Report" and look at the 3 transactions created above.
-Notice that there is a new column for warehouse in the report.
(0047962)
hgbot   
2012-04-25 16:14   
Repository: erp/devel/pi
Changeset: 705c297b4a4e2a4c98fc507c3527542f2ce0d1a3
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Wed Apr 25 10:38:10 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/705c297b4a4e2a4c98fc507c3527542f2ce0d1a3 [^]

Fixed issue 14610 Add warehouse to Product Movements Report
Add a new column with warehouse for each table Product
Movements Report

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.html
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.java
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.xml
M src/org/openbravo/erpCommon/ad_reports/ReportProductMovement_data.xsql
---
(0047963)
mirurita   
2012-04-25 16:18   
code review + testing OK

executed the same report in F&B client using as filters
From Date: 18-04-2011
To Date: 25-04-2012
before and after the patch.
(0048096)
hudsonbot   
2012-04-26 19:32   
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/70a717a9ffa1 [^]

Maturity status: Test