Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Advance bank reconciliation import process

Posted on by 15
Hi folks,
 
I am implementing advance bank recon for my client. I imported the ABR BAI2 Format file from electronic reporting and configured it under our bank statement format in d365 as below:
 
After testing the import of bank statements that we received from the bank. The bank statement was imported successfully, and I was able to validate it as well. On the reconciliation worksheet, the document number field on the bank statement lines (on the right screen) is empty for all transactions but we have these document numbers on the bank statement text file we received from the bank. Somehow, the document number field is blank for all transactions on the right side of the screen. I need the document number to populate on the bank statement lines so I can set up a matching rule to match with the document number. 
 
 
Is there anything I need to do on the electronic reporting side of the BAI2 format? 
 
Thank you,
Belle
 
 
 
  • CU11091924-0 Profile Picture
    CU11091924-0 15 on at
    Advance bank reconciliation import process
    Hello Hana, 
     
    Thank you for replying to this post. How can I ensure the mapping is correct between the BAI2 file and the corresponding fields in D365FO? Do I need a developer to look into this or it can be done on the front end of D365?
     
    Thanks,
    Belle
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Advance bank reconciliation import process
    Hi,
    Ensure that the BAI2 format in electronic reporting is configured correctly. Verify that the mapping between the fields in the BAI2 file and the corresponding fields in D365FO is accurate.
    You can check this blog to set matching rules, it mentions payment reference = document number
    https://namithhosmanesblog.com/2018/01/06/setup-matching-rules-advance-bank-reconciliation/
    Best Regards,
    Hana

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans