Hi Andrew,
According to Epicor Support, when we upgraded from E9, the upgrade did not set a sequential identifier correctly and so the system was pulling up the account from an old transaction that had the this old sequential identifier.
Here’s the SQL they told us to run; The first two select statements tell us if the SysGLCntrlCodeSeq is a wrong value. They should be identical. The update statement fixes the sequential ID. We did this fix before Christmas and haven’t had error occur again. We are on 10.1.600.5
SELECT *
FROM Ice.SysBigSequence
WHERE NAME =‘SysGLCntrlCodeSeq’
SELECT MAX(ABS(SysGLControlCode))
FROM ERP.TranGLC
UPDATE Ice.SysBigSequence
SET CurrentValue =(SELECT MAX(ABS(SysGLControlCode))FROM ERP.TranGLC)
WHERE NAME =‘SysGLCntrlCodeSeq’
Hopefully this help you too!
Nancy