web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Financials Trial Balance

Finance | Project Operations, Human Resources, ...

Answered

Financials Trial Balance

(1) Share

Report

Report

Posted on by DC-15061554-0

5

How can we find the SQL for the GP trial balance report, we need the same fields with beginning balance, period activity and ending balance?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Judy Microsoft Employee on at

Like (1)

Report

Hi, please locate the stored procedure named "dbo.seeglPrintSRSTrialBalance". Right-click on the stored procedure and select "Modify" to open it in a query window. In the query window, you can view the SQL code for the GP trial balance report.

You may refer to the MS document:

https://learn.microsoft.com/en-us/troubleshoot/dynamics/gp/gl-trial-balance-srs-reports-return-no-data#resolution

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 456 Super User 2025 Season 2

#2

Martin Dráb 429 Most Valuable Professional

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans