Microsoft Dynamics Blog

Welcome to Armanino’s Microsoft Dynamics Blog, where you’ll find information on topics across Microsoft Dynamics 365 ERP and CRM, Dynamics GP, Power BI, PowerApps, Flow and more. Use these tips, tricks and insights to get the most out of your applications! Want these articles delivered straight to your inbox? Subscribe to our newsletter below.

Tuesday, August 19, 2014

Copy from Excel into Dynamics GP General Journal Transaction

Posted by Steve Chapman

GP 2013 R2 includes new functionality that allows you to copy and paste information from Excel into the Dynamics GP general journal transaction entry screen. It’s really very easy to use. Just get the information into this simple format: Description – Account – Debit – Credit.

Here’s an example:

Copy from Excel into Dynamics GP General Journal Transaction

Select the data you want and copy it.

Then go to the general journal transaction entry screen and click on “Paste.” The copied information will populate the screen.

Copy from Excel into Dynamics GP General Journal Transaction

Here’s a quick video that shows the process in action:

Discover more insider tips and tricks throughout the Armanino Dynamics blog and visit our Microsoft Dynamics video channel for more how-to videos and customer testimonials.

« | »