Hi,
We are upgrading to GP 2018 and during testing we discovered that GP crashes when we do a checkbook balance inquiry. It does it for multiple users in multiple companies for different checkbooks in each company. DEXSQL reveals it is calling the stored procedure itcmPopulateHistChkBalTemp and then throws a long series of errors "Cannot insert the value NULL into column 'HISTINDX', table 'tempdb.dbo.##1951628'; column does not allow nulls. INSERT fails" before the proc terminates and crashes GP.
Here's what I've reviewed:
- Can edit checkbook with no issues
- Can view checkbook register with no issues
- Can reconcile checkbook with no issues
- Disabled Mekorma MICR in case this could be impacting things but got the same result
- Issue does not exist in newly installed TWO company
- Looked for all tables with column HISTINDX in them but found none. One internet search says CM30400 has this column but no such table exists in my companies
I found a related post on this forum from 2016 by Bill Marshall that hinted at a bug in the checkbook balance code related to the HISTINDX column but that one sounded like the balance inquiry form was displaying correctly but the data displayed was not correct.
Any insights are appreciated!
*This post is locked for comments
I have the same question (0)
