Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How do I upload a BAI2 file into Dynamics GP 2016

(0) ShareShare
ReportReport
Posted on by 66

Hello Everyone,

 I'm new to GP and I'm working in a test environment I have setup with Dynamics GP2016. I have a file that was downloaded from our bank which is in the BAI format. How can I upload the file into GP? Any assistance would be greatly appreciated. I've downloaded it onto my desktop and it's in a .TXT format. 

Thanks

Juan D

*This post is locked for comments

  • Suggested answer
    RE: How do I upload a BAI2 file into Dynamics GP 2016

    Dynamics GP doesn't have a BAI2 format out of the box, you'll have to make some modifications, which are explained here

    We have the modified version of the BAI2 file format and you can download it for free here.

  • juandedios74 Profile Picture
    juandedios74 66 on at
    RE: How do I upload a BAI2 file into Dynamics GP 2016

    Thanks Tim!!!! I'll have my cloud admins install the additional product. 

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: How do I upload a BAI2 file into Dynamics GP 2016

    Open the Dynamics.set file in the client directory and see if you have this as a product:

    1428

    Electronic Reconcile

    If not you need to load the product which is not too difficult these days, you can go to add/remove programs from Windows and select Modify to Dynamics-GP, I think E Rec is a selection in additional products.

    I'm on a perpetual license, might also be your license is not for that product.  If you have a listed reseller they can easily answer that.  

  • juandedios74 Profile Picture
    juandedios74 66 on at
    RE: How do I upload a BAI2 file into Dynamics GP 2016

    Hello Tim,

    My GP is not displaying Electronic Reconcile under Financial->Routines. It displays only Reconcile to GP only. Any suggestions?

  • juandedios74 Profile Picture
    juandedios74 66 on at
    RE: How do I upload a BAI2 file into Dynamics GP 2016

    Thanks Tim! I'll try it and will let you know how it worked out for me. :)

  • Tim W Profile Picture
    Tim W 2,925 on at
    RE: How do I upload a BAI2 file into Dynamics GP 2016

    If you go to Financial -> Routines -> Electronic Reconcile  you will find the five windows that are the Bank Import windows.  There are a couple windows to be configured to link your file to the proper checking account.  On the configuration window you can select BAI as format which gets you pretty far for the mapping though you might need to tweak it further.  This is not  the easiest thing to set up properly, often trial and error depending on your bank file so I'd start with the eBanking manual and read through it.

    Chapter 6.

    download.microsoft.com/.../electronicbanking.pdf

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans