I go to Inquiry->Financial->Summary which display summary for each month.
Is there a way to get the SQL query or how do I write a query to do return the same?
*This post is locked for comments
I've just realized that the amount in "Period Balance" is incorrect when I run the query you provided, what shows in "Period Balance" is actually a "Net Change" which matches with the number in Account Summary's "Net Change" value.
then all you have to do in SQL is run a query like this :
SELECT *
FROM [AccountSummary]
WHERE [Account Number] like 'XXX-YYY-%'
AND YEAR = 2017
AND [Period ID] = X
I need to run it for a specific account and month
Hi Jehan,
Try the SQL View called "AccountSummary".. those are default views that Microsoft provides for each GP companies and used by the Excel & SSRS reports.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (