Skip to main content

Notifications

Announcements

Community Forum Filters
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum (Archive) / Financials Trial Balance
Microsoft Dynamics GP forum (Archive)
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

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