Hi:
In the Chart of Accounts table, I see the following tables:
Balance at Date, Net Change, and Balance.
I notice that Balance at Date and Balance have the same data. This appears to be true for Net Change. At least, that's what it looks like.
Also, the GL Entries table contains the Debit and Credit fields.
I'm going to want to derive the following columns in a reporting app, such as Power BI:
Beginning Balance, Debit, Credit, Net Change, Ending Balance.
I can calculate Net Change, based on the Debit and Credit fields. And, it should be relatively easy to calculate Ending Balance.
With that in mind, from which table do you derive Beginning Balance?
Thanks!
John
