I am getting an error when we try to print invoices, It was working with this:
But this no longer works due to adding "CR" to the end of a few invoice #'s (to show credit)
So what I have been searching for is a way to break by Client Invoice Number without LAST-OF.
I can't use the FIRST of, because not all client_id's are consistent, some are two some are three characters.
I am still new to Progress, so I am sure there is something I have overlooked.(or not aware of)
I am running 9.1E. Please help point me in the right direction.
Thanks
Code:
FOR FIRST clients WHERE clients.client_id = w-client NO-LOCK:
FOR EACH client-totals WHERE client-totals.client_invoice_no BEGINS (clients.invoice-prefix + string(w-fs-yr,"99"))
NO-LOCK BREAK BY client_invoice_no:
IF LAST-OF(client-totals.client_invoice_no)
THEN
ASSIGN w-length = LENGTH(client-totals.client_invoice_no)
w-cli = var(SUBSTRING(client-total.client_invoice_no,(w-length - 1),2))
w-length = 0.
So what I have been searching for is a way to break by Client Invoice Number without LAST-OF.
I can't use the FIRST of, because not all client_id's are consistent, some are two some are three characters.
I am still new to Progress, so I am sure there is something I have overlooked.(or not aware of)
I am running 9.1E. Please help point me in the right direction.
Thanks