web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Data import from Concur Standard to Dynamics GP 10.0

(0) ShareShare
ReportReport
Posted on by 105

I am unable to import expense data from Concur standard to dynamics using txt or csv files. Can someone advise on how to set this up?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    on at

    Thomas,

    This should get you started:

    community.dynamics.com/.../107394.aspx

    community.dynamics.com/.../microsoft-dynamics-gp-and-the-concur-import.aspx

    Cheers!

  • djthomas13 Profile Picture
    105 on at

    Hi Sanjay,

    Thanks for the response. Is there documentation on how to set this up using Integration Manager? I'm a beginner in regards to my knowledge of dynamics... As a little background information, recently we had to upgrade our concur system. Our previous system provided us with four download files: Batch123.IBC, Batch123_IGL.imp, Batch1234.CHK,  and Batch1234_CGL.imp. However, our new system only provides us with txt or csv download files. My issue is that I do not know where to begin to change the file import type. Any advise would be greatly appreciated!

  • Community Member Profile Picture
    on at

    First you will need to contact Concur and request the "Standard Extract File Definition for Microsoft Dynamics GP" from them.

    community.dynamics.com/.../61237.aspx

    Cheers!

    Sanjay

  • djthomas13 Profile Picture
    105 on at

    Thanks Sanjay! I was able to get Concur to put the import file in the proper GL-format. However, the file import is still not working. Do you think it's because we are trying to import a text file? The new concur system only provides download files in text and csv format. Please advise?

  • Community Member Profile Picture
    on at

    Thomas,

    Now I understand you are able get the download from concur in proper GL format. Yay!!!. Next step is importing into GP.  What tool are you using to import the down load file into GP ?  Can  you be more specific as to Concur Expense Integrator Tool (not available for GP 2013), integration manager or e connect etc.....

    Cheers!

    Sanjay

  • djthomas13 Profile Picture
    105 on at

    We are using eExpense Integrator for ms Dynamics GP 9.0. Version 10.0.774

  • djthomas13 Profile Picture
    105 on at

    Hi Sanjay, any advice on this?

  • Community Member Profile Picture
    on at

    Hello

    I hope you are still available to help with this same topic. I received the 77 column file from Concur but I cannot figure out how to make it the format required by Concur Expense Integrator, the .igl or .cgl

    I keep getting the run around from Concur. They are telling me I have to convert the file from csv or xls to a igl or cgl, but I do not know how to. I hope you can help

    Thank you!

    CD

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans