One of the repeated request received from the finance users (specially AR manager or Supervisor) a list of outstanding AR Invoices.
The sql statement will query the M3 (Movex) table FSLEDG to provide AR invoices that are not paid:
SELECT ESDIVI, ESCUNO, ESINYR,ESCINO, ESDUDT, MAX(ESDUDT) AS DUEDATE, MAX(ESIVDT) AS INVOICEDATE, SUM (ESCUAM) AS OUTAMT
FROM FSLEDG WHERE ESCONO=1 AND ESDIVI = '100' GROUP BY ESDIVI, ESCUNO, ESINYR, ESCINO, ESDUDT HAVING SUM (ESCUAM) <> 0
Substitute the ESCONO and ESDIVI value with the required Company number and Division.