Creating external historical aged trial balance

[Luvsql]

I would love to be able to duplicate the historical aged trial balances in both A/P and A/R using crystal as it takes forever to print in GP and I could use this data for reconcile reports as well.

I am able to get the data correct using a stored proc, but the voids are causing me huge headaches. We post and print by GL date. If a payment is posted on 10/31/03 and voided on 11/01/03, the void didn't really happen yet if you print the HATB as of 10/31/03. This is where it gets tricky and am unsure of how to get this query going.

Anyone attempted this?

 

[mental23]

Same questions here... would love to be able to get these agings faster.... wil you keep me posted on your progress?

Thanks!