Questions? We have answers.

Microsoft Dynamics NAV: Export the general ledger

  • Updated

Summary

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


Notes


Extract data

  1. From the Departments tab, select General Ledger under Financial Management.image__93_.png

  2. Scroll to the bottom of the list and select General Ledger Entries, located in the History section under Archives.  image__94_.png

  3. The General Ledger Entries contain opening balances that need to be filtered out.
  4. Click General Ledger Entries to open the context menu, and click Advanced Filter.image__95_.png

  5. In the column menu, select Document No and type <>START in the text field.image__96_.png

  6. Press Enter and your results will now exclude opening entries.
  7. There are some other columns not in the default column set but are useful to MindBridge analysis. To see more columns right-click on any column header to view the context menu and select Choose Columns...image__97_.png

  8. The Customize General Ledger Entries window will open, and from here you will choose additional columns. Be sure to include the columns labeled Required in the screenshot below.
  9. Columns labeled Optional is not required but can bring additional insights to the analysis. Columns labeled Additional aren't used in MindBridge but will be included in the Data Table for reference.image__98_.png

  10. Use the Microsoft Excel button in the Ribbon's Send To tab and follow the dialog boxes. Be sure to save your results as XLSX. image__99_.png


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Was this article helpful?