We have an item that is displaying 3 on hand for a location on inventory adjustments, but when entering this item on sales orders, invoices, item fulfillments, etc for the same location, the on hand shows 2. The item is non-matrix and uses bins. The item is not on the bin-putaway, and has no inventory in inactive bins. Inventory Detail view shows 2 on hand in one bin. How can i find the cause?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** The discrepancy you're experiencing between the on-hand quantity in inventory adjustments and the on-hand quantity when entering the item on sales orders, invoices, item fulfillments, etc. could be due to a few reasons. 1. Transaction Changes: There might have been a transaction that changed the inventory value/bin assignment, and then later someone deleted or updated it after transactions occurred subsequent to it. This could cause a discrepancy in the on-hand quantity. 2. Data Entry Speed: If the user is entering data too quickly, it could result in location info not populating and no bins being selectable in the inventory detail. The solution to this is to either change the location of the adjustment line to something else and then back to the desired location, or to delete and re-enter the line. 3. Negative Stock on Hand: Check for negative stock on hand. This could cause a discrepancy in the on-hand quantity. 4. Inactive Bins: Check if the bin(s) in question hasn't been made inactive for some reason. This could also cause a discrepancy in the on-hand quantity. 5. Bin and Location On Hand Mismatch: There could be a mismatch between the bin on hand and location on hand quantities. This could be due to a deleted/modified inventory or bin transfer. To troubleshoot, you could try turning bins on and off for the item record (do this in a sandbox first if you can). Also, change your view on the bin on hand search to show "not equal to zero" as opposed to greater than zero. This might help you track down the issue.