Does anyone know how to post journal entries from Microsoft Excel. I use GP2015 and have tried following the online instructions and cannot make this work.
*This post is locked for comments
Thank you, DeanneR and all,
I have started copying and pasting from Excel. This is a major productivity improvement for us.
Take care and be safe.
– you need 4 columns – the description column doesn’t need anything but it does need to be there.
If you are still using Excel spreadsheets for accounting, this new feature might be able to save you some time. Starting in Dynamics GP 2013 R2, we now have the ability to copy data from our Excel spreadsheet and past it into the GL Transaction Entry window.
Tip: this copy and paste will also work from Notepad to Dynamics GP
1. First you need a 4 column Excel Spreadsheet, with exactly these 4 columns in this order. Description (not required for all rows), Account, Debit, Credit
2. Select and copy the data under the column headers. In this example above, the grey area. You can use CTRL + V or Edit / Copy in your Excel window.
3. Then move over to Dynamics GP. Place your cursor in the account number field of the General Ledger (GL) Transaction entry window. Click on the button at the top – Excel Paste
4. Next, you will see the data pasted in from Excel. Save or post as needed or if you get an error, a validation error report is printed. Fix the spreadsheet and try again.
Give it a try; however, there some considerations worth noting:
• If the Debit amount on a row is not zero, the Credit Amount on the same row must be zero (and vice versa).
• The original file does NOT need to be Excel - it can be a tab-delimited text file like in Notepad, or even a web page, as long as it has the correct columns.
• An unbalanced journal can be pasted into the Transaction Entry window.
• Dynamics GP will recognize formulas in the Debit and Credit amounts. They are recognized as static values.
• As with every distribution window, the full account number is only recognized. Account segments can't be in separate columns, but using the =CONCATENATE function can be used to combine the segments.
• Unit accounts and amounts can be included.
• The Excel Paste functionality only works with new journal entries. It is not possible to paste to a saved journal entry.
If the report destination window pops up that means it is trying to print an exception report because there is an issue with the data that was copied. I'm not sure why it wouldn't let you send it to screen. Can you send it to file and then open the file it creates?
You could also try watching this youtube video. It shows step by step what to do. www.youtube.com/watch
Thanks, Matt, clicking on the Paste button opens up dialog box titled Report Destination. It will not allow a screen print and the box ask for preferences on report G: Transaction Validation Report. The box has options to display the report on the screen, print, or in a file. It is similar to the report screens to export data to Excel.
Clicking on Paste from the ribbon does not access any action or typical paste functionality.
Ok, I see it now. Once you got the cells copied in Excel, you'll click the Paste button (in between Copy and View) up on the Ribbon up top.
Here's the file in RTF.
Hello, Matt, here's my 2nd attempt.
It didn't come through. You have to click on the Use Rich Formatting option underneath the text box and then add media and browse out to a saved file.
Here's the screenshot.
Can you take a screenshot of your Transaction Entry screen? There should be a Paste button if you are on GP 2015.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (