5 Replies Latest reply: Nov 21, 2012 12:08 PM by HakanBiroglu RSS

    XMLP - Invoice Total at bottom of the page

    Nanda - Kovaion
      Hi,

      In XMLP reporting, we are trying to generate invoice and we need to print the invocie total at the bottom of the page.

      We tried various options like
      1. Counting the number of lines of the page and inserting blank rows. - still not working as expected, if the invoice lines goes to the next page or if the line description flows to the next time.
      2. Trying to add it to the footer - Dint find it to be feasible.
      3. Invoice Summary to be printed on the last page. http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e12187/T421739T481157.htm
      since this is related to Invoice total, we are still facing difficulty.

      The invoice total at the bottom of the page looks like a standard requirement. Any guidance is much appreciated.
        • 1. Re: XMLP - Invoice Total at bottom of the page
          HakanBiroglu
          Do you have BI Publisher Desktop installed?
          If you do, see the delivered samples, for example the InvoiceListing7.rtf (default path: C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\samples\RTF templates\Invoices)

          With this example a total of a group is explained, using the following:

          Amount
          <?format-number(ACCTD_AMT,"#.###,00","Euro")?>

          Total Amount
          <?format-number(sum(current-group()/ACCTD_AMT),"#.###,00","Euro")?>

          Hakan
          • 2. Re: XMLP - Invoice Total at bottom of the page
            Nanda - Kovaion
            Hi Hakan,

            Thanks a lot.

            We use PeopleSoft XMLP (BI Publisher). So we dont have the delivered templates.

            Can you please send us the RTF to nandak.ps@gmail.com ?

            Also for my benefit, Can you please let me know, whether the total will be always printed at the bottom of the page?


            Regards,
            Nanda Kumar
            • 3. Re: XMLP - Invoice Total at bottom of the page
              HakanBiroglu
              Hi,

              Bi Publisher Desktop is delivered with PeopleTools.
              Go to Main menu, Reporting Tools, BI Publisher, Setup, Design Helper, download the zip file, extract it and install it.
              After this you will have all the examples.

              See
              PeopleBooks > PeopleTools 8.52: BI Publisher for PeopleSoft > Setting Up BI Publisher > Working with Template Design Helpers

              Regards,

              Hakan
              • 4. Re: XMLP - Invoice Total at bottom of the page
                Nanda - Kovaion
                Thanks Hankan,

                Was very helpful.
                But we want the total to be printed at the bottom of the page.
                In InvoiceListing7.rtf, the summary is printed as a new table on teh last page.

                What we need is, total of the table to printed at the bottom of the page.
                It is fine to have blank rows between the last entry in the table and the total, so the total is always printed at the bottom of the page.

                Sample one give below... This is the max format I was able to do with plain text.

                <Company Header>
                |--------------------------------------------|
                |Invoice No Descr Amount |
                |--------------------------------------------|
                |1000 Temp01 100.00 |
                |1001 Temp02 50.00 |
                |. . . |
                |. . . |
                |<blank> |
                |<blank> |
                |--------------------------------------------|
                |Total Amount 150.00 |
                |--------------------------------------------|
                <Company Footer>

                Edited by: Nanda Kumar on 21-Nov-2012 07:56

                Edited by: user9213247 on 21-Nov-2012 07:56
                • 5. Re: XMLP - Invoice Total at bottom of the page
                  HakanBiroglu
                  If you are sure that your lines all reside in one page you can use
                  <?add-page-total:variable;FIELD_TO_COUNT?>

                  <?add-page-total:amount;AMOUNT?>
                  <?show-page-total:amount;"999G990D00"?>
                  See following example
                  http://winrichman.blogspot.nl/2010/01/page-total.html

                  Or set following in your footer, assuming correct XPATH
                  <?sum(//AMOUNT)?>