T
TD
I have a check report that prints checks for our account payable department.
On the report at the bottom i have a sub report that pulls detail
information for the check. For example Check #123 for $1000.00, paid
to......etc. On the bottom of the check the sub report pulls all the
invoices for this check that totals $1000.00. For example Invoice #1 -
$10.00, Invoice #2 - $15.00, etc.
All works well until I run into a check that pays a large amount of
invoices. Currelty there is only room for fifteen (15) invoices to be
listed in the detail section of the sub report at the bottom of the check
report. The problem that happens is that if the check pays more than 15
invoices, say 20 invoices, then the detail of the last 5 invoices rolls over
onto the next check, thus not only ruining a new check (our checks are
preprinted with check numbers), but then causing all future checks to be off
by one check number.
Does anyone know of a way to print my checks, and if the total number of
items exceed 15 that it not print these and somehow instead print these on a
blank sheet of paper instead of a check?
I know it sounds complicated, and it is to me. I'm lost. Any help would be
greatly appreciated.
Terry
On the report at the bottom i have a sub report that pulls detail
information for the check. For example Check #123 for $1000.00, paid
to......etc. On the bottom of the check the sub report pulls all the
invoices for this check that totals $1000.00. For example Invoice #1 -
$10.00, Invoice #2 - $15.00, etc.
All works well until I run into a check that pays a large amount of
invoices. Currelty there is only room for fifteen (15) invoices to be
listed in the detail section of the sub report at the bottom of the check
report. The problem that happens is that if the check pays more than 15
invoices, say 20 invoices, then the detail of the last 5 invoices rolls over
onto the next check, thus not only ruining a new check (our checks are
preprinted with check numbers), but then causing all future checks to be off
by one check number.
Does anyone know of a way to print my checks, and if the total number of
items exceed 15 that it not print these and somehow instead print these on a
blank sheet of paper instead of a check?
I know it sounds complicated, and it is to me. I'm lost. Any help would be
greatly appreciated.
Terry