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

Notifications

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) / GP/Integration Manager...
Microsoft Dynamics GP (Archived)

GP/Integration Manager -- DOC 1 ERROR: Distribution amount for line 1 is zero

(0) ShareShare
ReportReport
Posted on by Lydia Robinson 55

I am having a difficult time integrating bank transaction entries into GP via Integration Manager.  When I run the integration, I get the following message:  "DOC 1 ERROR: Distribution amount for line 1 is zero". 

Header/source file -- columns::  KEY Date CheckbookID Amount

Line/source file -- columns: : KEY Date Account Debit Credit Reference

Each KEY of the detailed source file is only listing if it'sa debit or a credit hitting the specific bank account. 

Here is an example: 
1 12/14/2011 222-3333-44444 0 1,234.56 Lockbox Deposit

Can you show me what I'm missing that's preventing the integration from completing? What am I missing?

 

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    You need two source files. The amount needs to be in each file (header and line). For the Distributions mapping, make sure the Source is pointing to the line source (in the options tab). The distribution needs one column for the debit and one column for the credit.

  • William Calloway Profile Picture
    William Calloway 125 on at

    I know this is an old thread however, there are a few things you need to take care of in order for the integration to work. In the integration mapping, if you are using multicurrency, (foreign currency bank account in a USD based company) the "Origination Debit" and "Originating Credit" must be mapped. If you are using a foreign currency in a foreign currency denominated company the "Debit" and "Credit" must be mapped. For instance: Your company is USD based but the transactions are integrating into a JPY based bank account "Originating" columns must be mapped. Conversely if the company is USD based and the bank account is a USD bank account then the "Debit" and "Credit" will be mapped.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans