When posting a GCR Journal - Error Cannot insert the value NULL into column DepositNumber

Owned by Knowledge Assistant
Last updated: Oct 25, 2021
1 min read



Description of Issue

  • When posting a GCR Journal received:

Error Program stopped at 'glcjeent_prints.4gl', line number 2449.

SQL statement error number -6372 (-50000). [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'DepositNumber', table 'munprod.dbo.JournalsByARDeposits'; column does not allow nulls. INSERT fails. 

  • Posting GCR Journal in General Journal/Proof with a Blank Ref field 3 error occurs.

  • Posted GCR journal is not pulling into Bank Reconciliation.

    • Create Items has been run - Bank Reconciliation Classic only

    • Journal was posted to GL cash account tied to Bank Code/Bank Account 



Context

  • Journal Imports

  • General Journal Entry/Proof

  • Bank Reconciliation 



Cause

This is an error in Bank Reconciliation table. The journal post process still completes.



Resolution

  • MUN-423686 is currently open with development to address this issue.

  • The current workaround is to populate the Reference 3 field in the journal header before posting. 

  • Please report instances of this error to General Ledger Support.



Additional Information

If this error occurs, the GCR journal may not surface in Bank Reconciliation.Â