Home › Dynamics GP › Dynamics GP Trial Balance
Dynamics GP · Aug 28, 2016

Dynamics GP Trial Balance

Dynamics GP has a Trial Balance report you can run. To run the report, go to Reports->Financial->Trial Balance:

This will open a window where you will have different options on reports to run:

Select Detailed->Demo and Modify and it will open the window below:

You have the ability to specify which what to include, the year, sorting etc. I have selected Start and End of Fiscal Year as the date range. Select Print from the top navigation and it will open a report like below:

If you select Summary as the report type you will see the summary information. Here I am selecting the date range as the period:

You can also run these reports as SSRS reports.

Go to the GP module, e.g. Financial, and select “Trial Balance Detail”:

Run the report to view the output.

Depending on the report, you may find useful SQL procedures and views that assist in retrieving the data at the database level.

Leave a Reply

Your email address will not be published. Required fields are marked *

Carl de Souza
KEEP LEARNING. KEEP BUILDING.

Explore AI, agents & Microsoft technology.

I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.