Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
We have GP 2015 R2 installed. We can use the Copy and Paste from Excel to GL but only with the functional currency. When another currency is selected, the Paste button is disabled.
Does anyone know about this issue? Is there a way to make it work? Thanks.
is the copy paste functionality still unavailable for the web client?
Hi , Everybody .
I have GP 2013 R2 installed. I can use the Copy and Paste from Excel to GL from original Dynamics.set and Dex.ini ( Original Folder of GP2013R2 ) , but when i use another Dynamics.set and another Dex.ini The Copy and Paste doesn't work.
I checked the file Dex.ini and there is a line to use the old COM Object Model . Any other settings I Should check ?
I am not aware of any known issues around this unless you are attempting to do this in web client. One thing that you could try is doing a repair on 'Open XML SDK 2.0' in your add/remove programs. If this is not in place, or is damaged, that could stop the function from occurring.
Also you could check to see if there are any issues with the clipboard, or copying and pasting into GP in general.
Otherwise you may want to open a support case if the issue is still lingering after that point for more in depth troubleshooting.
I hope this helps!
Sr. Support Engineer
Microsoft Dynamics GP
Business Applications communities