Page 1 of 1

Invoice and payment details for a supplier

Posted: Thu Dec 04, 2008 7:28 am
by jairam.apps
Hi all,

Is there any report in payables which gives all the details of the invoices and payments by supplier name.

I know I can get some invoice details from the

Invoice register and Invoice history report

Payment details from 'Payment register'.

But I want all the details from a singal report.
Is there any report avilable to pick the invoices and payments details of a supplier.

Regards,
Jayaram.

Posted: Thu Dec 04, 2008 10:15 am
by smishra0oracle
First You have to report manger or report 6i and database user id. First You will get this then access the PO_Vendor table from APPS>PO, AP_Invoices_all and ap_payaments_all from APPS>AP.
Choose your detail which you want and generate the reports

Posted: Thu Dec 04, 2008 12:08 pm
by oteixeira
Hello.

The Invoice History Report provides information to support the balance due on an invoice. It helps you quickly identify and review a detailed list of all payment activities pertaining to a specific invoice such as gains, losses, and discounts.
All amounts on this report are shown in the payment currency.

Hope this helps.
Octavio

Posted: Sat Dec 06, 2008 8:50 am
by niletra
HI GO TO THE 2 REPORTS
1.INVOICE HISTORY REPORT

2.SUPPLIER PAID HISTORY REPORT..

THANKS
NILETRA.