Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

IM for Sales Invoice Processing

(0) ShareShare
ReportReport
Posted on by 10

Help!!  I need to know the trick in Integration Manager to get more than 1 line item on an invoice.  I can get all Sales Invoices to process on through IM that have 1 line, but I do not know how to get multiple line items on the invoice to go though IM..  I currently have a Header File and a Data File (2 Sources), and have tried everything.

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    RE: IM for Sales Invoice Processing

    IM has plenty of sample maps to integrate data, either by using a single file or a header & detail file..

    It's all about getting the grouping setup correctly and the relationship.

    This recorded webinar from Charles Allen will show you the trick : https://www.youtube.com/watch?v=fYo8Yb-8C9o

  • Suggested answer
    Derek Albaugh Profile Picture
    on at
    RE: IM for Sales Invoice Processing

    As mentioned, I would recommend looking at the 'Sales Order Processing' sample integration for information on setting up the header, items, as well as distributions and commissions, if applicable.

    Let us know if you have any questions.

    Thanks

  • DinB Profile Picture
    3,891 on at
    RE: IM for Sales Invoice Processing

    Try checking "Query Relationship" and setup Source file relationships similar to the sample IM. (SOP Header to SOP Items)

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Product updates

Dynamics 365 release plans