Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0053575 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Modules] Advanced Warehouse Operations | major | always | 2023-10-02 14:46 | 2023-10-05 13:03 | |||
Reporter | lmonreal | View Status | public | |||||
Assigned To | agusti_gallego | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM 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 | |||||||
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. | |||||||
Tags | No 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 |