01
About this report
Every journal entry with the status Pending Approval. Each row gives the date, posting period, who created it, the memo, days since it was created, and the total debits in the journal currency.
Nothing in this list has posted yet, so clear it before closing the period. The journal number opens the entry.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Journal | Date | Posting period | Created by | Memo | Days waiting | Currency | Total debits |
|---|---|---|---|---|---|---|---|
| JE01422 | 2026-08-31 | Aug 2026 | Priya Natarajan | August accruals | 18 | US Dollar | 48,210.50 |
| JE01431 | 2026-09-15 | Sep 2026 | Tom Okafor | Reclass hosting to COGS | 7 | US Dollar | 12,800 |
| JE01433 | 2026-09-20 | Sep 2026 | Priya Natarajan | Prepaid insurance amortization | 3 | US Dollar | 2,150 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT t.id AS journal__id,
t.tranid AS journal,
TO_CHAR(t.trandate, 'YYYY-MM-DD') AS tran_date,
BUILTIN.DF(t.postingperiod) AS posting_period,
BUILTIN.DF(t.createdby) AS created_by,
t.memo AS memo,
TRUNC(SYSDATE) - TRUNC(t.createddate) AS days_waiting,
BUILTIN.DF(t.currency) AS currency,
d.total_debits
FROM transaction t
JOIN (SELECT tl.transaction, SUM(NVL(tl.debitforeignamount, 0)) AS total_debits
FROM transactionline tl
JOIN transaction j ON j.id = tl.transaction
WHERE j.type = 'Journal'
AND j.status IN ('Journal:A', 'A')
GROUP BY tl.transaction) d ON d.transaction = t.id
ORDER BY t.createddate04