Microsoft Dynamics GP and Excel are a match made to help make your finance team succeed. Several of our clients have asked how exactly you copy and paste General Ledger transactions from Excel to Dynamics GP. Being experts in Dynamics GP we know some of the tricks of the trade for making processes easier. Here is the process in as little as one, two, three, four!
1.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.
2. 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)
3. 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
4. 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 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.
For more great Microsoft Dynamics GP tips and tricks visit www.calszone.com/tips
If you are a Dynamics GP user and interested in CAL for GP support, contact us to discuss at 860-485-0910 x4 or sales@calszone.com
By CAL Business Solutions Inc., Connecticut Acumatica & Microsoft Dynamics GP / 365 BC Partner, www.calszone.com
