01
About this portlet
One horizontal bar per bank account, largest first, from Cash position by bank account. Each bar is the general ledger balance through today in base currency.
Hover a bar for the amount. Open the report for money in and out over the last 30 days.
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 - Cash by bank account. 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.
| Bank account | Balance |
|---|---|
| 1000 Operating account | 842,300.15 |
| 1050 Savings | 250,000 |
| 1020 USD account | 131,950.80 |
| 1010 Payroll account | 48,200 |
04
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT a.id AS account__id,
a.displaynamewithhierarchy AS account,
SUM(tal.amount) AS balance,
SUM(CASE WHEN t.trandate > TRUNC(SYSDATE) - 30 AND tal.amount > 0 THEN tal.amount ELSE 0 END) AS inflow_30,
SUM(CASE WHEN t.trandate > TRUNC(SYSDATE) - 30 AND tal.amount < 0 THEN -tal.amount ELSE 0 END) AS outflow_30,
SUM(CASE WHEN t.trandate > TRUNC(SYSDATE) - 30 THEN tal.amount ELSE 0 END) AS net_30,
TO_CHAR(MAX(t.trandate), 'YYYY-MM-DD') AS last_posting
FROM transactionaccountingline tal
JOIN accountingbook ab ON ab.id = tal.accountingbook AND ab.isprimary = 'T'
JOIN transaction t ON t.id = tal.transaction
JOIN account a ON a.id = tal.account
WHERE tal.posting = 'T'
AND a.accttype = 'Bank'
AND t.trandate <= SYSDATE
GROUP BY a.id, a.displaynamewithhierarchy
ORDER BY balance DESC