Summary

Learn about the process of exporting a general ledger file from Microsoft Dynamics Great Plains (GP).

Notes

Depending on your version of Microsoft Dynamics Great Plains (GP), the layout may be different but the reports should be in the same location as the screenshots below.

Extract data

1. From the Microsoft Dynamics GP menu, select Smart List.
   
   
2. Navigate to Financial → Account Transactions and select the first sub-group marked with the asterisk (*).
   
   
3. Add additional columns if required.
   
   
4. Select the date range.
   
   
5. When you have the results, Export to Excel.
   
   
6. The exported file should look like this:

Source: https://www.youtube.com/watch?v=SAKJYlA2iX0

Next step: Microsoft Dynamics Great Plain (GP): Transform the general ledger