Home » Applications » Oracle Fusion Apps & E-Business Suite » Invoice amount - discoverer
Invoice amount - discoverer [message #408819] Wed, 17 June 2009 23:29 Go to next message
phani2327
Messages: 20
Registered: April 2008
Junior Member
Hi everyone,

I am new to preparing reports in discoverer recently i got a requirment from my client ,his requirment is bello columns he want in that report.

columns names:-Invoice Num,Invoice Amount,Tds Invoice Amount,Paid amount,check number,check date,supplier name,

(india localization)can anybody help me how to prepare new report.


Thanks

Phani
Re: New Discoverer Report [message #408822 is a reply to message #408819] Wed, 17 June 2009 23:48 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
The following tables can be used.
ap_invoices_all
ap_invoice_payments_all
ap_checks_all
po_vendors

By
Vamsi
Re: New Discoverer Report [message #408827 is a reply to message #408822] Thu, 18 June 2009 00:10 Go to previous messageGo to next message
phani2327
Messages: 20
Registered: April 2008
Junior Member
Thanks Vamsi for immidiate replay,

in ap_invoices_payment table i selected Invoice amount column in that column standard invoice amounts and tds invoice amounts both are coming but requermint is seperate columns i need

Example:-Present output

invoice number , invoice amount
10 1000Rs
10 TDS -200

Required output

Invoice number,invoice amount,tds amount,paid amount
10 1000 -200 800
Re: New Discoverer Report [message #408832 is a reply to message #408827] Thu, 18 June 2009 00:21 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Search the forum/google for pivot or stragg.

By
Vamsi
Invoice amount-tds amount=check amount(discoverer) [message #409086 is a reply to message #408819] Fri, 19 June 2009 05:17 Go to previous message
phani2327
Messages: 20
Registered: April 2008
Junior Member
Hi,

In ap_invoice_payments_all table AMOUNT column -Ve ,+Ve amounts are coming in one column how to get the saperate columns in discoverer.


EX:-Invoice amount(1000)-tds amount(200)=check amount(800)

[Updated on: Fri, 19 June 2009 05:18]

Report message to a moderator

Previous Topic: AR Error ORA-20000: APP-11027: Mandatory Segment: "COUNTY" missing in address
Next Topic: Oracle Application Library Files
Goto Forum:
  


Current Time: Thu Dec 08 04:26:04 CST 2016

Total time taken to generate the page: 0.10508 seconds