Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

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

Posted on by 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

  • William Calloway Profile Picture
    William Calloway 125 on at
    RE: GP/Integration Manager -- DOC 1 ERROR: Distribution amount for line 1 is zero

    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.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: GP/Integration Manager -- DOC 1 ERROR: Distribution amount for line 1 is zero

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans