I have deleted some users from Great Plains, why do they still show in the WDC11140 table? This issue has been resolved in the 02-Feb-2006 builds (and later) of Version 8.0 onwards of Omni Password. Omni Password was not detecting the deletion of the user as it was being performed by a stored procedure rather than from the Great Plains code itself. This situation is now handled and users deleted from this build onwards will be deleted from the Omni Password tables as well. To cleanup old entries in the table you can run the following script:
DELETE A FROM DYNAMICS.DBO.WDC11140 A LEFT JOIN DYNAMICS.DBO.SY01400 B ON B.USERID = A.USERID WHERE B.USERID IS NULL