One of the possible reasons why Bin Quantity Higher than Location On Hand is due to 'Use Bins' Had Been Turned Off and On
To resolve, create an Inventory Adjustment that will allow you to zero out the quantity on hand from the bin. To do this:
I. Unmark 'Use Bins' in the Item Record
1. Edit Item Record.
2. Under Purchasing/Inventory Tab > Unmark 'Use Bins' checkbox.
3. Hit Save
II. Create an Inventory Adjustment to remove the Location and Bin On Hand Mismatch
1. Navigate to Transactions > Inventory > Adjust Inventory.
2. Set the Item and Locations. Adjust Qty By field depends on the difference. (Value in this field should be negative if Location On Hand is greater than Bin On Hand)
3. Assign values to other mandatory fields and hit Save.
III. Mark 'Use Bins' in the Item Record again
1. Edit Item Record.
2. Under Purchasing/Inventory Tab > Mark 'Use Bins' checkbox.
3. Hit Save.
IV. Create another Inventory Adjustment to bring back the original Location On Hand
1. Navigate to Transactions > Inventory > Adjust Inventory.
2. Set the Item and Locations. Adjust Qty By field depends on the difference. (Value in this field should be the opposite of the value in the first adjustment)
3. Assign values to other mandatory fields and hit Save.
4. Refresh the Item Record and verify that the quantity matches.