web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Bashir Ahmad Profile Picture
    Bashir Ahmad 5,248 on at

    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.

  • AliC420 Profile Picture
    AliC420 40 on at

    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?

  • Verified answer
    AliC420 Profile Picture
    AliC420 40 on at

    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/

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans