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) / 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

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

    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.

  • Bullsai Profile Picture
    Bullsai on at

    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

    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

    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

    Hi Todd

    Nice to hear my suggestions worked for you.

    Feel free to post if you have any more questions.

  • Sma Profile Picture
    Sma 60 on at

    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

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
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans