web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

SQL Query for Period Balance

(0) ShareShare
ReportReport
Posted on by

Cards->Account->[Account Maintenance]->Summary

In the "Account Summary" screen for a specific Account, it returns Debit, Credit, Net Change and Period Balance for each period.

How do I run a query in SQL which will return all records and the amount totals would equal to the Period Balance.

For example:

In the Account Summary screen, I see Period Balance $54,249.00 for Period 10.

I run a query in SQL to return all records that was included for the amount $54,249.00, and when I total the values in Amount column, it should be $54,249.00

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    There is a View that is being used to create Summary on this screen:

    AccountSummary

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans