Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Import Credit Card Statement

Posted on by 660

Dear,

Can someone provide me with the sample file for import of a credit card statement in AX 2012. 

Can someone guide me with the process to do the same?

Can I upload a .csv file for a credit card statement in AX 2012.

*This post is locked for comments

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Import Credit Card Statement

    Hello Binit Shah,

    As far as I remember, the required structure resembles the columns that you can see in the pop up window that opens when you try entering a travel expense in the Enterprise Portal. The best option is to ask a developer for some help with this to be sure that the format is ok. In addition, please have a look at the following whitepaper (requires Login) that provides you some additional information on credit card imports for the travel and expense module view.officeapps.live.com/.../view.aspx

    Best regards,

    Ludwig

  • binitshah Profile Picture
    binitshah 660 on at
    RE: Import Credit Card Statement

    I need the format in which I should ask the client for the data? Can I have a sample file?

  • binitshah Profile Picture
    binitshah 660 on at
    RE: Import Credit Card Statement

    Yes the standard travel and expense module does have a standard import feature but i just require a sample file for import so that i can test whether the functionality is working as required

    We are working with multiple credit card providers, mainly AMEX.

  • Suggested answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,794 User Group Leader on at
    RE: Import Credit Card Statement

    Hi Binit,

    Have a look on this CodePlex thread dynamicsax2012csv.codeplex.com it gives you complete idea how can you import credit card statement from CSV file. There is a youtube video in there so watch it too.

    There is an out of the box service which can be used to import credit card statements (XML formatted) into AX. This link provides you more details how can you transform CSV file into correct XML format and push data into AX. blogs.msdn.microsoft.com/.../importing-credit-card-statements-into-microsoft-dynamics-ax-2012-using-aif-and-transformation-library

    The other option is to write your own classes to read data from CSV file and insert data into following tables;

    TrvPBSMaindata

    TrvEmpPaymethod

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Import Credit Card Statement

    Hi Binit Shah,

    The credit card statement that you want to import is this for travel expenses or do you want to import it into a journal?

    The travel and expense module has a standard import feature for specific credit card providers but not for all.

    What is the credit card provider you work with?

    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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans