Open Forum

Expand all | Collapse all

Errors When Using Copy/Paste From Excel For GL Trx Entry

  • 1.  Errors When Using Copy/Paste From Excel For GL Trx Entry

    Posted 13 days ago
    ​​I'm just curious, but does anyone else have problems with pasting in GL Transaction Entries from Excel when putting more than 1 entry in a batch?  I accidentally ran into a workaround but it isn't really convenient getting it to work.  You have to save the transaction that you have just pasted the entry in to, go back to the Batch Entry screen (with the Expansion Arrow next to the Batch ID), close the GL Transaction Entry that is now behind it and then click the "Print" button to generate the Edit List.  If you don't do this and you simply save the entry and enter in a new entry header and paste in details on that entry, you get an error that damages the whole batch.  Is there some kind of patch for this or script to run?  We are on GP 2016.  Any suggestions would be appreciated!

    Thanks,
    Jeff​​

    ------------------------------
    Jeff Stowe
    IT Application Analyst
    Multiplan, Inc
    Bradenton FL
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Errors When Using Copy/Paste From Excel For GL Trx Entry

    Posted 7 days ago
    I've found that when pasting GL transactions from excel i must have the cursor in the 1st line of the account field, otherwise i get an error.

    ------------------------------
    Laura Holsclaw
    Controller
    Midwest Management, Inc.
    Lexington KY
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Errors When Using Copy/Paste From Excel For GL Trx Entry

    GPUG ALL STAR
    Posted 7 days ago
    Hi @Jeff Stowe

    @Laura Holsclaw is absolutely correct.

    The correct procedure for copy/paste from Excel is to have your data formatted in this EXACT format with no deviation (column headers would be in this order):
    Distribution Reference
    Account Number
    Debit
    Credit

    You cannot deviate from that.  The Distribution Reference above may be getting confused with the Header Reference.  ​​The Header Reference is ABOVE the line items in a JE entry.

    The next is to highlight all of the data (EXCLUDING THE HEADERS)
    Open up a new JE and fill out the header piece (including the header reference or it will error out)
    Go to the first line of the Account Code entry and then click the Excel Paste Button.

    Done in this exact order it should work every time.

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Errors When Using Copy/Paste From Excel For GL Trx Entry

    Posted 6 days ago
    Edited by Michael Stewart 6 days ago
    Jeff, If I understand the problem correctly, you can copy/paste a JE just fine as long as it is only one JE?  I tried to replicate this issue and could not.  I could paste a JE, save in a batch and paste a new one and save and keep doing that with no issues.  Also, I might add that I do not have to place the cursor in any particular place for the copy/paste to work.  I can hit the paste button at any time and it works even if the header info is not yet filled in.  We are on GP 2018 so it might be something they fixed after GP 2016.

    ------------------------------
    Michael Stewart
    VP Finance
    DataVox
    Houston TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


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