StockTrim is telling me I have excess stock of an item with little to none on hand. Why is that?

In terms of order planning, StockTrim also includes the on-order quantity. To plan future orders, it makes sense for current on-order items to be taken into account if they’re already on their way, so if they will cover the demand you don’t need to order more.