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)
else
{TransactionTable.InvoiceDate} <= Date(2010,04,30)
)




Related Articles

Attachments

No attachments were found.

Visitor Comments

Article Details

Last Updated
1st of October, 2013

Product
BillQuick

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.

Continue