“The transaction amount is not fully distributed” Error in Integration Manager

Microsoft Dynamics GPI helped a client create a bank transaction integration in Integration Manager the other day. It’s been a while since I created an integration like this, so we created it as I would a general ledger integration with a header and distribution file with two distributions for each transaction. However, when we ran the integration, we received this error message:

Integration Manager error log

The transaction amount is not fully distributed

I had forgotten that bank transactions can only have one of the distributions can be mapped (this is covered in a knowledge base article from Microsoft.

This integration was only for creating increase adjustment transactions, so we amended the integration so that only the Debit Amount destination field was mapped. After making this change, the integration ran successfully.