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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bank Transaction Integ...
Microsoft Dynamics GP (Archived)

Bank Transaction Integration Error

(0) ShareShare
ReportReport
Posted on by Community Member

My Bank Transactions upload is failing and giving me error "DOC 1 ERROR: The total originating debit must equal the total originating credit" although my originating Dr and Cr are both equal. We are using GP9 and if i remove the Cr side trans from the file the integration goes successful but if i want to upload some trans with both Dr and Cr in the file it always fails and gives me the same error. Please note that i am uploading trans mainly in the originating currency i.e AED, BHD etc, anybody knows a way around to get rid of this error?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Good day Faisal, this error typically can come from one of the following scenarios: You have a single file where you have multiple distributions per journal entry to import, or you have a 2 file source but not properly configured the relationships.

    To solve the issue on #1, define a second source file that contains all the details and have a first source file just grouped by the Journal entry / date, then use relationships to match them together,

    To solve the issue #2 verify the relationships on your source files.

    What you are probably doing is importing a single side transaction, verify that when you upload without the Cr if the transaction by default populates the Cr with the checkbook account, it might be easier than you think

  • Community Member Profile Picture
    Community Member on at

    Hi Francisco

    I do have 2 source file (header & detail) and I am using column INDEX, JR# and Date to define a link b/w the two files and the relationship is also based on these 3 keys. As I mentioned before my upload only fails when I try to add the Dr side of transaction into the file as you know that the system always picks the DR side of the entry from the account that is linked to the Checkbook. My transaction is a little bit different than usual as the amount to be distributed to the Checkbook is let say 5000 AED then when distributing the amount I am distributing more than the checkbook amount as you can in the example below where I have 5000 AED as checkbook amount but I am distributing 6000 AED, the 2 other debit entries are for some charges so I need to account them but not to the checkbook account.

    I have tested this entry and it works fine if I enter it through the Bank Transactions Screen but it fails to upload when I try to upload it through Integration and gives the error.

    INDEX Journal Option Type Date ACC Debit Credit Dist Ref CHECKBOOK Amount

    1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-02-05240 5000.00 0.00 Test HSBC-001 5000.00

    1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-14-62980 500.00 0.00 Test HSBC-001 5000.00

    1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-28-88060 500.00 0.00 Test HSBC-001 5000.00

    1 RCP0051 Enter Receipt Cash 07/06/2011 151-19-00-28-88020 0.00 2500.00 Test HSBC-001 5000.00

    1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-02-05245 0.00 1000.00 Test HSBC-001 5000.00

    1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-14-62615 0.00 1500.00 Test HSBC-001 5000.00

    1 RCP0051 Enter Receipt Cash 07/06/2011 151-00-00-14-62100 0.00 1000.00 Test HSBC-001 5000.00

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February 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