Error Number = 944 Stored Procedure= taGLTransactionHeaderInsert Error Description = Unbalanced journal entry, the credits do not equal the debits

This usually relates to a bug in the MS eConnect stored procedure taGLTransactionHeaderInsert. Wipfli has developed a fix for this and will provide it on-demand for clients.

The bug has to do with not including rounding account types in the summation of all JE lines for validation. Rounding accounts are used for any rounded amounts in multi-currency lines.

 

Below is the difference between the fixed and original code:

Revised Stored Proc:

SELECT @TRXTOTAL1 = sum(CRDTAMNT)

FROM GL10001 a(NOLOCK)

WHERE a.BACHNUMB = @I_vBACHNUMB

AND a.JRNENTRY = @I_vJRNENTRY

AND a.ACCTTYPE <> 2

SELECT @TRXTOTAL1 = isnull(@TRXTOTAL1, 0)

SELECT @TRXTOTAL2 = sum(DEBITAMT)

FROM GL10001 a(NOLOCK)

WHERE a.BACHNUMB = @I_vBACHNUMB

AND a.JRNENTRY = @I_vJRNENTRY

AND a.ACCTTYPE <> 2

 

 

Original Stored Proc:

SELECT @TRXTOTAL1 = sum(CRDTAMNT)

FROM GL10001 a(NOLOCK)

WHERE a.BACHNUMB = @I_vBACHNUMB

AND a.JRNENTRY = @I_vJRNENTRY

AND a.ACCTTYPE IN (

1

,3

)

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk