Skip to main content

Notifications

Announcements

No record found.

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:

Helpful resources

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 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,155 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans