In order for the user to take advantage of the new Copy and Paste from Excel functionality, Open XML SDK 2.0 needs to be in place. By default, this is installed with GP 2013, so all users should have it. Open XML SDK 2.0 was introduced in GP 2013 because it was much more performant than the old COM Object Model. However, some users still prefer to use the old method from GP 2010 in order to do imports for things like budgets from excel that have calculated cells.
I recently ran into an instance where the user was updating to GP 2013 R2. When they tried to take advantage of the new Copy and Paste from Excel functionality in the GL Transaction Entry Window, nothing happened in GP. No reports or errors showed up like you would expect if the user had invalid or no information selected to be copied.
The reason for this issue was a setting that they had altered/added in the DEX.ini in order to use the old COM Object Model:
‘UseCOMForExcelExport = TRUE’
With this setting in place, they will not be able to use the Copy and Paste to Excel Functionality because it doesn’t allow GP to use Open XML SKD 2.0 which it needs in order to Paste the information from Excel to the Journal Entry. You can easily disable this setting so that you can use the Copy and Paste from Excel in GP by changing the line in the DEX.ini to ‘UseCOMForExcelExport = FALSE’, (If GP is open, make sure to close and re-launch GP). If for some reason a user would need to toggle between both the old COM object Model and Open XML SDK often, you could also create two launch files pointing each pointing at a different DEX.ini file.
I am excited about this new feature, and I hope the information above is helpful to you. For more information on new features in GP 2013 R2 Financials please visit the link to our video below.
Will that fix the web client copy/past issue?
Unfortunately this will not fix the Web Client issue with copy/paste to Excel in GP. That is a separate issue that is written up to be fixed by development at the moment. (Quality Issue TFS 74799)
Sr. Support Engineer
Microsoft Dynamics GP
Hi, I am having issues with this - I set up a template, copied and pasted the 2 line example for a demo I was prepping for and it worked! How awesome! But then, during the demo, no matter what I did the entry would not paste. I am now getting a "GL Transaction Paste Validation Report" that tells me the first account number ("Line 1") doesn't exist when in fact, it does. It also looks like I'm trying to paste $0 debits and credits, which isn't true either.
It's like something else is stuck in the clipboard, and I've cleared that a number of times.
Thanks in advance,
FYI I figured out my DUMB problem! It would help if I didn't include the headers!!!! After I only copied the line items, my copy and paste was successful. So, lesson learned - don't include the headers :)