Importing JE from Excel

• 05-01-2008 2:03 PM

  TS Joined on 05-01-2008 Posts 2	Importing JE from Excel Reply Contact Is it possible to import journal entries that were written in Excel into Dynamics GP? If so, how? Thanks in advance for any help!

• 05-01-2008 2:10 PM

  In reply to

  TS Joined on 05-01-2008 Posts 2	Re: Importing JE from Excel Reply Contact Would Integration Manager do the trick?

• 05-02-2008 2:18 PM

  In reply to

  Bryan - Dynamics GP Consultant Joined on 10-24-2007 Posts 2

  Re: Importing JE from Excel Reply Contact Yes, integration manager will work.  Depending on the version, there used to be a tool called "Integration Assistant for Excel" which worked as well.  The easiest by far is to create a template in Excel, inside a named range, then build a "Simple ODBC Connection" in IM pulling from that named range.  That way, when you update the info in the named range, the source fill will update and all you then have to do is run the integration.

• 05-06-2008 9:17 PM

  In reply to

  brian connell Joined on 05-07-2008 Posts 5	Re: Importing JE from Excel Reply Contact I saw a third party tool at convergence that looks simple and is cost effective. Infinia ? i think it was. I havent used it yet, but it looks slick.

• 07-31-2008 12:14 PM

  In reply to

  I Run GP Joined on 10-09-2007 Posts 1	Re: Importing JE from Excel Reply Contact Infinia works well; very easy to use