
When attempting to lookup check numbers we receive the error 1002 followed by the error 91 on following attempts. Any help would be greatly appreciated.
It looks like a VBA error. Here are some things you can check into:
1. See if the error happens if you set security back to the unmodified window.
2. See if you get any results from these scripts: They check for account segments that don't exist, as I've seen that throw this same error before.
select * from GL40200 where SGMTNUMB not in (select SGMTNUMB from SY00300)
3. If it still happens with an unmodified window, you can try to run a dexsql.log and see where it's looking when it errors. If you still need help, you may need to open a support case for additional assistance.
Hope that helps,
Cheryl
Microsoft Dynamics GP Support