Open Forum

Expand all | Collapse all

General Entries from Excel

  • 1.  General Entries from Excel

    Posted May 11, 2018 12:39 PM
    Its there a tool that connects and upload the General Entry from Excel directly into GP? We have repeated monthly General Entry generated using Excel

    ------------------------------
    Bhavin Mistry
    Northridge Capital LLC
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: General Entries from Excel

    TOP CONTRIBUTOR
    Posted May 11, 2018 03:30 PM
    ​Yes! You can use GP Integration Manager or eOne Smart Connect.

    ------------------------------
    Cecile Dinh
    Microsoft Dynamics GP Administrator
    ARC (Airlines Reporting Corporation)
    Arlington VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: General Entries from Excel

    GPUG ALL STAR
    Posted May 11, 2018 03:31 PM
    Hi @Bhavin Mistry,

    There are several tools that provide this capability.  If you have Integration Manager already, then you should start there.

    If not, let us know, and we can tell you about some other options.​

    ------------------------------
    Frank Heslin
    Financial Systems Administrator
    ExamWorks, Inc.
    Atlanta GA

    GPUG Advisory Committee Member
    Summit Track Leader
    GPUG All Star 2016

    GP2015 R2
    MR CU14
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: General Entries from Excel

    GPUG ALL STAR
    Posted May 11, 2018 07:13 PM
    Hi,
    Don't forget that you can paste from Excel into the General Entry window. If this is just a few entries, or can be turned into one monster entry, copy and paste might be the easiest way to go.
    Leslie

    ------------------------------
    Leslie Vail
    Accounting Systems Consulting, Inc.
    DALLAS TX
    leslievail@earthlink.net 972-814-8550
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: General Entries from Excel

    GPUG ALL STAR
    Posted May 13, 2018 10:34 AM
      |   view attached
    ​Hi @Bhavin Mistry

    If you are on GP 2013R2 and over you can copy and past into the GP General screen directly from Excel as @Leslie Vail mentions.   This copy and paste feature is 100% the easiest method for bringing JE's in from Excel in GP now.  Yes you can still use Integration Manager and or SmartConnect, but if it's in Excel copy and paste is easiest.

    Simply open your General Transaction, enter the header information and then place your cursor in the first line of the entry.  Copy the information in Excel, pop back over to GP and use the Excel Paste button in the command area of the entry screen.

    The entry DOES have to be in a specific format by column:

    I have uploaded this document in Excel if you guys would like it below:​​

    ------------------------------
    Kindest Regards,

    Jo deRuiter
    "That GP Red Head"
    Advanced Credentialed Professional-Dynamics GP
    Member, GPUG GP Credentialing Exam Committee
    Chairman, GPUG Partner Advisory Board
    "......what isn't she up to?"
    Heartland Business Systems, LLC
    Senior Financial Systems Consultant
    Milwaukee, WI
    770-906-4504 (Cell)
    ------------------------------

    Attachment(s)

    Academy - Online Interactive Learning from Experts


  • 6.  RE: General Entries from Excel

    Posted May 13, 2018 04:34 PM
    ​If you are looking for general ledger journals specifically, then I would definitely go with the standard copy paste functionality of Dynamics GP, it may even cover analytical accounting entries when using AA Alias.

    Despite of the fact that Smart Connect is the greatest integration tool ever available for Dynamics GP, but I would use it for a broader scope.


    Your feedback is highly appreciated,
    Best Regards,

    ------------------------------
    Mahmood M. AlSaadi - MVP
    Principal Dynamics ERP Consultant
    SIROCo LLC - (844) 708-0008
    McKinney TX
    m.saadi@sirocollc.com
    http://www.sirocotech.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: General Entries from Excel

    Posted May 14, 2018 11:08 AM
    ​We have GP 2015 R2 and I've found that the Paste function doesn't always work well when you have alpha characters in your account codes.  It may paste all the information, but the debits/credits don't add correctly.

    ------------------------------
    Karen Raybuck
    Wingspan Care Group
    Shaker Heights OH
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: General Entries from Excel

    Posted 29 days ago
    Hi Jo-

    Is there a similar sample excel or directions for the format/order of columns needed to use the copy/paste feature that is now available for Payroll batches as well?

    Sincerely,

    Dianna Clem
    Payroll Specialist
    Houghton College
    Houghton NY

    ------------------------------
    Dianna Clem
    Payroll Specialist
    Houghton College
    Houghton NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: General Entries from Excel

    SILVER CONTRIBUTOR
    Posted 29 days ago
    Hi Dianna, this blog post gives a bit more detail on the paste from Excel feature in Payroll, but here's how the Excel template should look:


    to create a result like:


    Hope that helps!

    ------------------------------
    Sarah Brewster
    Implementation and Support
    ActivReporter by AccountingWare
    Email me! sbrewster@accountingware.com
    Lubbock TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: General Entries from Excel

    Posted 29 days ago
    Sarah- Thank you very much!

    Sincerely,

    Dianna Clem
    Payroll Specialist
    Houghton College
    Houghton NY

    ------------------------------
    Dianna Clem
    Payroll Specialist
    Houghton College
    Houghton NY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 11.  RE: General Entries from Excel

    SILVER CONTRIBUTOR
    Posted May 14, 2018 09:25 AM
    There is also a great tool called Infinia Integrator that is very user friendly but powerful.  It can be used for other modules as well.  You can check it out here:

    http://www.excelintegrator.com/

    ------------------------------
    Tamara DeStefano
    Senior Accountant
    Phigenics, LLC
    Downers Grove IL
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 12.  RE: General Entries from Excel

    SILVER CONTRIBUTOR
    Posted 28 days ago
    We used to use Integration Manager years ago, and it was ok, (better than not having it) but for several years now we've been using Infinia Integrator for GP and all the accountants here LOVE it.  It's SO easy to use.  It works great for an excel file for which you might have a similar recurring journal entry every month, and you can have the Inifinia template right on your worksheet being populated with your new month's data, then copy and paste it into Infinia and upload to GL with the push of a button.  Then you pull up the batch in GP and post it.  It also works well for one-off journal entries, the template is so easy to copy, fill in, upload, then post.  I even use it for simple 2-liners, I find it easier than going into GP to create a general journal entry. You can also use it for a journal entry that needs to cross over more than one period, for example if you are correcting the department code of an expense going back several months.  I highly recommend it and can't begin to tell you how much easier our lives are with it.

    ------------------------------
    Lucy Shows
    director of budgeting and decision support
    Hattiesburg Clinic P.A.
    Hattiesburg MS
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role