Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Carrie Bishop]

Excel file is set up correctly and pasting into GP was working and not longer does.  After copying from Excel then click paste in GP, error message comes up and will not paste.  What can I check to see why it no longer works?

——————————
Carrie Bishop
Sugar Creek Capital
Saint Louis MO
——————————

[Kerry Hataley]

Hi Carrie – Great name!

First, can you add a screen picture of the error – this will help people solve your problem…

Also, remember to use the new site – https://dynamicscommunities.com/community/groups/dynamicsgp/
This GPUG site get retired in March of 2023…

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Carrie Bishop]

My login information for the old system is not working for the new system.  Do I need to do something different?  Please see the attached email with the screen shots of the error.

 

Thank you,

Carrie Bishop

e: cbishop@SugarCreekCapital.com 
d: 314-561-6809

SUGAR CREEK CAPITAL
17 West Lockwood Avenue 
St. Louis, MO 63119

p: 314-968-2205
f:  314-968-3860

w: SugarCreekCapital.com

 

——————————————-

[Kerry Hataley]

I have asked the powers that be at DCI to look into this and get back to you…

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Carrie Bishop]

Have you by chance been able to figure anything out what how I can get the pasting from Excel to work again?

 

Thank you,

Carrie Bishop

e: cbishop@SugarCreekCapital.com 
d: 314-561-6809

SUGAR CREEK CAPITAL
17 West Lockwood Avenue 
St. Louis, MO 63119

p: 314-968-2205
f:  314-968-3860

w: SugarCreekCapital.com

 

——————————————-

[Vanessa Halacsy]

In my experience, that happens when either there is a blank line in the excel (when you copy and paste, make sure to only select the pertinent lines), or the GL account column was selected first and not the description (you have to have a description column, even if you want the description to be blank) or there is something funny like two lines with the same GL and one’s a debit and one’s a credit.

Basically, you should be able to still do the copy from excel into GP, but comb through the original file and make sure there’s nothing extra or missing in it.

——————————
Vanessa Halacsy
Controller
Wooster Motor Ways, Inc.
Wooster OH
——————————
——————————————-

[Cory Severson]

Up

0

Down

::

Hi Carrie,

I’ve seen this happen before and, in my experience, the removal of XML 2.0 is the cause. The XML 2.0 prerequisite is required to be installed and beings it is an older version of the software, the IT scanners will flag it and sometimes it will get uninstalled. Check out this article. It should help you out.

Nothing happens when using Copy and Paste from Excel to GL – Dynamics GP | Microsoft Learn

Thanks!

Cory Severson

Velosio

learn.microsoft.com

Nothing happens when using Copy and Paste from Excel to GL - Dynamics GP

Nothing happens when using Copy and Paste from Excel to GL in Microsoft Dynamics GP. Provides a resolution.