01
About this portlet
Shows Journal entries pending approval on a NetSuite home dashboard as a table of ten rows per page, with the journal, date, posting period, creator, memo, days waiting and total debits. None of the listed entries has posted yet.
After import, give the report an audience. Then, on a NetSuite dashboard, choose Personalize and add a Custom Portlet. On the new portlet, choose Set Up and pick Advanced Report - Journal entries pending approval. The portlet shows only to people who can open the report.
02
What it carries
The portlet reads 1 report. They travel in the same file, so the import creates them first.
03
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 |
04
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.createddate