I have a wonderful IT person that has been so involved with any of my GP issues. He was able to fix my issue. Here's what he sent me on how he fixed it.
In the company database having account issues, I located the bad Account records using the SQL query below.
I do not know how or why GL00100.AcctType was a value of 0:
-- We had three consecutive new accounts that were “bad”
SELECT ACCTTYPE, *
FROM GL00100
WHERE ACCTTYPE = 0
-- SQL for fixes below:
/*
-- For each bad Account, only once, run this commented section to generate a next NOTEINDX
-- For us on the “bad” accounts they were zero values as well
DECLARE @MyOutput table(
OldNOTEINDX numeric(19,5),
NewNOTEINDX numeric(19,5)
)
UPDATE DYNAMICS.dbo.SY01500
SET NOTEINDX = NOTEINDX + 1
OUTPUT deleted.NOTEINDX, inserted.NOTEINDX INTO @MyOutput
WHERE CMPANYID = 1
-- Make note of the NewNOTEINDX value and use in your GL00100 update(s) below
SELECT * FROM @MyOutput
SELECT NOTEINDX FROM DYNAMICS.dbo.SY01500 WHERE CMPANYID = 1
*/
/*
-- Fix each of the ACTINDX records by setting ACCTTYPE=1 and assign a generated next NOTEINDEX value
UPDATE GL00100 SET ACCTTYPE = 1, NOTEINDX = 5359559.00000 WHERE ACTINDX = 32311
UPDATE GL00100 SET ACCTTYPE = 1, NOTEINDX = 5359560.00000 WHERE ACTINDX = 32312
UPDATE GL00100 SET ACCTTYPE = 1, NOTEINDX = 5359561.00000 WHERE ACTINDX = 32313
-- Determined the needed items by examining GP stored procedure: dbo.smLoadDefaultAccounts
*/