web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How do I upload a BAI2...
Microsoft Dynamics GP (Archived)

How do I upload a BAI2 file into Dynamics GP 2016

(0) ShareShare
ReportReport
Posted on by juandedios74 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

I have the same question (0)
  • Tim W Profile Picture
    Tim W 2,925 on at

    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

  • juandedios74 Profile Picture
    juandedios74 66 on at

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

  • juandedios74 Profile Picture
    juandedios74 66 on at

    Hello Tim,

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

  • Tim W Profile Picture
    Tim W 2,925 on at

    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

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans