Hi, I am trying to determine why my GL and AP control accounts dont balance.
Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.
To this end, I would like to build a query in sql views that recalculates a vendors balance based on the invoices and payments that have processed.
I am sure someone has done this, but hoping someone might share their query.
Thanks
JCS