Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Bank Transaction - Integration Error

Posted on by 65

I'm trying to integrate bank transaction but keep getting this error... DOC 1 ERROR: Field 'Distributions.Account Number' does not have a default value. I mapped the account number but unable to change the default value which blank.

 

*This post is locked for comments

  • CG-Fisk Profile Picture
    CG-Fisk on at
    RE: Bank Transaction - Integration Error

    Im still having that problem. The problem is in the mapping between the "type, and the credit and debits." There is a file in MS with 3 probable solutions on how to set up the distribuions on the detail file that may help you.

  • CG-Fisk Profile Picture
    CG-Fisk on at
    RE: Bank Transaction - Integration Error

    I had the same problem. My problem was in the header and detail files which had extra data that I failed to delete. My files had over 20 rows that had no data accept for the continuous of the index number from the copy feature.

  • Tevon Taylor Profile Picture
    Tevon Taylor 65 on at
    Re: Bank Transaction - Integration Error

    I'm still getting same error message. I closed all screens except the main module and IM. Does it matter if another user on GP or only 1 person on for this to work?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Bank Transaction - Integration Error

    Yes, IM requires all GP screens to be closed. As long as you do that and then assign the checkbook ID to your integration it will run.

  • Tevon Taylor Profile Picture
    Tevon Taylor 65 on at
    Re: Bank Transaction - Integration Error

    So what you suggest is closed all GP screens and just only run GP and IM?

    Okay let me try that. This is the only error I receieve thus far.

     

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Bank Transaction - Integration Error

    Yes, that is how IM works. It goes through the same motions as if you were manually entering the data. This is why you must have GP running to run any integrations and have all GP screens closed.

  • Tevon Taylor Profile Picture
    Tevon Taylor 65 on at
    Re: Bank Transaction - Integration Error

    Well when I manually input bank transaction entry and select checkbook, the GL account automatically show up. Now with intergration, I didn't put in the checkbook GL thinking same as manual entry just point to the checkbook then it should showup.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Bank Transaction - Integration Error

    Have you assigned the GL account number to the checkbook? This account cannot be changed. Cards->Financial->Checkbook

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans