web

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

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
Copy link

Link copied!

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

News and Announcements

Sign Up for Ask a Community Pro Today!

Introducing our New Video Series: Community Spotlight

Quick Links

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

#1

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

#1

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

#3

Abhilash Warrier 391 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans