Openbravo Issue Tracking System - Retail Modules
View Issue Details
0036307Retail ModulesMobile Physical Inventorypublic2017-06-22 11:442017-06-28 08:51
ngarcia 
ebecerra 
urgentmajoralways
closedfixed 
5
 
RR17Q3 
marvintm
No
0036307: Wrong qty count in physical inventory lines if order quantity and uom fields are filled (2nd UOM) and counted is not selected
Wrong qty count in physical inventory lines if order quantity and uom fields are filled (2nd UOM) and counted is not selected
As system admin role:
   Set as Active the following tabs:
      Product - UOM
      Unit Of Measure - Conversion
   Set as Displayed Order Quantity and Order UOM fields of warehouse document lines (goods receipt, physical inventory...)

As group admin role (in backend):
   Create a new product and assign a new Unit of Measure in UOM tab
   Define the conversion between that UOM and the Unit of Measure in product definition
   Add a purchase price list to it
   Create a Goods Receipt
   Add the previously created product
   Refresh the tab
   Set the Order UOM and Order Quantity fields and check the Movement Quantity field is automatically filled
   Complete it
   Create a new physical inventory
   Add the previously created product
   Refresh the tab
   Decrease the Order Quantity field and check Quantity Count field is updated automatically
   Do not select the Counted checkbox and Process Inventory
   Check the Quantity count field has been updated with the Book Quantity (so there is no change on the stock) but the Order Quantity is not modified and the stock is only decreased in one of the units (leaving the stock with wrong conversion between units)
Two possible solutions:

- The Order Quantity field could be also updated with the value of the Quantity Order Book field in order not to make any change in the stock as Counted has not been selected.

- Counted field could always be Y in the physical inventory lines created from the backend
No tags attached.
related to design defect 0035625 closed Retail Process Inventory button not working properly in mobile Physical Inventory 
causes defect 0037551 closed jorge-garcia Wrong Quantity Count in inventory lines if they are created with Create Inventory Count List process and not edited in mobile 
Issue History
2017-06-22 11:44ngarciaNew Issue
2017-06-22 11:44ngarciaAssigned To => Retail
2017-06-22 11:44ngarciaResolution time => 1499896800
2017-06-22 11:44ngarciaTriggers an Emergency Pack => No
2017-06-22 11:45ngarciaRelationship addedrelated to 0035625
2017-06-22 11:45ngarciaIssue Monitored: ngarcia
2017-06-22 11:49ngarciaIssue End Monitor: ngarcia
2017-06-22 11:49ngarciaIssue Monitored: networkb
2017-06-27 10:53ngarciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15426#r15426
2017-06-27 12:42marvintmNote Added: 0097707
2017-06-27 12:46ebecerraAssigned ToRetail => ebecerra
2017-06-27 18:37hgbotCheckin
2017-06-27 18:37hgbotNote Added: 0097715
2017-06-27 18:37hgbotStatusnew => resolved
2017-06-27 18:37hgbotResolutionopen => fixed
2017-06-27 18:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse.physicalinventory/rev/4f2e3f925405f80ef7e551a457eb957d93a8796d [^]
2017-06-28 08:51marvintmReview Assigned To => marvintm
2017-06-28 08:51marvintmStatusresolved => closed
2017-06-28 08:51marvintmFixed in Version => RR17Q3
2017-12-27 12:09ngarciaRelationship addedcauses 0037551

Notes
(0097707)
marvintm   
2017-06-27 12:42   
After further discussion, the changes which are required in this issue are:
- Counted field should always be Y when creating the physical inventory in the backend
- The field should also be always hidden, so that the user cannot mistakenly change it, as it's only relevant when using the Mobile Physical Inventory application.
(0097715)
hgbot   
2017-06-27 18:37   
Repository: erp/pmods/org.openbravo.mobile.warehouse.physicalinventory
Changeset: 4f2e3f925405f80ef7e551a457eb957d93a8796d
Author: Eduardo Becerra <ebec70 <at> yahoo.com>
Date: Tue Jun 27 18:36:57 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.warehouse.physicalinventory/rev/4f2e3f925405f80ef7e551a457eb957d93a8796d [^]

Fixed issue 36307: Set default value to "Y" and hide column "Counted"

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
---