SQL Query for Period Balance

(0) Share

Report

Posted on by Community Member

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)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

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

AccountSummary

Was this reply helpful? Yes No