We are working on BI Publisher check formats in PeopleSoft 9.2 Image 12 (PeopleTools 8.54). We have been able to successfully create the check file - our issue is with the overflow advice page. Please see our rtf template enclosed. (Note that our advice page also has room for any payment messages to be included with the Voucher.)
If we have only a few items to be printed on the advice page, the page comes out as intended - title on the top; ending info on the bottom; first page is not blank. (Please see the example APY2021X1-noblankpage copy.pdf)
However, if there are more items than a single page can fit, the first page of the advice is blank and the second and third page runs on. (Please see the example APY2021X1-blankpage copy.pdf).
We want to be able to have the advice limit each page to 16 items. If more than 16 items appears on the advice, generate a new page. We also want the blank page gone if we need multiple pages.
A lot of what I've found online is useful for Sales Invoices with specific XML layouts. This layout uses the delivered Pay Cycle query to return results.
How can I tell BI Publisher to create a new page if more than 16 items are to be printed on the advice page?
Any assistance on this matter would be greatly appreciated. Thanks.