ERPstuff - Oracle EBS Community

Is there any Supplier stament report in R12 showing alll transactions of a particular supplier for the selected period/s.

Hi,

In R12, Supplier Paid Invoice History Report and Supplier Payment History are the two reports which can serve your purpose.
Else, in R12, you can run open balances report for a third party. Third party means supplier.

Hope this helps you out...

Thanks,
Narayan

Dear Narayan,

thank you for the quick reply. but we are looking for a statement. meaning all activities of a supplierduring the selected period. it includes invoices and payments

regards johnson

Hi,

The supplier paid invoice report will have invoice information and paid information. It wont have exact payment information.
Supplier payment history will have exact payment information. You need to combine both reports to achieve this. In case you just want one report it has to be a custom report I guess. Earlier I thought of Trial Balance, but it wont have invoices which are closed.

Thanks,
Narayan

Yes you are correct. we are in the process of developing a report.
thank you

johnson

Its strange Oracle has not got any reports which are very much obvious.
I dont think it is that difficult to provide.
Reports are always a problem. The standard report outputs are so horrible, its difficult to use.

Narayan

Dear John

Can you udate me the tables and Columns. That you you can get the Period wise for a Particular Report.

Thanks

Hi John

After completion let me know the steps , i am faceing same problem
Thanks

Hi johnson

I think you need to customized a report then put it on the AP responsibility to get the supplier statement.

Thanks
Hisham

Hi,

We do have the standard reports for generating the supplier statments.

Supplier Balances Detail
Supplier Balances Detail (180)
Supplier Balances Summary
Supplier Account Balance Detail
Supplier Account Balance Detail (180)

all the above are request sets need to be added to the payable request group and start using those

Thanks,
Shanmukh

Due to unavailability of few required reports it is always a requirement of customized reports and this is the area where both implementers and clients suffer. It is really strange that Oracle is not providing such reports or increasing the inventory of reports. May be to give business to his partners. Thanks

Dear members,

We do have the reports on supplier statments

It shows both summary, detail, group of suppliers what ever the way you require.

Please go through the above update

Thanks,
Shanmukh

Hi,

You Can run Global Third Party Detail and Summary Report , after you make Third Party Control Flag on the Supplier Account from General Ledger


Thanks

Mohammed