BQE Knowledgebase

"As Of" custom filters on BillQuick statements

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 2010

if not isnull({TransactionTable.PayID}) and trim({TransactionTable.PayID}) <> '' then
{Payment.PayDate} <= Date(2010,04,30) and
{TransactionTable.InvoiceDate} <= Date(2010,04,30)
{TransactionTable.InvoiceDate} <= Date(2010,04,30)

Related Articles


No attachments were found.

Visitor Comments

Article Details

Last Updated
10th of May, 2018


Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

User Opinions

0% thumbs up 100% thumbs down (1 vote)

How would you rate this answer?

Thank you for rating this answer.