| AR - wanted to list down "On Account" Receipts [message #452596] |
Thu, 22 April 2010 23:23 |
chandramatta
Messages: 15
Registered: January 2010
|
Junior Member |
|
|
Hi All,
Question on Oracle Receivables.
- How can I list down all the receipts, which are applied "On Account". - meaning receipts not applied to any specific Invoice.
Anything wrong with my following query ?
--
SELECT substrb(party.party_name,1,50),cust.account_number, acr.receipt_number, ara.status
FROM ar_receivable_applications_all ara,
ar_cash_receipts_all acr,
hz_cust_accounts cust,
hz_parties party
WHERE ara.cash_receipt_id = acr.cash_receipt_id
AND ARA.STATUS IN ( 'ACC')
and acr.pay_from_customer= cust.cust_account_id
and cust.party_id = party.party_id
--
This is not giving the results that I am expecting.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
