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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

BAI2 File for Demo/Practice

(0) ShareShare
ReportReport
Posted on by

Is there a BAI2 file that I can get in order to follow this Set up doc. https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/set-up-advanced-bank-reconciliation-import-process

I don't have access to Visual studio.  I am hoping to just be able to have a file, and upload it with test data.  Has anyone done this before or can provide some guidance on what I can do?

I have the same question (0)
  • Suggested answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    Hi SCWIT,

    Please find attached the files that you can use for testing. After you download them, remember to remove ".txt" from the file name so you can use the files.

    BAI2CSV_2D00_to_2D00_BAI2XML.xslt.txtBAI2XML_2D00_to_2D00_Reconciliation.xslt.txt

  • Community Member Profile Picture
    on at

    So you mean save and remove this

    pastedimage1575307320993v1.png

    Also can I still use XML Element as the source type?  I have never set this up before, so I'm definitely out of my comfort and knowledge zone here. 

  • Verified answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    What you have is correct. Seems like you already removed ".txt" from the end of file after saving them.

    To get started, there are blogs that folks have written, try those. See 2 links below that can get you started.

    docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process

    resources.westerncomputer.com/.../time-saving-tips-part-6-automated-bank-reconciliation-in-dynamics-365-finance-and-operations

  • Community Member Profile Picture
    on at

    thank you! I am using those, but now I am having a hard time getting the SampleBankCompositeEntity.xml  Is there a way to get this without accessing the resource file in the AOT?  

  • Suggested answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    Please find attached the xml as wlel. remove ".txt" from file after you download.SampleBankCompositeEntity.xml.txt

  • Community Member Profile Picture
    on at

    Okay, we are almost there! Final file request. How can I get a sample BAI2 file to import and test if my set up is correct?  

  • Suggested answer
    Satish Panwar Profile Picture
    14,671 Moderator on at

    You need to follow steps that are mentioned in link below to set it up completely:

    docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process

    Once setup, follow section with in the link to test out your import:

    docs.microsoft.com/.../set-up-advanced-bank-reconciliation-import-process

  • Satish Panwar Profile Picture
    14,671 Moderator on at

    Hi SCWIT0905,

    Please take time to help verify the answers that help guide you in right direction (files provided above). If you run into any specific issues while testing bank reconciliation, please open another question. We want to have one question per thread so it's easy to track and respond to. Thank you.

  • Community Member Profile Picture
    on at

    I believe the files provided were helpful, but I will not know until I can successfully import a bank statement. I the links and verification of the file name was helpful. I will confirm once Import a statement

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans