Using Microsoft Dynamics GP and Excel are a powerful combination for any finance team. Many of our clients are asking about the steps to copy and paste General Ledger transactions from Excel into Dynamics GP. Here is the process in four simple steps.
- Setup your excel sheet with the four columns below in the exact order as they appear below.
- Account Description –required column. This will be your 3rd line reference. .
- Account – General Ledger account number.
- Debit – transaction debit amount for the corresponding account.
- Credit – transaction credit amount for the corresponding account.
- Alias –can be added if Analytical Accounting is used but it is not a required column.
- Copy the data from the Excel spreadsheet. Ensure that you don’t copy the column headings, otherwise, you will receive an error when you paste the journal entries into the Financial Transaction Entry window. (CTRL+C)
- Open the Financial Transaction Entry window by going to Financial >> Transaction >> General and you must enter the following:
- Transaction type (standard or reversing)
- Transaction date
- Source Document code
- Reference
- Currency ID
- Once the above are filled in. Go to PASTE and it will accept your entry. There is a validation report that is run. You cannot have any Trx lines with zero in both the debit and credit. It will reject these. Make your corrections to your sheet. Re-copy and it will paste.
Troubleshooting
If you get a “Not Privileged” to run this report go to the following in Security.
Mark off the ‘GL Transaction Past Validation Report’
And you should be able to run the report. Remember that if the user is logged in, they must log out and back in to have access to this report.
If you are interested in Dynamics GP training or support contact 860-485-0910 x4 or sales@calszone.com
Get more Dynamics GP Tips and Tricks www.calszone.com/tips
By Susan M. Conrod, Senior Implementation Consultant, CAL Business Solutions, www.calszone.com
