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

Openbravo Issue Tracking System - Modules
View Issue Details

ID	Project	Category	View Status	Date Submitted	Last Update
0053575	Modules	Advanced Warehouse Operations	public	2023-10-02 14:46	2023-10-05 13:03

Reporter	lmonreal
Assigned To	agusti_gallego
Priority	high	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Platform		OS	5	OS Version
Product Version
Target Version		Fixed in Version
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release

Summary	0053575: Automatic confirmation for Inventory Count is rounding quantities if there are decimals
Description	When 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 Reproduce	Pre 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 Solution	If I enter decimals in AWO what should be stored in back office is the decimals with no rounding.
Additional Information
Tags	No tags attached.
Relationships
Attached Files

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	bug_revision_view_page.php?rev_id=26931#r26931
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	bug_revision_view_page.php?bugnote_id=0155490#r26943
2023-10-05 09:31	agusti_gallego	Note Edited: 0155490	bug_revision_view_page.php?bugnote_id=0155490#r26944
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

Notes

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.####".