01
About this report
Every credit memo and customer payment with an unapplied amount. Each row gives the document, type, customer, date, days old, and the unapplied amount in the document currency and in base currency at the document's rate.
An old unapplied credit usually means an invoice was paid without being matched, or a refund is due. Sort by Days old and work down the list.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Document | Type | Customer | Date | Days old | Currency | Unapplied (document currency) | Unapplied |
|---|---|---|---|---|---|---|---|
| CM00377 | Credit Memo | Northgate Supply | 2026-03-14 | 194 | US Dollar | 450 | 450 |
| PYMT08650 | Payment | Maple Ridge Clinics | 2026-07-30 | 56 | Canadian Dollar | 620 | 452.60 |
| PYMT08812 | Payment | Brightline Dental Group | 2026-09-02 | 22 | US Dollar | 1,200 | 1,200 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT t.tranid AS document,
BUILTIN.DF(t.type) AS type,
NVL(e.altname, e.entityid) AS customer,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS tran_date,
TRUNC(SYSDATE) - TRUNC(t.trandate) AS days_old,
BUILTIN.DF(t.currency) AS currency,
t.foreignpaymentamountunused AS unapplied_fx,
t.foreignpaymentamountunused * t.exchangerate AS unapplied
FROM transaction t
JOIN entity e ON e.id = t.entity
WHERE t.type IN ('CustCred', 'CustPymt')
AND t.foreignpaymentamountunused > 0
ORDER BY t.trandate