Check the SO detail table (and possibly tier distribution table) for orphaned lines (missing SO header).  Rebuild sort files for SO recalculates the value you see as On SO in the IM_ItemWarehouse file, but it doesn't exclude orphaned rows.

Hi Kevin, I have an Access DB with links to Sage 100. I ran  the following SQL queries to check for those orphaned rows between SO_SalesOrderDetail and SO_SalesOrderHeader:

• Select * From So_SalesOrderHeader As SOD
  Where Not Exists (Select SalesOrderNo From SO_SalesOrderHeader SOH Where SOD.SalesOrderNo = SOH.SalesOrderNo)
  This returned no rows...to double verify I ran the Inverse:
• Select * From So_SalesOrderHeader As SOD
  Where Exists (Select SalesOrderNo From SO_SalesOrderHeader SOH Where SOD.SalesOrderNo = SOH.SalesOrderNo)
  And I received the same number of rows (112) as in the query below:
• SELECT Count(SalesOrderNo) AS SOCount From (Select Distinct SalesOrderNo From SO_SalesOrderDetail SOD)

So it seems that there are no orphaned rows.

Tier Distribution table...can you point me to that area?
I am looking at the Cost Detail tab on the item inquiry, and I do see the Quantities / Cost / Committed values. Committed is zero for all tiers.

Select * From So_SalesOrderDetail As SOD where...

For Tier distribution: SO_SalesOrderTierDistribution

To be complete, also look in IM_DataEntryCostCalcCommit which should be blank normally.  (It locks inventory between printing a journal and the update processing).

For Tier distribution: SO_SalesOrderTierDistribution

To be complete, also look in IM_DataEntryCostCalcCommit which should be blank normally.  (It locks inventory between printing a journal and the update processing).

Both the SO_SalesOrderTierDistribution &  IM_DataEntryCostCalcCommit tables are empty.