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) / Import XML Bank Statem...
Microsoft Dynamics AX (Archived)

Import XML Bank Statement to AX 2012

(0) ShareShare
ReportReport
Posted on by Styrlitz 7

Greetings

I am looking for some advice about how can I import bank statements that are coming in XML format to AX 2012? I already learned how to parse it in X++, but now i am stuck at the question "where should I put those fields?". Maybe there is easier way of importing those files?

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    The following whitepaper provides you with some explanations

    elrincondynamics.azurewebsites.net/.../684-Electronicbanking_advancedbankreconciliationax2012.pdf

    Best regards,

    Ludwig

  • Styrlitz Profile Picture
    Styrlitz 7 on at

    That is quite not what i am looking for, and that is why i should explain more of a XML file structure i recieve.

    <GetBankAccountStatementResponse> (1..1)

    <Statement> (0..1) (In case of error this node can not be in file. Here is everything about statement, Statement type, Period description, Account Number etc)

    <Transtactions> (0..1) (If there are no transactions this node can not be in file)

    <Transaction> (1..N) (And here is everything about transactions, DocNo, DocDate, ClientBank, RespondentBankName etc

    And import of this bank statement should be automatic, only by pressing Import from Client-Bank.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    I see.

    Well, the standard application only supports the import of bank statements via the advanced bank reconciliation tool.

    If this does not work for you then you can either make use of 3rd party ISV solutions or develop this yourself. 3rd party solutions might be faster and possibly cheaper because after the import of the statement you have to think how to identify, match and reconcile the individual transactions.

    Best regards,

    Ludwig

  • Deepak Agarwal Profile Picture
    Deepak Agarwal 8,602 on at

    Standard application only support some of the standard bank statement format i.e. BACS or MT940 via advance bank reconciliation. If this is not fit for your requirement than surly you need to look for other options.

    Also, just wanted to check. Ideally most of banks follows same format for statement, how you are getting a different bank statement format.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Styrlitz,

    Is there anything else open / not answered that we can help you with here in this forum?

    Best regards,

    Ludwig

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