LSC View to identify replication counters for transaction headers with missing lines

SELECT TH.Date, TH.[POS Terminal No_], TH.[Entry Status], COUNT(TSE.[Line No_]) AS Lines, TH.[Replication Counter] AS FirstReplCounter, TH.[Net Amount]

FROM     dbo.[Cronus$Transaction Header$5ecfc871-5d82-43f1-9c54-59685e82318d] AS TH LEFT OUTER JOIN

                  dbo.[Cronus$Trans_ Sales Entry$5ecfc871-5d82-43f1-9c54-59685e82318d] AS TSE ON TH.[Store No_] = TSE.[Store No_] AND TH.[POS Terminal No_] = TSE.[POS Terminal No_] AND TH.[Transaction No_] = TSE.[Transaction No_]

GROUP BY TH.[Entry Status], TH.[POS Terminal No_], TH.Date, TH.[Replication Counter], TH.[Net Amount]

HAVING (COUNT(TSE.[Line No_]) < 1) AND (TH.[Entry Status] <> 3) AND (TH.Date > CONVERT(DATETIME, '2025-03-20 00:00:00', 102)) AND (TH.[Net Amount] <> 0)