Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Importing Accounts Receivable Invoice Information into GP

Posted on by 235

I've gone some Googling; but, have been unable to find the answer.  Is there a way to import invoice information from outside of GP into the GP Sales module?

Our ERP is not integrated with GP.  We are in the process of researching new ERPs that will integrate with our financial system; but, for now, we have to manually re-key all invoices from our manufacturing/shipping system into GP in order to record sales revenue and accounts receivable balances and to be able to apply payments, run agings and statements, etc.  This is very inefficient!   I was hoping there was a way that we could export a file form our manufacturing program and import it into GP Sales, rather than having to re-key all the data. 

Categories:
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: Importing Accounts Receivable Invoice Information into GP

    There is also REST based web services using Service Based Architecture (SBA) or the older SOAP based Web Services which wrap eConnect calls.

    There are also 3rd party tools such as SmartConnect from eOne.

    You can also use GP Power Tools with custom scripts which can be used to import CSV files or via custom SBA web services.

    I already have examples working of Web Service calls to create RM and PM transactions in GP, which can then be posted using Batch Posting Service Toolkit.

    Here are examples importing card data: 

    winthropdc.wordpress.com/.../

    Regards

    David

  • Suggested answer
    Dean Marty Profile Picture
    Dean Marty on at
    RE: Importing Accounts Receivable Invoice Information into GP

    Hi Patti

    GP offers two main tools for integration 

    Integration Manager

    eConnect

    Both are able to import data into GP Sales Order Processing.

    Links to documentation for both are below.

    https://www.microsoft.com/en-us/download/details.aspx?id=36219

    Download Microsoft Dynamics GP 2013 eConnect from Official Microsoft Download Center

    Thanks!

    Dean

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

Product updates

Dynamics 365 release plans