Dynamics GP, Office 365 Guest User Dynamics GP, Office 365 Guest User

How to use Excel Copy/Paste in the Dynamics GP General Ledger

One of the new features of Microsoft Dynamics GP 2013 R2 is the ability to copy information from an Excel Spreadsheet and paste it into a General Ledger entry in GP. For any of you that have used Integration Manager to import General Ledger transactions into GP, you are probably jumping up and down with joy and high-fiving everyone at the office. A process that used to involve preparing your Excel document, saving it as a tab-delimited file, configuring your integration, and then troubleshooting any errors you might receive with your integration has been simplified into preparing an Excel document and simply pasting it into GP. Neat right? The only thing to keep in mind is that your columns have to be ordered in this sequence: Description, Account Number, Debit, and Credit.

Read More

Subscribe to our monthly newsletter

Sign up for the latest news about training, product updates, promotions, resources, and more.