web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Importing Bank Transac...
Microsoft Dynamics GP (Archived)

Importing Bank Transactions via Integration Manager with Fees on the Debit Side

(0) ShareShare
ReportReport
Posted on by Community Member

Hello all,

I'm new to GP, I was able to get the bank transactions to load using integration manager by removing the cash distribution line in my upload file and that worked well.

Now I have bank fees that I need to enter in on the debit side of the transaction going into different accounts. When I do that the error I get is "the transaction amount is not fully distributed".

So for amount I have 11680

my first line is a credit for 12000

then my other 2 lines are for debits in the amount of 270 and 50 respectively.

2275.Capture.JPG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Praveen Kumar RR Profile Picture
    Praveen Kumar RR 1,552 on at

    Hi,

    This is issue with Excel Sheet selected for Field Mapping.

    I suggest you to check the default Template for this Integration to know the format that is columns and how values were distributed.

    You can find under Installation Folder of Integration Manager >> IMSamples >>

    Before you work on Data Preparation, make sure that you are able to enter the same transaction manually.

    Thanks,

    Praveen

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,335 on at

    Your Credit =12,000 and Debit only (270+5) ?

    Thats problem. Your Debit Amt should be Match with Credit.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,150 on at

    Hi Benny

    I understand the problem - I haven't tried it myself.

    Because you have the bank fees in there, have you tried adding the bank account line back in with that scenario?

    I will give this a go later on if you don't find a solution and see if I can make it work.

    Cheers

    Heather

  • Community Member Profile Picture
    Community Member on at

    Yes Heather, that's the problem.

    I tried adding back the Debit line, no success, same error message.

    Any help would be appreciated.

    Thank you,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans