As my previous reply was removed by moderators, I will try to keep this succinct and light.
You are correct - this problem has a long history with no permanent fix.
In terms of fixing the issue on an item by item basis, we have found the following helpful - it is not a 100% fix, but works maybe 95% of the time.
1. Do an inventory adjustment to add sufficient qty and $ value to ensure you have both a positive inventory and positive dollar value.
2. Do a "Count Inventory" and set the inventory to a non-zero whole number (e.g. 1) and process the adjustment
3. Do step 2 again - but setting the inventory to 0 and process any adjustment created.
As a separate comment - this is a frustrating fault that needs to be rectified properly in code. Only MYOB has the capacity to institute a re-code to achieve this. And it has been needed for many years.
As Inventory management is a core feature of an integrated accounting package it needs to work properly or be sufficiently transparent to allow users to fix issues themselves as (if) they arise.