Skip to main content
Microsoft Dynamics AX forum
Unanswered

Advance bank reconciliation import process

editSubscribe (0) ShareShare
ReportReport
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
 
 
 
Attachments
  • Community member Profile Picture
    Community member 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

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,130 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,689 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans