How to Navigate this SmartConnect Error: ‘Cannot insert the value NULL into Column DepAmt’ on GP BankRec Deposit Integration

In this video, we troubleshoot a SmartConnect integration error when creating a Dynamics GP Bank Reconciliation Deposit Without Receipts:

'Cannot insert the value NULL into column DepAmt'

Although a Deposit Amount is mapped and populated, eConnect ignores the supplied value because the Deposit Type was not specified. As a result, eConnect defaults to Deposit with Receipt, attempts to calculate the deposit total from receipts that don't exist, and ultimately generates the NULL error.

We'll show how to identify the root cause, understand the eConnect default behavior, and fix the integration by explicitly setting the Deposit Type to Deposit Without Receipts. To read the help article that goes with this, click here.