Summary

Learn about the process of exporting a general ledger file from Microsoft Dynamics GP.

Notes

Depending on your version of Microsoft Dynamics 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 GP: Transform the general ledger