Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Retail Training Forum
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Need help with a cross tab report

0
Need help with generating a report in PDF.
Consider the scenario:

There is a Customer Cust1.

He has 3 sites. SiteA, SiteB, SiteC

The Customer has AR Invoices for each of the site.

Need to generate a PDF report in fusion, with each line as an Invoice.


CUSTOMER Name: Cust1

Invoice1 Invoice1_Line1 Invoice1_Line2 Invoice1_Line3
Invoice2 Invoice2_Line1 Invoice2_Line2 Invoice2_Line3
Invoice3 Invoice3_Line1 Invoice3_Line2 Invoice3_Line3
Responses (2)
  • Accepted Answer

    Tuesday, October 29 2019, 10:13 AM - #Permalink
    0
    Hello Phani,

    You can write OTBI analysis for this requirement.

    Select the receivables transaction subject area.

    Select Customer, customer site, invoice number , invoice amount, business unit fields.

    Click on next

    Filter the report by business unit.

    Group by customer and customer sites.

    Save the analysis.

    OTBI analysis can be run in multiple formats, including PDF.

    You should be able to view the invoices in each line in a pdf output.

    Please refer the below link to know "how to create OTBI reports"

    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, October 29 2019, 10:14 AM - #Permalink
    0
    https://www.youtube.com/watch?v=Ce8iSH_GIPs&feature=youtu.be
    The reply is currently minimized Show
Your Reply

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    1  2  3  4  5
  6  7  8  9101112
13141516171819
20212223242526
2728293031  

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner