Find CAM import with bills from multiple companies

SQL
SELECT ImportPaymentItems.ImportPaymentId, Bills.Id FROM ImportPaymentItems LEFT JOIN Bills ON Bills.Id=ImportPaymentItems.BillId
LEFT JOIN ImportPayments ON ImportPayments.Id = ImportPaymentItems.ImportPaymentId WHERE BillId is not null AND Bills.VatAccountId <> ImportPayments.VatAccountId

Flying Fleet
Contact us for more information or to book a live demo.
Flying Fleet is a Redcrest Solutions product.

+41 41 511 50 99
Redcrest Solutions GmbH
Sinserstrasse 67
6330 Cham Switzerland
2026 Flying Fleet. All rights reserved.