AP Supplier Statements

johnson · Post by **johnson** » Sat Mar 14, 2009 1:33 pm

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

abhyankarnarayan · Post by **abhyankarnarayan** » Sun Mar 15, 2009 2:08 am

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

johnson · Post by **johnson** » Sun Mar 15, 2009 2:33 am

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

abhyankarnarayan · Post by **abhyankarnarayan** » Sun Mar 15, 2009 3:04 am

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

johnson · Post by **johnson** » Sun Mar 15, 2009 4:13 am

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

johnson

abhyankarnarayan · Post by **abhyankarnarayan** » Sun Mar 15, 2009 5:00 am

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

oracleapps1983 · Post by **oracleapps1983** » Wed Mar 18, 2009 3:12 pm

Dear John

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

Thanks

rajeshp · Post by **rajeshp** » Fri Mar 20, 2009 3:22 am

Hi John

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

hiszaki · Post by **hiszaki** » Tue Apr 07, 2009 4:59 am

Hi johnson

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

Thanks
Hisham

pinnashanmukh · Post by **pinnashanmukh** » Tue Apr 14, 2009 1:32 am

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

Post by **admin** » Tue Apr 14, 2009 1:42 am

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

pinnashanmukh · Post by **pinnashanmukh** » Tue Apr 21, 2009 12:51 am

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

M.wattar · Post by **M.wattar** » Sat May 09, 2009 12:00 pm

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

ERPstuff - Oracle EBS Community

AP Supplier Statements

AP Supplier Statements

Who is online