[jira] [Commented] (OFBIZ-5283) Inventory report shows different counts after a warehouse transfer.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-5283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14228669#comment-14228669 ]

Ratnesh Upadhyay commented on OFBIZ-5283:
-----------------------------------------

[~jacopoc]
We have reviewed the reported issue and able to reproduce it thanks for sharing details. Apart from this we anlayzed further on it, sharing my notes here to get this issue into the next level:
1. Initial inventory for product id: GZ-2644
|| ProductId || InventoryItemId || Facility || ATP || QOH || Comments ||
| GZ-2644 | 9000 | WebStoreWarehouse | 4 | 4 | Currently this is on bulk location. |
2. Locate this inventory item in facility and transfer 2 quantity to MyRetailstore facility, transfer is still in requested status, so now invenoty item looks like:
|| ProductId || InventoryItemId || Facility || ATP || QOH || Comments ||
| GZ-2644 | 9000 | WebStoreWarehouse | 2 | 2 | Currently this is on bulk location. |
| GZ-2644 | 10020 | WebStoreWarehouse | 0 | 2 | Currently this is on bulk location. |
At the same time system has created following records in inventory item details:
|| ProductId || InventoryItemId || QuantityOnHandDiff || AvailableToPromiseDiff || AccountingQuantityDiff || Comments ||
| GZ-2644 | 9000 |  -2 | -2 | 0 |  |
| GZ-2644 | 10020 | 0 | 0 | 0 |  |
| GZ-2644 | 10020 |  2 | 2 | 0 |  |
| GZ-2644 | 10020 |  0 | -2 | 0 |  |
3. Now changed transfer from requested to complete and now the invenotry recods are following:
|| ProductId || InventoryItemId || Facility || ATP || QOH || Comments ||
| GZ-2644 | 9000 | WebStoreWarehouse | 2 | 2 | Currently this is on bulk location. |
| GZ-2644 | 10020 | MyRetailStore | 2 | 2 | System updated existing invenotry item and changed facility id and invenotry counts.|
Inventorey items details records after completing transfer:
|| ProductId || InventoryItemId || QuantityOnHandDiff || AvailableToPromiseDiff || AccountingQuantityDiff || Comments ||
| GZ-2644 | 9000 |  -2 | -2 | 0 | remains unchanged as it was earlier. |
| GZ-2644 | 10020 | 0 | 0 | 0 | remains unchanged as it was earlier. |
| GZ-2644 | 10020 |  2 | 2 | 0 | remains unchanged as it was earlier. |
| GZ-2644 | 10020 |  0 | -2 | 0 | remains unchanged as it was earlier. |
| GZ-2644 | 10020 |  0 | 2 | 0 | added during complete transfer process.|

As we can this in this process no where accouting quantity diff is getting updated but the inventory valuation report is populating information based on acccounting quantity diff and its value grouped by facilityid and unit cost, so the transferred quantity is not reflecting in inventory valuation report.

To fix this issue, we can add following inventory item details entries to balanced out transfered quantities in their original services.
|| ProductId || InventoryItemId || QuantityOnHandDiff || AvailableToPromiseDiff || AccountingQuantityDiff || Comments ||
| GZ-2644 | 9000 |  -2| -2 | -2 | Added at the time of initiation of transfer. |
| GZ-2644 | 10020 | 2 | 2 | 2 | Added at the time of initiation of transfer.  |

Please review these notes and provide your inputs.

> Inventory report shows different counts after a warehouse transfer.
> -------------------------------------------------------------------
>
>                 Key: OFBIZ-5283
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5283
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting
>    Affects Versions: Trunk
>            Reporter: Hans Bakker
>         Attachments: accounting.diff
>
>
> A customer reported the following problem where the inventory report shows different counts after a warehouse transfer.
> Steps to replicate problem
> 1. Choose Facility - Web Store Warehouse
> 2. Select Inventory Items and filter by  product id GZ-2644
> 3. You should see all the items for that product make a note of the Quantity on Hand
> 6. On any of the  Product ID's GZ-2644 click Transfer(Right hand side of the screen)
> 7. Change the To Facility / Container to be My Retail Store
> 8. Transfer only quantity of 1
> 9. Click on Complete Requested Transfer
> 10. Select the item using the checkbox and click submit
> 11. Repeat steps 2 to 3 - Taking note of the  Quantity on Hand which should have changed
> Next
> 1. Click on Accounting
> 2. Click on Organization GL Settings
> 3. Click Accounting for Your Company Name Here
> 4. Click Reports
> 5. Click Inventory Valuation
> 6. Select Web Store Warehouse and click submit
> 7. Note Quantities against GZ-2644 are the Accounting Quantity Total not the Quantity on Hand. -

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)