US - Massachusetts - Boston

 View Only

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

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

    Posted May 12, 2020 07:50 AM
    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
    ------------------------------


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