OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Invoice amount

Home » Applications » Oracle Fusion Apps & E-Business Suite » Invoice amount - discoverer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Invoice amount - discoverer [message #408819]

Wed, 17 June 2009 23:29

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

Report message to a moderator

Re: New Discoverer Report [message #408822 is a reply to message #408819]

Wed, 17 June 2009 23:48

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

The following tables can be used.
ap_invoices_all
ap_invoice_payments_all
ap_checks_all
po_vendors

By
Vamsi

Report message to a moderator

Re: New Discoverer Report [message #408827 is a reply to message #408822]

Thu, 18 June 2009 00:10

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

Report message to a moderator

Re: New Discoverer Report [message #408832 is a reply to message #408827]

Thu, 18 June 2009 00:21

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Search the forum/google for pivot or stragg.

By
Vamsi

Report message to a moderator

Invoice amount-tds amount=check amount(discoverer) [message #409086 is a reply to message #408819]

Fri, 19 June 2009 05:17

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 23 14:52:34 CDT 2024