Open Forum

 View Only
  • 1.  Pasting from Excel into GP

    Posted Jan 20, 2023 03:45 PM
    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
    ------------------------------


  • 2.  RE: Pasting from Excel into GP

    GOLD CONTRIBUTOR
    Posted Jan 20, 2023 03:57 PM

    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
    ------------------------------



  • 3.  RE: Pasting from Excel into GP

    Posted Jan 20, 2023 05:36 PM
      |   view attached

    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

     




    Attachment(s)

    eml
    GP error.eml   128 KB 1 version


  • 4.  RE: Pasting from Excel into GP

    GOLD CONTRIBUTOR
    Posted Jan 21, 2023 05:55 PM
    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
    ------------------------------



  • 5.  RE: Pasting from Excel into GP

    Posted Feb 01, 2023 10:00 AM

    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

     






  • 6.  RE: Pasting from Excel into GP

    SILVER CONTRIBUTOR
    Posted Jan 23, 2023 08:45 AM
    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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role