Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039988Openbravo ERP04. Warehouse managementpublic2019-01-21 16:492019-03-28 14:55
Reporterfrancisco 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket7578
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039988: Last inventory counting no updating
DescriptionWhen is created an inventory, and the product quantity remain the same (is not changed) the date at the bin content tab is not updating.
This can be confusing because you cannot see if this specific product was counted or not during the inventory.
Steps To Reproduce1. Go to physical inventory window and create a new inventory
2. Go to lines and create a new record
3. Without changing any "quantity count" click on Process inventory Count button
4. Go to warehouse and storage bins window and select the register from where the inventory was process
5. In Bin content tab you can see in "Last inventory count date" is not updated. Otherwise if you had changed "quantity count" it is mentioned in step 3, the "Last inventory count date" is updated
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-01-21 16:49franciscoNew Issue
2019-01-21 16:49franciscoAssigned To => Triage Finance
2019-01-21 16:49franciscoOBNetwork customer => No
2019-01-21 16:49franciscoModules => Core
2019-01-21 16:49franciscoTriggers an Emergency Pack => No
2019-01-21 16:58PracticsIssue Monitored: Practics
2019-01-21 18:15franciscoOBNetwork customerNo => OBPS
2019-01-21 18:15franciscoResolution time => 1549839600
2019-01-22 08:48dmiguelezAssigned ToTriage Finance => AtulOpenbravo
2019-01-23 10:58ngarciaSupport ticket => 7578
2019-01-25 07:29AtulOpenbravoStatusnew => scheduled
2019-01-25 07:29AtulOpenbravoNote Added: 0109243
2019-01-31 10:05hgbotCheckin
2019-01-31 10:05hgbotNote Added: 0109347
2019-01-31 10:05hgbotStatusscheduled => resolved
2019-01-31 10:05hgbotResolutionopen => fixed
2019-01-31 10:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6d346acd0ba3fb403660a9efb0d84e500df0c655 [^]
2019-01-31 10:12SandrahuguetReview Assigned To => Sandrahuguet
2019-01-31 10:12SandrahuguetNote Added: 0109350
2019-01-31 10:12SandrahuguetStatusresolved => closed
2019-01-31 10:12SandrahuguetFixed in Version => 3.0PR19Q2
2019-01-31 11:11SandrahuguetNote Added: 0109351
2019-03-28 14:55hudsonbotCheckin
2019-03-28 14:55hudsonbotNote Added: 0110762

Notes
(0109243)
AtulOpenbravo   
2019-01-25 07:29   
- Go to physical inventory window and create a new inventory
- Go to lines and create a new record
- Without changing any "quantity count" click on Process inventory Count button
- Go to warehouse and storage bins window and select the register from where the inventory was process
- In Bin content tab you can see in "Last inventory count date" is updated.
(0109347)
hgbot   
2019-01-31 10:05   
Repository: erp/devel/pi
Changeset: 6d346acd0ba3fb403660a9efb0d84e500df0c655
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Jan 29 23:14:28 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/6d346acd0ba3fb403660a9efb0d84e500df0c655 [^]

Fixes Issue 0039988: Last inventory counting no updating

M_Transaction records are not created for inventory count line
having qtyCount equals to book quantity or order quantity equals
order quantity book. Hence update inventory is not called which
actual updates the date inventory in M_Storage_Detail.

Update Date Inventory method is introduced and now used to update
date in such cases which calls update inventory.

---
M src/org/openbravo/materialmgmt/InventoryCountProcess.java
---
(0109350)
Sandrahuguet   
2019-01-31 10:12   
Code review + testing OK
(0109351)
Sandrahuguet   
2019-01-31 11:11   
We are not going to provide script to fix data because there is a workaround.

With the fix applied, create a new Physical Inventory / Process Inventory Count and the Last Inventory Count Date is now updated.
(0110762)
hudsonbot   
2019-03-28 14:55   
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/b2fbc1588df4 [^]
Maturity status: Test