Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Use one file for heade...
Microsoft Dynamics GP (Archived)

Use one file for header and detail information for Payables Transaction in Integration Manager?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello,

I have created an Integration to import vendor invoices into GP via Integration Manager.  In my current integration I have two text files as my sources- one file for the invoice header, and one for the invoice distributions.  This solution works great, but it could be simplified even further.

Is there a way to use one file that contains both header and detail information?  I would like this one file to be my single source file.

Can anyone advise if this is possible?  I have tried different grouping options, but I cant quite get it to work.

Thanks

Joe

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Use one file for header and detail information for Payables Transaction in Integration Manager?

    Hi Sarah,

    Sorry for the delay... I was on vacation :) .  I create one file, and then make a copy of that file.  The original file is used as the header, while the copy is used as the details.  The files have these columns:

    Invoice Date

    Invoice

    PO No

    PurAmount

    Vendor ID

    Account No

    DistAmount

    In the header file I group these columns:

    Invoice Date

    Invoice

    PO No

    PurAmount

    Vendor ID

    The header file now ignores the Account No and Dist Amounts

    I do not have any grouping going on in the details file.

    I then make sure that my mappings for distributions are coming from the details file.

    I hope this helps.

    Joe

  • Sarah Geffert Profile Picture
    Sarah Geffert 230 on at
    Re: Use one file for header and detail information for Payables Transaction in Integration Manager?

    Joe,

    How have you setup your group by's?  I am trying to do the same thing but it is only recongnizing the first distribution for each invoice.  I am sure it is an issue with how I have it grouped but can't seem to figure out how to fix it.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Use one file for header and detail information for Payables Transaction in Integration Manager?

    Thanks Melissa - I found a solution similar to the one you provided.  I took one file and made a copy of it.  Then I took the 'first' file made it my header file and did the necessary grouping within IM.  I took the 'second' file and used that for the distributions.

    My users now only have to create one file, copy it and that is all.  It is a easy solution for the end users.

  • Verified answer
    Melissa Sandrovich Profile Picture
    Melissa Sandrovich on at
    Re: Use one file for header and detail information for Payables Transaction in Integration Manager?

    You would need to have the account type, account and amount in this file if you are using one source file.  You also need to have 2 sources (pointed at the same file), one for the header and one for the distributions.  IM should have a sample one created that you can look at for guidance.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    Re: Use one file for header and detail information for Payables Transaction in Integration Manager?

    You could use only one source file if you are defaulting the number and account type. You then would need to create some group bys on the integration. Is there a reason you don't simply want to just use 2 source files?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Use one file for header and detail information for Payables Transaction in Integration Manager?

    Hi Mike,

    Yes, below is an example file I am trying to use.  This is one invoice with two distribution lines.  

    If I only group the columns for the header (VendorID, DocDate, DocNo, DocAmt ) I am unable to use the last two columns when mapping my distribution fields (they don't appear when I preview my source file either).

    If I group all the columns, I end up with two different transactions being imported into GP, with one line of distribution each.

    Any ideas?

    Tks!

    VendorID DocDate DocNo DocAmt   Acct            DistAmt

    STAPLES01 6/25/12       123456 25        26216021020 25

    STAPLES01 6/25/12       123456 25        26218021020 -25

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at
    Re: Use one file for header and detail information for Payables Transaction in Integration Manager?

    Joe,

    Within the file, do you have any logical way to create a valid grouping, possibly by Vendor ID and somekind of Document Number or anything else that will designate the multiple distribution lines as tied to a single transaction to be imported in the system?

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans