[
https://issues.apache.org/jira/browse/OFBIZ-5283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13731920#comment-13731920 ]
simon maskell commented on OFBIZ-5283:
--------------------------------------
Hi Scott
It looked to me like the accountingQuantitySum had been used in error as it is never updated from the original received amount. I think it is used to work out FIFO/LIFO(I may be wrong about that). Changing the report to use quantityOnHandSum means the valuations are being done on the correct inventory.
Should accountingQuantitySum be altered as part of a transfer and would that fix the problem without any further changes? - Yes that would fix the problem but it may introduce some more if it is used for FIFO/LIFO calculations.
Am sure someone else would be able to confirm or reject by conclusions.
> 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: SVN trunk
> Reporter: Hans Bakker
> Priority: Critical
> Fix For: SVN trunk
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira
Locked
