So where, in that, do you ever reference a bill of lading number???

And where is your GROUP BY, in any case.

Since this appears to be SQL Server (because of the "dbo." and the CONVERT with number 101), I can't believe you aren't getting an error message about the lack of GROUP BY.