הורדתי את שורת התנאי שהוספתי ולהן הדוח:
/* פירוט החזרות סחורה מלקוח */
SELECT DOCUMENTS.CURDATE AS 'תעודה תאריך',
DOCUMENTS.DOCNO AS 'תעודה',
CUSTOMERS.CUSTNAME AS 'לקוח .מס',
CUSTOMERS.CUSTDES AS 'לקוח שם',
DOCUMENTS.DETAILS AS 'פרטים',
PART.PARTNAME AS 'ט"מק',
PART.PARTDES AS 'מוצר תאור',
REALQUANT(TRANSORDER.TQUANT) AS 'כמות',
(MIN(TODOLIST.UDATE)) AS 'תעודה הקמת תאריך',
MAX(INVOICEITEMS.IVDATE) AS 'אחרונה מכירה תאריך'
FROM WAREHOUSES , INVOICES , TODOLIST , INVOICEITEMS , TRANSORDER
, PART , CUSTOMERS , DOCUMENTS
WHERE (DOCUMENTS.TOWARHS = WAREHOUSES.WARHS)
AND (WAREHOUSES.WARHSNAME '50')
AND (TRANSORDER.TYPE = 'N')
AND (INVOICES.TYPE = 'A')
AND (DOCUMENTS.TYPE = 'N')
AND (INVOICES.STORNOFLAG 'Y')
AND (INVOICEITEMS.PART = PART.PART)
AND (DOCUMENTS.TYPE = TRANSORDER.TYPE)
AND (INVOICES.FINAL = 'Y')
AND (INVOICES.CUST = CUSTOMERS.CUST)
AND (INVOICEITEMS.IV = INVOICES.IV)
AND (DOCUMENTS.DOCNO = TODOLIST.DOCNO)
AND (TRANSORDER.PART = PART.PART)
AND (DOCUMENTS.DOC = TRANSORDER.DOC)
AND (CUSTOMERS.CUST = DOCUMENTS.CUST)
AND ( 1=1 )
GROUP BY 1, 2, 3, 4, 5, 6, 7, 8
HAVING MAX(INVOICEITEMS.IVDATE) <= ((MIN(TODOLIST.UDATE)))
AND ( 1=1 )
ORDER BY 2 ASC ;
