В AX 2009 проверял превышение RecId при помощи такого запроса:
PHP код:
SELECT SQLDICTIONARY.*, SYSTEMSEQUENCES.MAXVAL, SYSTEMSEQUENCES.NEXTVAL
FROM SYSTEMSEQUENCES
INNER JOIN SQLDICTIONARY
ON SQLDICTIONARY.FIELDID = 0
AND SQLDICTIONARY.TABLEID = SYSTEMSEQUENCES.TABID
AND SYSTEMSEQUENCES.NEXTVAL = (SYSTEMSEQUENCES.MAXVAL - 1)