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 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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156