Difficulty building an Integration Manager job to import Bank Transactions

(0) Share

Report

Posted on by Community Member

I am trying to build an Integration Manager job that allows us to import Bank Transactions. I have it working for Increase Adjustments, but when I try to do a Decrease adjustment I get the following error: The transaction amount is not fully distributed. Can anyone tell me what I have set up incorrectly?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

twelvestrikes 3,657 on at

Like (0)

Report

RE: Difficulty building an Integration Manager job to import Bank Transactions

Hi Rachel

Looks like you have set up the integration correctly, but without looking at the source file it will be hard to trouble shoot this.

Can you place a screen shot of your source file?

Was this reply helpful? Yes No
Derek Albaugh on at

Like (1)

Report

RE: Difficulty building an Integration Manager job to import Bank Transactions

Hello Rachel,

I did find one support case we saw, where they were getting this same error in IM and it mentioned that 'the transaction is not fully distributed' error is due to when you select a checkbook in the Bank Transaction Entry window, the default cash account assigned to the checkbook will default in as a line within the account section.'

I think in this case they took the Debit side of the distribution out and that worked for them.

We also have this KB article:

Error message when you run the Bank Transaction integration in Integration Manager for Microsoft Dynamics GP: "The Transaction Amount is Not Fully Distributed"

support.microsoft.com/.../error-message-when-you-run-the-bank-transaction-integration-in-integra

This article was last updated in 2015, so should still be relevant for the most part.

Thanks,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Difficulty building an Integration Manager job to import Bank Transactions

Sure!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Difficulty building an Integration Manager job to import Bank Transactions

If I modify the IM job to accommodate the Decrease Adjustment transaction type, I get errors for the Increase Adjustment transaction type. Is there a way to use the same IM job to handle both types of adjustments?

Was this reply helpful? Yes No
Derek Albaugh on at

Like (1)

Report

RE: Difficulty building an Integration Manager job to import Bank Transactions

The only thing I've been able to find so far on similar cases using IM for a bank transaction and getting this same error, is that the error is caused by the credit amount auto populating, in most cases.

What I could find mentions that when creating a Bank Transaction integration, the Cash Amount will default from the Checkbook ID, thus the only Account that needs to be specified during the integration is the Offset Account. Depending on the type of bank transaction you are creating, will depend on the Account and which Amount field (debit or credit) that you will be populating.

For example, if the integration is for the 'Check' transaction type, the Cash Amount from the Checkbook ID will populate the credit side of the Distribution, so the integration would be set up to populate the debit amount.

It appears that the integration may need to be setup differently according to the type you are integrating, i.e. Check, Increase Adjustment, Decrease Adjustment or Withdrawal.

Let me try to verify this and I'll update this with my findings.

Thanks,

Was this reply helpful? Yes No