Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

how do I copy and paste a journal entry from excel in gp 2015?

(0) ShareShare
ReportReport
Posted on by

I am trying to copy and paste a journal entry from excel in GP 2015 but I am unable to do so. Most of the time the paste button is greyed out. Other times it only gives me a validation report with nothing pasted in the Journal window. Other times it gives me an error not privileged to run this report error. Does any one know a solution? I tried to look on line for a solution but when I tried those solutions it doesn't work. Please help.

Thanks, 

*This post is locked for comments

  • GuruDofGP Profile Picture
    248 on at
    RE: how do I copy and paste a journal entry from excel in gp 2015?

    I unblocked the properties so GP launches again.  I can now change the company ID manually, but the user is looking to not have to do this with the huge, multi-line journal entries they're looking to copy and paste.  Any other suggestions?  Thank you.

  • JamesLyn Profile Picture
    360 on at
    RE: how do I copy and paste a journal entry from excel in gp 2015?

    Another user noted you have to perform the following to unblock the add-in:

    dynamicsgpland.blogspot.ca/.../dynamics-gp-crashes-after-installing.html

    Other users reported copying it to a USB stick and pasting it back may also remove the security block.

    In terms of not being able to change the company ID, that might be a user setup issue within GP. Can you manually change the company ID?

    James

  • GuruDofGP Profile Picture
    248 on at
    RE: how do I copy and paste a journal entry from excel in gp 2015?

    The add-in is preventing the GP program/application to launch when placed in the Dynamics folder, Add in folder location.  Is there another solution to perform the copy/paste intercompany journal entry successfully in MS Dynamics GP2013R, GP2015, or GP2016?  Thank you for your assistance.

  • GuruDofGP Profile Picture
    248 on at
    RE: how do I copy and paste a journal entry from excel in gp 2015?

    I downloaded this dll add in file, and am still not able to perform the intercompany general journal entry as it says the company ID is not allowed to be changed, telling me to delete the lines and enter again. :(

  • Suggested answer
    JamesLyn Profile Picture
    360 on at
    RE: how do I copy and paste a journal entry from excel in gp 2015?

    If you are trying to paste intercompany journal entries, the Paste button will remain greyed out as it is not supported with the built-in feature. I also do not remember off the top of my head if multi-currency is fully supported either. Simply put, only non-intercompany Manual Journal Entries are supported for Paste.

    If you want to paste entries for intercompany, multicurrency, AP distributions or Sales distributions, I created a simple add-in that adds the feature into GP:

    jamesdlyn.wordpress.com/.../gp-paste

    James

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: how do I copy and paste a journal entry from excel in gp 2015?

    Check this out GP 2013 R2 – Copy paste GL journals from Excel “with Analytical Accounting Details”

    Your feedback is highly appreciated,

  • Mick Egan Profile Picture
    3,561 on at
    RE: how do I copy and paste a journal entry from excel in gp 2015?

    Ensure you only select the 4 Columns in Excel, and the Lines of data to Paste.

    Check focus is in the First Account Number field.

    Mick

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans