sayo

(<> IN('108','121','122') ? '999' : <<Multi-Shipment Invoices - Sales R )

/* פירוט החזרות סחורה מלקוח */
‎ 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 ;