What table are you pulling from??  OE Shipments or OE Invoices??

OESHID OE Shipment Details

This is my query

SELECT dbo.OESHDT.SHIPDATE AS "SHIPDATE", RTRIM(dbo.ICITEM.FMTITEMNO) AS "FMTITEMNO", dbo.OESHDT.QTYSOLD AS "QTYSOLD", dbo.OESHDT.FAMTSALES AS "FAMTSALES", OESHDT.ORDNUMBER, OESHDT.DAYENDSEQ
FROM (dbo.ICITEM JOIN dbo.OESHDT ON dbo.ICITEM.ITEMNO = dbo.OESHDT.ITEM)
WHERE dbo.OESHDT.FAMTSALES > 0 AND (dbo.OESHDT.SHIPDATE = '20250219') ORDER BY dbo.OESHDT.ORDNUMBER ASC

OESHDT is a sales history details table and would only be updated when invoiced/dayend run.  I don't think this would be the right table to query from what you described.

What about using OESHID details table and OESHIH header table??  These are updated at time of the shipment.

OESHID gets me most of the way there.  not sure how to get the $ amount from there to replace dbo.OESHDT.FAMTSALES, but I think this gets me on the right track.

Thanks you! 

use OESHID.EXTSHIMISC for sales amount.  Or QtyShipped*UnitPrice.

Thanks for you help on this.  I was able to get what I needed.