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
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,
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?
Sure!
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,
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (