Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX2012 R3 Bank Stateme...
Microsoft Dynamics AX (Archived)

AX2012 R3 Bank Statement Import - Transaction Code Mapping form

(0) ShareShare
ReportReport
Posted on by AliC420 40

Hello,

I have setup the ability to Import a Bank Statement File (BAI2 file format).  I wish to create bank transactions (e.g Bank Fees) automatically based on certain criterias.

Is this the purpose of the Transaction Code Mapping form ( Setup-> Bank Reconciliation-> Transaction Code Mapping) ?  IF not, what is the purpose of this setup?

I have setup a link between the Statement Transaction Code and the Bank Transaction Type in this Form.  How do I get AX to execute so it recognise the Statement Transaction Code and create the Bank Transaction?  

Any guidance would be appreciated.

Regards

Ali

 

 

*This post is locked for comments

  • Verified answer
    AliC420 Profile Picture
    AliC420 40 on at
    RE: AX2012 R3 Bank Statement Import - Transaction Code Mapping form

    I got the functionality working to auto create bank transaction such as bank fees.

    1. Setup Bank Transaction Type with Main Account

    2. Setup Transaction Code Mapping 

    3. Setup Reconciliation Matching Rules.  Make sure to tick "Mark New Transaction" option and Untick "Search Bank Document" option.

    4. Run the Matching Rules in the Bank Reconciliation Worksheet Form.  This will mark the transaction as "New" and it will now appear in the Matched Documents section.  Also if you view the transaction in the Bank Statement Form you can view the Distribution Accounts.

    I found the below link useful: 

    http://www.stoneridgesoftware.com/how-to-use-advanced-bank-reconciliation-matching-rule-sets-in-ax-2012/

  • AliC420 Profile Picture
    AliC420 40 on at
    RE: AX2012 R3 Bank Statement Import - Transaction Code Mapping form

    Thanks Bashir for your response.  I was after a more detailed response about one particular aspect of the Reconciliation functionality.

    I have already setup and got the system to import bank statements, auto match (matching rules) transactions during the reconciliation process.

    Really after information on the purpose of the "Transaction Code Mapping" form within the Bank Reconciliation process.  What function does it perform?

  • Bashir Ahmad Profile Picture
    Bashir Ahmad 5,248 on at
    RE: AX2012 R3 Bank Statement Import - Transaction Code Mapping form

    This is the New feature of AX 2012:

    Use this form to create a relation between the bank transaction type and the transaction code in bank statements. This relation is also used during the reconciliation process

    Bank Account Statement Import and advanced reconciliation

       A much-needed functionality. AX 2012 now allows importing electronic bank statements and then performing advanced reconciliations.

       To be able to use the back statement import and reconciliation functionality, you will need a series of one time configurations. Below are the high level steps to do all required configurations .

       The first step is to configure the setup required for the electronic bank statement import which includes the parameters, bank statement format, transaction code mapping and bank reconciliation matching rules etc.

    The next step is to set up the required AIF inbound ports(Services) and import formats.

    After all the setups are done, finally we can import the electronic bank statements in required formats and perform advanced reconciliation.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans