Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics GP (Great Plains) > GP - General
  New Posts New Posts RSS Feed - Bank Transaction Integration Failure
  FAQ FAQ  Forum Search   Register Register  Login Login

Bank Transaction Integration Failure

 Post Reply Post Reply
kclancy View Drop Down Member Member

Joined: April 11 2011
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote kclancy Quote  Post ReplyReply Direct Link To This Post Topic: Bank Transaction Integration Failure
    Posted: April 13 2011 at 3:29pm

I am new to GP and Integration Manager and I am attempting to use the Bank Transaction integration sample that came with GT.  I have two *.csv files, one the header and one the line source.  In the line source, I have entered the debits and credits and reviewed them to be sure they balance each other out.  When I run the integration, however, I am getting an error message for each document which says 'The transaction amount is not fully distributed - The transaction amount is not fully distributed.' and I am not sure what the problem is as the credits and debit do balance each other out.  We are using Microsoft Dynamics GP 2010, version 11.00.1307 (RTM).  Any help will be greatly appreciated.


Sample Header file record –


Option: Enter Receipt

Type: Credit Card


Number: 123123

Card Name: Master Card

TRX Date: 4/1/11

Posting Date: 4/1/11

Amount: 2000.00

Paid To:

Received From: John Doe

Description: Tuition Fees

Index #: 1


Sample Line file records -


Index #: 1

Account #: 11-11-11-111-1111-11

Debit: $2000.00

Credit: $0.00

Distribution Reference: Cash – Operating x####


Index #: 1

Account #: 22-22-22-222-2222-22

Debit: $0.00

Credit: $2000.00

Distribution Reference: Accounts Rec-Sample



Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Copyright 2013 All rights reserved. is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com