Oracle AP Query [message #223028] |
Wed, 07 March 2007 04:36 |
rudivdm
Messages: 2 Registered: March 2007
|
Junior Member |
|
|
Hi,
I'm looking to do a query in AP, which will select all unpaid invoices and their amounts, for specific currencies.
I have no idea where to look for guidance on this.
We are also looking for a query to select payment for a given period and currency.
We need this in Sql.
Would appreciate any help.
Thanks
|
|
|
Re: Oracle AP Query [message #223033 is a reply to message #223028] |
Wed, 07 March 2007 05:07 |
David.K.Dickson
Messages: 413 Registered: October 2005 Location: Surrey, England
|
Senior Member |
|
|
I am not a SQL expert, but I would start by running the standard report "Invoice Aging Report" (or whichever standard report your users think is appropriate) with a trace. If you look at the log file, you will find all of the SQL that makes up the report. You can then copy and customise this to meet your requirements.
HTH
David
|
|
|
Re: Oracle AP Query [message #223120 is a reply to message #223033] |
Wed, 07 March 2007 12:00 |
fakhar55
Messages: 99 Registered: September 2005 Location: UAE
|
Member |
|
|
hi,
Query 'AP_INVOICES_ALL' table and you will get the desired results from that single table. Query and view its columns.
Regards
Fakhar
|
|
|