Unallocated Credit Memos

[abbas9001]

Hello Group,

I would like to get a query to know all the unallocated or partially allocated credit memos in AR.

Regards,
Abbas

[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