| Title: |
You can perform an ‘as of’ custom query string on BillQuick statements as an additional filter. |
| Description: |
You can perform an ‘as of’ custom query string on BillQuick statements as an additional filter. |
| Solution: |
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 2010
(
if not isnull({TransactionTable.PayID}) and trim({TransactionTable.PayID}) <> '' then
{Payment.PayDate} <= Date(2010,04,30) and
{TransactionTable.InvoiceDate} <= Date(2010,04,30)
else
{TransactionTable.InvoiceDate} <= Date(2010,04,30)
)
|
