Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / ABR BAI2 bank statemen...
Finance forum
Answered

ABR BAI2 bank statement import and configuring debit/credit bank transaction types

Posted on by

Running into a challenge when using advance bank reconciliation and importing our BAI2 file. We are running on version 30 and have imported the BAI2 format from the MS repository via the Electronic Reporting workspace. The statement can import however one bank transaction code should be a credit but it's only coming through as a debit. There is no function or configuration within the Transaction code mapping which dictates a specific bank transaction code should be a credit instead of a debit. The bank transaction code in question is 968 and is basically a deposit correction, but regardless it's a credit to the account, not a debit. 

Has anyone else run into this with the new import process and how did you solve it? We just recently upgraded to V30 and lost the prior XLST import format that we were previously using. 

  • Peter191 Profile Picture
    Peter191 on at
    RE: ABR BAI2 bank statement import and configuring debit/credit bank transaction types

    Great, thank you very much, James. Appreciate the support.

  • Verified answer
    JamesT Profile Picture
    JamesT 341 on at
    RE: ABR BAI2 bank statement import and configuring debit/credit bank transaction types

    Hi Peter,

    1) You will need to create a new version of the BAI2 FORMAT (use the DERIVE FROM option)

    2) Select MAP FORMAT TO MODEL

    3) Find the below field in the Model mapping and edit the formula

    pastedimage1680734660759v1.png

    Regards

    James

  • Peter191 Profile Picture
    Peter191 on at
    RE: ABR BAI2 bank statement import and configuring debit/credit bank transaction types

    James, we're struggling to see where we can make edits to these templates. Do you know of any documentation which details how to modify these templates? Thanks.

  • Suggested answer
    Peter191 Profile Picture
    Peter191 on at
    RE: ABR BAI2 bank statement import and configuring debit/credit bank transaction types

    Thank you, James.

  • JamesT Profile Picture
    JamesT 341 on at
    RE: ABR BAI2 bank statement import and configuring debit/credit bank transaction types

    Hi Peter,

    What you mention is a standard issue with the BAI2 files as the banks have different ranges for DR/CR transactions, the standard MS range is 0-399 and 400-699

    The BAI is now done via Electronic reporting.

    It is possible to change the range in Electronic reporting, so you will need to find someone who has the knowledge of how to create a new BAI ER Model and edit it.

    Regards

    James

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans