Skip to main content

Notifications

Announcements

Power Platform community announcement details, link, and/or description
Community Forum Filters
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum / Financials Trial Balance
Microsoft Dynamics GP forum
Answered

Financials Trial Balance

(1) ShareShare
ReportReport
Posted on by DC-15061554-0 3
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:
Other
  • Verified answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Financials Trial Balance
    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:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Power Platform community announcement details, link, and/or description
Community Forum Filters

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Moderator

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans