Thursday, November 20, 2008

Open outstanding AR from Lawson M3 (Movex) ERP system

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.

1 comment:

Anonymous said...

You got a syntactical error in there Shiva - the extra closing bracket.