Armanino Blog
Article

Dynamics GP Excel Copy Paste Error in 2013 R2

August 28, 2014

We recently received a call from a customer with issues using Dynamics GP Excel copy paste function. She said she did not have access to the Excel Copy Paste function in GP2013 R2. When she attempted to paste data, she received this error message: Not privileged to run this report.

Upon further review, we found that the feature is available for anyone who has access to the Transaction Entry window in GP. However, if any errors are detected in the data the user is attempting to paste, the GL Transaction Paste Validation Report will need to print.

This report is new to GP2013 R2 and is made specifically for the Excel Copy Paste feature. The report will display the data that needs to be revised in the Excel spreadsheet. If the data is correct, the GL Transaction Paste Validation Report will not appear, and the data will be pasted into the Transaction Entry window.

To resolve the error, we navigated to the Security Task Setup and added "GL Transaction Paste Validation Report" to the TRX_FIN_001* task.

Copy Paste Task ID

Learn more about Dynamics GP for more tips and tricks like this one to remedy this Dynamics GP copy paste function error.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
A Deep Dive of Business Valuation Discounts
Webinar
Get expert tips to better estate plans for your clients.

December 5, 2024 | 10:00 AM - 11:00 AM PT
Building Future-Proof Foundations: Insights for Family Offices and Corporate Foundation Managers
Webinar
Gain the tools to navigate the complexities of foundation management.

December 4, 2024 | 10:00 AM - 11:00 AM PT
Year-End Tax Strategies for Businesses
Webinar
Adapting to the New Tax Landscape in 2025

December 3, 2024 | 11:00 AM - 12:00 PM PT