Invalid object name 'DBID..GL10000' when posting GL batches

(0) Share

Report

Posted on by Kristie McNulty

I have several users reporting an error when posting GL batches "Invalid object name 'DBID..GL10000' "; where DBID equals the database ID of a now deleted company database.

The company/companies where the postings occur used to have an intercompany relationship with the database ID appearing in the pop-up error message. I'm almost certain we executed the clear-companies script after deleting the database.

Is it okay to delete all instances of the deleted database from the DYNAMICS..IC40100 table? Would this then solve the issue the users are encountering?

What else can I review, what other SQL script can I run, to eliminate this message from appearing?

Full error message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name ‘DBID..GL10000’.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Mick Egan on at

Like (0)

Report

Kristie,

I would check the GL10001 Table and the INTERID Column, as that is the most likely cause of the issue, it is probably seeing the old company in this field.

Mick

Was this reply helpful? Yes No
Suggested answer

DAnny3211 Moderator on at

Like (0)

Report

hi

look this

community.dynamics.com/.../invalid-object-name-sy01400

DAniele

Was this reply helpful? Yes No