inconsistencies in the g/l entry table

Business Central/NAV Developers Forum
1

ERROR MESSAGE WHEN POST PAYMENT LINE (’ the transaction cannot be completed because it will cause inconsistencies in the g/l entry table CHECK WHERE AND HOW THE CONSISTENT FUNCTION IS USED IN THE TRANSACTIION TO FIND TRHE REASON FOR THE ERROR
TABLE CAN BE MARKED AS INCONSISTENT DURING COMPREHENSIVE TASKS SUCH AS POSTING THIS PREVENTS DATA FROM BEING UPDATED INCORRECTLY)

THIS ERROR MESSAGE IN NAV CLASSIC CLIENT 2009 R2

2

Create a codeunit and in the codeunit add the below code.

Storetotemp variable Boolean
TempGLEntry varialble G/L entry (Makesure its set to temporary)

OnRun()
BEGIN
IF NOT StoreToTemp THEN BEGIN
StoreToTemp := TRUE;
END ELSE
PAGE.RUNMODAL(0,TempGLEntry);
END;

InsertGL(GLEntry : Record “G/L Entry”)
BEGIN
IF StoreToTemp THEN BEGIN
TempGLEntry := GLEntry;
IF NOT TempGLEntry.INSERT THEN BEGIN
TempGLEntry.DELETEALL;
TempGLEntry.INSERT;
END;
END;
END;

go to Codeunit 12 and search for below code, call the InsertGL function from codeunit 12 and right before the below code call the above codeunit and this will tell you where the error is.

GlobalGLEntry.CONSISTENT(

3

Hi,

this is not a usual message. Thus you might have a wrong code running on the system.

Have you or your partner made changes to the system ?

Gabor