Hello Group,
I would like to get a query to know all the unallocated or partially allocated credit memos in AR.
Regards,
Abbas
Unallocated Credit Memos
Hello.
Here's the requested query. Just please enter you organization_id.
Octavio
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'
Who is online
Users browsing this forum: No registered users and 33 guests