We have several inventory items that say they are on sales orders, but those sales orders don't show up under that tab in Item Maintenance. How do we fix this so we can trust our system has the correct information?


We are using Sage 100c Advanced 2018 v. 6.00.8.0
You should find the cause before looking for a solution.
Could be that you just need to rebuild the sort files. Occasionally, those quantities you see on the main tab in the warehouse detail list box get out of sync due to various environment/network related issues.
Refer to this KB for more details.
Just wanted to add a related issue to this post. Issue we had was the quantity shown in the 'On Sales Order' column on the Inventory Stock Status Report differed from the total shown on the Open Sales Order by Item Report for the same item. Rebuilding the Sort Files (especially for SO & IM) and selecting the Recalculation option resolved the issue.
*Community Hub is the new name for Sage City