Accounts Receivable > Reports > Shipped Not Invoiced sometimes returns Shipments that are not returned in AR Invoice Entry > Actions > Get Shipments > View Not Invoiced Packing Slips. If this happens, review the Invoice when Complete checkbox on the associated Sales Order headers.

Invoice when Complete
This field specifies an invoice to be created only when the associated sales order is completely shipped. If not all sales order releases are shipped, no invoices will be created when the Get Shipments action or the Generate Shipment Invoices process is executed. This validation occurs for both regular shipments and drop shipments.

This select will get a list of the Sales Orders for the Packs. Use DMT to update InvcOrderCmp from 1 to 0

select distinct OH.Company,OH.OrderNum, C.CustID CustomerCustID, OH.InvcOrderCmp

from ERP.OrderHed OH, ERP.Customer C, ERP.ShipDtl SD

where C.Company=OH.Company and C.CustNum=OH.CustNum and OH.Company='CC5'

and C.Company=SD.Company and OH.OrderNum=SD.OrderNum and SD.PackNum in (6628,7098,6977,7093,7103,7095,7096,7178,7179,7181,7159,7313)

order by OH.Company, OH.OrderNum