Oracle Analytics and AI

User_MNW2U

Summary

Issue with AR Statement BI Publisher output

Content

Hello Gurus, one year back we moved from 11i to R12. In 11i AR statement report was customized in report builder. But post R12 this report has been moved to RDF and Output in PDF using XML publisher. There was a requirement to create report using multiple template. We are also using no of lines per page option, for this we have used code available on Metalink and google. Although we are using proven solution, still we are facing one issue for which we are not able to find any solution. We are excluding 0 amount invoices from the statement due to which logic which is being used to count number of lines, is not working correctly. On some pages 10-15 lines are getting printed and some pages on 2-3 lines are getting printed for one customers. since it is customer facing document, does look good if it prints on 3 lines on page one and 10 lines on next page for same customer.  As time lapsed this issue is becoming very critical for business, we are not able to find any solutions. Your help is this regard is very appreciated. I am attaching RTF, XML output and   PDF output for the same.

Thanks in advance.

Regards

Mayur Sarwate

Brajesh Shukla-95078

Hi ,

We have similar requirement for check print. Where we need to print 30 Lines per page, if invoices are more than 30 lines then 31th line should print in second page.

And also I can see based on number of records "Note: Beckman Coulter, Inc." and "TOTAL AMOUNT / MONTANT TOTAL CAD ::" is moving up down.

Solution for this is

use  Below Layout. You can see only Line table is there on the body. Adjust Header and footer space in a such a way that for body you left space for specific line e.g. 30 or 10 in your case.

<?start:body?>

<?end body?>