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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0053575
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsmajoralways2023-10-02 14:462023-10-05 13:03
ReporterlmonrealView Statuspublic 
Assigned Toagusti_gallego 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0053575: Automatic confirmation for Inventory Count is rounding quantities if there are decimals

DescriptionWhen I have a product quantity with decimals(for example, four decimals is common when doing Production) and I do an inventory with an automatic confirmation, AWO is doing rounding.
 
See video:
https://drive.google.com/file/d/1iEXWz11kMpEKplf82j4rfCzJqytvTSdN/view?usp=sharing [^]


If I enter 4 decimals in AWO what should be stored in back office is the 4 decimals.

https://openbravo.atlassian.net/browse/RM-8710 [^]
Steps To ReproducePre requ:

-Unit of measure: Set standard quantity as 4 digits
-Set PIc - Physical Inventory (Regular Count) task as Automatic
- Configure preference Allow Goods Transaction outside AWO for Inventories Y

Steps:
1. Do a Physical Inventory in back office and set quantity of a product as 8.231
2. Go to AWO front end and select Look up, it says 8.231 (OK)
3. Go to Count and scan the product and set quantity to 2.1231 and confirm
4. Check the stock in AWO Front end Look up and Back office Warehouse Operations: It says 2


See video:
https://drive.google.com/file/d/1iEXWz11kMpEKplf82j4rfCzJqytvTSdN/view?usp=sharing [^]





Proposed SolutionIf I enter decimals in AWO what should be stored in back office is the decimals with no rounding.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0155485)
hgbot (developer)
2023-10-04 09:54

Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/178 [^]
(0155490)
agusti_gallego (developer)
2023-10-04 11:37
edited on: 2023-10-05 09:31

Test Plan

Previous configuration for case 1:
1. Log into the BO with the System Administrator role.
2. Go to Unit of Measure, find "Unit" and change the Standard Precision to 4.
3. Switch to AWOQA Admin role.
4. Go to Warehouse Definition, select the Warehouse US West Coast and, on Routing, change Physical Inventory Incidental Count to be Automatically confirmed.
5. Go to preferences and set the Allow Goods Transaction outside AWO for Inventories" preference to "Y".

Test case 1:
1. Log into the BO as AWOQA admin role.
2. Create a Normal Physical Inventory in the BO for US West Coast warehouse. Create a line for a product and set the quantity to 8.231.
3. Log into AWO frontend as AWOQA admin role (US West Coast warehouse). Go to Menu > Look up and search for the product. It should have a quantity of 8.231.
4. Go to Menu > Count, add the product, set quantity to 2.1231, and confirm.
5. Go to Menu > Look up and search for the product. It should have a quantity of 2.1231.
6. Go to the BO, go to the Warehouse Operations screen for the US West Coast warehouse and see that the quantity for the product is 2.123 (three decimals rounded). This BO behaviour is governed by the Format.xml config file. To allow for more decimal numbers, change the qtyRelation item from formatOutput="#,##0.###" to formatOutput="#,##0.####".


Previous configuration for case 2:
1. Log back into the BO with the AWOQA Admin role.
2. Go to Warehouse Definition, select the Warehouse US West Coast and, on Routing, change back Physical Inventory Incidental Count to be Manually confirmed.

Test case 2:
1. Log into AWO frontend as AWOQA admin role (US West Coast warehouse). Go to Menu > Look up and search for the product. It should have the quantity confirmed in the previous test case (2.1231).
2. Go to Menu > Count, add the product, set quantity to 2.4321, and confirm.
3. In the task list, there is the confirmation task for the count. Check that the quantity is 2.4321. Confirm the task.
4. Go to Menu > Look up and search for the product. It should have a quantity of 2.4321.
5. Go to the BO, go to the Warehouse Operations screen for the US West Coast warehouse and see that the quantity for the product is 2.432 (three decimals rounded). This BO behaviour is governed by the Format.xml config file. To allow for more decimal numbers, change the qtyRelation item from formatOutput="#,##0.###" to formatOutput="#,##0.####".

(0155575)
hgbot (developer)
2023-10-05 13:03

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: d127f73094a133647e5b0d32833dcb4c26e2a37b
Author: Agustí Gállego <agusti.gallego@openbravo.com>
Date: 04-10-2023 09:54:43
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/d127f73094a133647e5b0d32833dcb4c26e2a37b [^]

Fixes ISSUE-53575: Changed conversion from Integer to Double to allow saving numbers with decimals.

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/processors/InventoryCountDocumentProcessor.java
---
(0155576)
hgbot (developer)
2023-10-05 13:03

Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/178 [^]

- Issue History
Date Modified Username Field Change
2023-10-02 14:46 lmonreal New Issue
2023-10-02 14:46 lmonreal Assigned To => Triage Omni WMS
2023-10-02 14:52 lmonreal Summary Automatic confirmation for Inventory Count is rounding quanties if there are decimals => Automatic confirmation for Inventory Count is rounding quantities if there are decimals
2023-10-03 11:59 mtaal Assigned To Triage Omni WMS => agusti_gallego
2023-10-03 12:34 agusti_gallego Description Updated View Revisions
2023-10-04 09:54 hgbot Note Added: 0155485
2023-10-04 11:37 agusti_gallego Note Added: 0155490
2023-10-05 09:22 agusti_gallego Note Edited: 0155490 View Revisions
2023-10-05 09:31 agusti_gallego Note Edited: 0155490 View Revisions
2023-10-05 13:03 hgbot Resolution open => fixed
2023-10-05 13:03 hgbot Status new => closed
2023-10-05 13:03 hgbot Note Added: 0155575
2023-10-05 13:03 hgbot Note Added: 0155576


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker