Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Importing Bank Transac...
Microsoft Dynamics GP (Archived)

Importing Bank Transactions via Integration Manager

(0) ShareShare
ReportReport
Posted on by Bullsai

I'm attempting to import Bank Transaction Entries via Integration Manager and am receiving an error that states "the amount is not fully distributed."

I have two files setup; one header with the fields Key, TransactionDate, PostingDate and Amount and the distribution file with the fields Key, AccountNumber, DebitAmount and CreditAmount.

I have built a Query Relationship on the Key field.

I have set the Record Source Option on the Distributions portion of the Bank Transaction Entry Integration to Use Source Recordset and pointed it to the correct source record.

The files for my test are quite simple and consist of the following:

Header File

Key     TransactionDate     PostingDate     Amount

1         02/02/10                02/02/10          1200

Distribution File

Key     AccountNumber     DebitAmount     CreditAmount

1         Cash Account        1200

1         AR Account                                  1200

 

It seems this should work just fine.  Any ideas?

Thanks,

Todd M Bowlsby

*This post is locked for comments

  • Sma Profile Picture
    Sma 60 on at
    Re: Re: Re: Re: Re: Importing Bank Transactions via Integration Manager

    Hi Siva,

    I did same as you mentioned but I am getting following error while integrating bank transactions in integration manager:

    "DOC 1 ERROR: Distribution amount for line 1 is zero. - Distribution amount for line 1 is zero."

    Any idea or suggestion???

    Regards,

    SMA

  • veeyeskay Profile Picture
    veeyeskay on at
    Re: Re: Re: Re: Re: Importing Bank Transactions via Integration Manager

    Hi Todd

    Nice to hear my suggestions worked for you.

    Feel free to post if you have any more questions.

  • Bullsai Profile Picture
    Bullsai on at
    Re: Re: Re: Re: Importing Bank Transactions via Integration Manager

    Sivakumar:

    Yes, you are correct; outside AR system and bringing in the GL entries.  The reason I'm bringing them via the Bank Transaction Entry is to record them in the Bank Register, as well.

    I would like to thank you and express how grateful I am for your help - SUCCESS!!  Taking out the Debit side of the distribution worked perfectly.

    Take care, my friend.

    All my best,

    Todd M Bowlsby

  • veeyeskay Profile Picture
    veeyeskay on at
    Re: Re: Re: Importing Bank Transactions via Integration Manager

    Hi Todd

    Thanks for your answers.

    So ideally, you are using GP just for your General Ledger and you have a custom AR system outside GP to track receivables. :-)

    Let me know if you need further assistance and feel free to update the status of the findings.

  • Bullsai Profile Picture
    Bullsai on at
    Re: Re: Importing Bank Transactions via Integration Manager

    Sivakumar:

    Thanks for the quick response.

    I'll try removing the entry to the Debit side and using a setting of Default.  I was wondering if they may have something to do with it but hadn't yet tried it.

    Answers to your questions (good ones, BTW):

    1. Yes, the Checkbook ID is set as a constant as they will only be hitting one account.
    2. This is actually an entry coming from an outside AR system (they're a healthcare facillity and have an industry-specific AR system).

    Take care,

    Todd M Bowlsby

  • veeyeskay Profile Picture
    veeyeskay on at
    Re: Importing Bank Transactions via Integration Manager

    Hi Todd

     I can see that you pass in the Cash Account distribution in the distribution file, which would not be needed, since it is defaulted by the system based on the checkbook selected in the transaction. So remove the cash distribution line in your distribution file and then try to integrate, and it should ideally work.

    Couple of questions:

    • I do not see the checkbook ID in your header file. Is it a constant value in your integration?
    • I can see that you are hitting the AR control account. How can u logically hit the AR control account outside receivables? Will it not cause an imbalance between the AR and GL? Just a doubt...

    Let me know if you need further assistance.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans