Page 1 of 1
Unallocated Credit Memos
Posted: Tue Feb 24, 2009 8:44 am
by abbas9001
Hello Group,
I would like to get a query to know all the unallocated or partially allocated credit memos in AR.
Regards,
Abbas
Posted: Wed Feb 25, 2009 8:02 am
by oteixeira
Hello.
Here's the requested query. Just please enter you organization_id.
Code: Select all
select c.customer_name,
ps.trx_number,
ps.invoice_currency_code,
ps.amount_due_original,
ps.amount_due_remaining,
decode(amount_due_original, amount_due_remaining,'Unallocated ', 'Part Alloc') Status
from ar_payment_schedules_all ps,
ra_customers c
where c.customer_id = ps.customer_id
and ps.org_id = <your org_id>
and ps.status = 'OP'
and ps.class = 'CM'
Octavio