You’re offline. This is a read only version of the page.
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 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:
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (