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 Credit Card Sta...
Microsoft Dynamics AX (Archived)

Import Credit Card Statement

(0) ShareShare
ReportReport
Posted on by binitshah 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

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

    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

  • Suggested answer
    Faisal Fareed Profile Picture
    Faisal Fareed 10,796 User Group Leader on at

    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

  • binitshah Profile Picture
    binitshah 660 on at

    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.

  • binitshah Profile Picture
    binitshah 660 on at

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

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

    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

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