Advance bank reconciliation import process

(0) Share

Report

Posted on by CU11091924-0

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

I have the same question (0)

All responses (2)

Answers (0)

Hana Xue Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
CU11091924-0 15 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Join the conversation

Community site session details

Advance bank reconciliation import process

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Advance bank reconciliation import process

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates