Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Electronic Reconcile
Microsoft Dynamics GP (Archived)

Electronic Reconcile

(0) ShareShare
ReportReport
Posted on by Yolanda 690

Has anyone been successful with using the "Electronic Reconcile" segment of electronic banking especially since this segment does not support the BAI format that 90% of the banks use?   As a work around, our company has chosen to export our bank statement data into excel and from there put the data into the format that I have mapped in the Electronic reconcile configurator window.  I have specified the path to the file in the download maintenance window and when I go to the transactions download window none of the data from the file populates into the scrolling window.  I have tried many different ways to map the file in the configurator window all with the same results.  Does anyone have any other suggestions that I could try? 

*This post is locked for comments

  • Kumar_Sat Profile Picture
    Kumar_Sat 1,146 on at
    RE: Electronic Reconcile

    I am configuring it for Wells Fargo but for some reason it is not working, any idea? I get the error  - record type match not found

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Electronic Reconcile

    Hi, I am still having issues with the reconciliation, after summit, it seems like a lot of people are on the same boat..

    Is there anyway people can share the one file that is working for them?

    My bank can provide CSV or BAI2.. but everytime i have a record type match not found.. the codes are there and they are set up.. dont know what else to do..

  • Catherine L. Profile Picture
    Catherine L. 2,010 on at
    RE: Electronic Reconcile

    Hi all,

    I need to perform the same setup of a BAI2 file using GP2010's configurator. Were you all able to find a means of configuring the file format to work properly with both checks and deposits? Is it possible to set this up without having to modify the download file data?

  • a.j. anguiano Profile Picture
    a.j. anguiano 35 on at
    Re: Re: Electronic Reconcile

    Daniela,

     

    I am going through the same issue, getting a report that will have checks and deposits and feeding it to Electronic Reconcile  the bank is not being very helpful as the previous file they provided, which never worked had only checks information. From that based a csv was provided but could it be possible that the code configuration be modified, I will work on that, if you go to the bank reconciliation set up screen you will find the transaction codes, the only transaction that matches the code from the banks generally is for the checks as it is "CHK".

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Electronic Reconcile

    Thank you Yolanda

    My question was on the bank type codes.

    Because it will recognize other stuff, but on the configurator  will only let you set up one detail type code.

    It seems silly as all businesses have more than just deposits or checks..

    Maybe I am missing something, we also have a huge check volume.. but if the system is business intended...... 

     

  • Yolanda Profile Picture
    Yolanda 690 on at
    Re: Re: Re: Re: Re: Electronic Reconcile

    Daniela,

    When matching transactions, electronic reconcile matches checks based on the check number and bank cleared date or the dynamics transaction date, this is the reason that the program is able to reconcile your check data.  Regarding your deposits, I believe it would work the same way although I have not tested this.  You may have to edit the information in your download file to match the deposit number generated by the Great Plains system.  Regarding the other transactions (i.e. increase adjustments, decrease adjustments, withdrawasl, etc.), you will have to manually mark of these items as "electronic reconcile' does not recognize these transactions.       

    During my testing, I manually marked off deposits and the other types of transactions as I am really only concerned with the volume of checks that we have every month that need to marked as cleared.  I hope this helps!!!!!

     

     

     

      

     

     

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Electronic Reconcile

    THANK YOU SOOO MUCH!

    I can start growing all the hair I pulled with this!!!

    Now I have another problem though, on the detail/header/footer, I can only set one detail line there

    right now I got it to where it will reconcile the checks (which is already a lot of help!) but it not recognizing deposits or anything else..

    Do you have anymore wisdom to share?

     

     

     

  • Yolanda Profile Picture
    Yolanda 690 on at
    Re: Re: Re: Electronic Reconcile

    Hi Daniela,

    After several tests, I finally got the electronic configurator program to work.  During my first tests, like you I was using a CSV format I changed it to a tab delimited (i.e. text file) and it is working.  When using a CSV file for some reason it puts double quotes around some of the fields.  If you open your file in notepad or wordpad you will be able to see the double quotes.  I think that electronic reconcile has a problem with the quotes.  Try saving your file as a tab-delimted file instead.  Also, I setup configurator to use only detail lines no header or footer record types.  I hope this helps!      

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Electronic Reconcile

    Hi,

    I am in the same situation, I am downloading from the bank, I get a CSV, and try to bring it in to GP but it tells me error transaction because it can't read the code..

    Instructions in GP are not great on how to set up the codes/types which I think might be the problem I am having...

     Help?

     

  • Yolanda Profile Picture
    Yolanda 690 on at
    Re: Re: Electronic Reconcile

    Makr,

    Currently, the new bank that we are opening our accounts with "only" provide BAI transmission files.  They have no other formats.  Electronic Reconcile according to the documentation does not support this format.  The "only" other option that we were given by our bank is to export our banking activity into excel.  As a result, the bank is really not providing us with a format which leaves me to make up our own.  I have configured several fixed, tab, and comma delimited formats in the "Electronic Reconcile" configurator window in addition to experimenting with several header and detail options.  I am changing the format in excel to match the format that I developed.  Even with this manipulation, the data is not importing correctly as nothing appears in my scrolling window after selecting download and then the transactions button.  The banking information that we export into excel from the banks is as follows:

    Account Number, Date Posted, Amount, Description, Check Number, Reference Number, and Activity Type.  

    Regarding our Partner, they have set up custom EDI programs for several of their clients however they have not worked extensively with the Electronic Reconcile product.  As a company, we would really like to get Electronic Reconcile working as this is one of the reasons our firm purchased the "Electronic Banking" suite of products. We don't want to pay extra for something custom written.  Any assistance that you can provide would be greatly appreciated.   

       

     

     

     

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