Unable to Pull Aged Receivables and Payables report with back date/period

Hi,

We are using MyOB AccountRight

I have pulled the AR Aged Recivable report on 20th July (today), it has taken all the updated balances as of 20th July 2023 (though the date mentioned as of 30/06/2023).

If you check the attached file,

Ashborn balalnce should be nill as of 30/06/2023. Here the respective invoice created on 07/07/2023. Bayaswood Balance should be 7,750.26, as we have got payment of 6,500.00 on 13/07/2023 against May23 invoice. But the balalnce showing 1,250.26 after adjusting 6,500.00.

I am getting the same issue in Payable ageing reports as well, if I pull the report today (considering as of 30/06/2023), there wouldn’t be anything under May23 balance as we paid 99% amount of May2023 invoices in 1st week of July2023.

This problem I am facing every month. That’s why I always pull the report last day of the month or before any adjustment of next month! And its very difficult for external accountant or auditor if they wants to validate my report that I have pulled on 30/06/2023. Not sure whether this is the Universal problem or I need to change setting in my end?

Thanks ,

Sumit