Proper file format for Concur Expense Integrator

(0) Share

Report

Posted on by Warren May

455

We're implementing Concur and running GP 2010. We have also installed and configured the Concur Expense Integrator for GP and I'm having some trouble determining the proper file format to use for the import. Concur is giving us their standard SAE file, which is 256 columns, but my understanding is that the Concur Expense Integrator is looking for a different file (77 columns, I believe).

Does anyone know the correct file format to use with Concur Expense Integrator module?

Thanks.

-Warren

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Community Member on at

Like (0)

Report

Hi Warren, did you get to the bottom of this query?

How are you finding the Concur Expense Integrator?

Ian.

Was this reply helpful? Yes No
Greg Willson 250 on at

Like (0)

Report

The SAE file (256 colums) is not the correct format. You will need to contact Concur and request the "Standard Extract File Definition for Microsoft Dynamics GP" from them. Then you will ge the 77 column .IGL or .CGL file that the Concur Expense Integrator tool for Dynamics GP is expecting.

Regards,

Greg Willson

Was this reply helpful? Yes No
Caprice Murray on at

Like (0)

Report

Thanks Greg! Appreciate your help with this, as well as all of your emailed replies over the last few days.

Warren, thanks for taking my call about this too. Please do post a status update when you know more, abd I'll do the same.

Regards,

Caprice

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Greg

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 it but I do not know how to. I hope you can help

Thank you!

CD

Was this reply helpful? Yes No
Habeeb Khan on at

Like (0)

Report

Hello CD,

I know that I'm reacting on a very old post but, did you manage to configure it successfully? If yes then could you please share with me the steps as I want to configure it for GP 2015?

Thank you,

HK

Was this reply helpful? Yes No
kj_henkelman on at

Like (0)

Report

Hi Celia, I understand this thread is from YEARS ago, but I have been trying to get the 77-column file from Concur and they are NOT cooperating. Do you happen to still have this file, and if so, would you be willing to provide it to me?

Was this reply helpful? Yes No
Suggested answer

MG-16101311-0 26,225 on at

Like (1)

Report

Warren,

You are correct! The file format required by the Integrator is a 77-columns file. Unfortunately, it's very hard to find someone at Concur who knows anything about this file if you need support. Please PM with your email and I will send all the info I have on the file format and the mappings for GP.

Was this reply helpful? Yes No