You can apply an ‘As Of’ custom query string on BillQuick statements as an additional filter.
To apply an ‘as if’ custom query on statements, you need to change the three Date fields to what you want. E.g., for April 30th 20xx,
(
if not isnull({TransactionTable.PayID}) and trim({TransactionTable.PayID}) <> '' then
{Payment.PayDate} <= Date(20xx,04,30) and
{TransactionTable.InvoiceDate} <= Date(20xx,04,30)
else
{TransactionTable.InvoiceDate} <= Date(20xx,04,30)
)
where 'xx' represents the last two digits of the year.