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

Advanced Bank Rec - leading zeros on checks

(1) ShareShare
ReportReport
Posted on by 18
My BAI2 file brings in checks as 581 type - so the check number is in the Account Servicer reference field - but with 4 leading zeros.  Is there any way to configure the match rule so that it ignores those zeros when matching?  Or a way for the import to map these as checks and import to the correct field without IT customization?  I can only get the matching to work if I edit the BAI2 files before uploading which is really annoying, especially on days when we have 100 checks clear.
 
Line from BAI2 file:
 
16,581,5503798,Z,09292159088,0000121405/
 
Two items to match:
 
Current rule to match if I remove leading zeros:
 
I have the same question (0)
  • Jonas "Jones" Melgaard Profile Picture
    4,988 Most Valuable Professional on at
    Configuration wise, I don't think so. You will either have to change the BAI2 format in electronic reporting, or make a customization to F&O
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    14,686 Super User 2025 Season 2 on at
    This can be achieved by creating a derived version of the "ABR BAI2 format" and adding a specific rule to exclude zeros when importing bank statements for account servicer reference field.

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
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans