Collection Letter

rbuser

I'd like to create a collection letter for an account receiveable database
that would only pull out records that are past due. The due date is the 10th
of the next month. Any one have any ideas?? I'm using DBF files.

Thanks Steve

rbuser

This is a multi-part message in MIME format.

digitalmetaphors

You can filter the table or the query to discard the account that are not
past due. The other option is to filter the data in the query itself by
using a WHERE clause in the SQL statement. Since the past due date is
subject to change you can even create auto-search criteria that will allow
you to enter the past due date as a search parameter every time the report
is run.

--
Cheers,

Alexander Kramnik
Digital Metaphors

rbuser

I used a query with a Where clause..

Just wondering if you knew of an elegant way to Print the collection notice
at the top of the first page only for each customer's set of records??
Some reports are more than one page...
I have two pipelines, one for the customer base information and a detail
pipeline for ecah invoice that is pass due..
Thanks..

Steve

"Alexander Kramnik (Digital Metaphors)" wrote