web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Does Dynamics GP 2015 ...
Microsoft Dynamics GP (Archived)

Does Dynamics GP 2015 have any Excel import support?

(0) ShareShare
ReportReport
Posted on by Community Member

I have not yet received the 2015 update, but will in a week. Is there any support for importing excel documents with payroll information into Dynamics to be stored in the vendor database?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at

    I don't think such feature exist in GP 2015 so far. Follow this link to see what you'll get with 2015.

    www.calszone.com/documents/microsoft-dynamics-gp-whats-new.pdf

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    First, spauldeagle, love the name!

    I am not sure exactly what you're trying to accomplish, but you may want to take a look at TitaniumGP's Copy / Paste feature for Excel.

  • Suggested answer
    coquisalsa Profile Picture
    coquisalsa 2,725 on at

    I have just checked GP 2015 R2 and couldn't find any Excel import tool for payroll.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at

    TitaniumGP Copy and Paste is interesting tool, but unfortunately it doesn't support Payroll neither vendors.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,852 Moderator on at

    Are you licensed for Integration Manager? If so you can import your employees as vendors.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at

    Jorge,

    I wanted to encourage spauldeagle to investigate whether or not TitaniumGP was right for their needs, as the original post seems to indicate importing payroll data to the vendor database (I am wondering if this is for employee reimbursement, but it seems unclear). It could just be a typo.

    According to TitaniumGP's documentation, pasting from Excel to GP is supported for Vendor Masters, Vendor Addresses, Payables Transactions, Manaul Payments and Employee Master Records.

    This is the only tool I am aware of that is in the ballpark for Excel Cut/Paste functionality.   Perhaps it will work, perhaps not. It is also possible, TitaniumGP is working on other integration points.

  • coquisalsa Profile Picture
    coquisalsa 2,725 on at

    Definitely you are right Harry. Choosing the right tool(s) for the job depends on the user's needs.

    Here there is some more info regarding to TitaniumGP

    http://www.titaniumgp.com/features/copy-paste/

    2015_2D00_07_2D00_13_5F00_15_2D00_05_2D00_532.jpg

  • michelle brayton Profile Picture
    michelle brayton 95 on at

    Another option that you may want to consider is Smartconnect.  They have an excel add-in that allows pushing all kinds of documents from Excel into GP.  You create the integration map in Smartconnect and then create an Excel template for the push document.  Entries are loaded into Excel and via the add-in pushed through web services into GP.  I have a customer who uses it for the GL entries (they are on GP2010 and use Nolan Intercompany).  I created a custom econnect node that allows them to include their intercompany entries on their spreadsheet.  It has saved them 20 hours per month in their month end close process. 

  • Community Member Profile Picture
    Community Member on at

    Hi,

    This feature is not yet available in GP 2015. You can go through following PDFs for full description on it.

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at

    There is no such option available in GP 2015. Only Excel paste available in GL Transaction Entry window since the version GP 2013 R2.

    If you have licence for Integration Manager, you can use IM to import the data from Excel to GP.

    Hope this helps!!!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans