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

Announcements

No record found.

News and Announcements icon
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:
 
  • Jonas "Jones" Melgaard Profile Picture
    5,016 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
    15,225 Super User 2026 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
Martin Dráb Profile Picture

Martin Dráb 426 Most Valuable Professional

#2
CU10121822-0 Profile Picture

CU10121822-0 358

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 353 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans