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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Integration Manager he...
Microsoft Dynamics GP (Archived)

Integration Manager header and detail single source

(0) ShareShare
ReportReport
Posted on by Rob Klaproth 1,730

I am trying to import a Concur standard expense report as a payables transaction in GP.  The way they are exporting the data out of concur, the first line contains the header and then subsequent lines contain the detail (distributions).

Unfortunately, these lines are different, i.e. header line columns are NOT the same as the detail line columns.  Is there a way to make this work in Integration Manager or will I need to cut and paste the header lines out into a new file?

*This post is locked for comments

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

    1) Are the column count same for header lines and detail lines  ?

    2) Is the a column identifying the line type (header vs detail ) ?

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,784 on at

    If there is something on the lines which identify them as header and detail lines you could set up two sources, using the same source file, and apply filters on the source to only use the header and detail lines as appropriate.

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at

    The header line has only the $ amount of the expense report and no other columns, so the column count wouldn't be the same.  I guess we could add something indicating it's the header, but we're trying to make this an automated process.

    In terms of identifying the difference, column A on the header lines will contain a decimal because it's a dollar amount, but column a on the detail is a date field so maybe I could use the filter on A looking for a . and on b looking for no . ??

  • Community Member Profile Picture
    Community Member on at

    For filtering you will need to define col a  = "H"  or col a ="L"  not like col a contains a decimal.

    For concur you should be looking at connect instead of integration manager.   e-connects allows you to automate the entire process.  Integration manger would require manual intervention.

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans