The NetSuite GL Impact Screen Is Hiding Your Best Columns.
Here’s How to Show Them. You’re staring at the GL Impact screen on a transaction. You see accounts, debits, credits, names, memos. You want to know what item drove a specific line. You can’t see it. Of course you can’t — the column isn’t there. So you bounce back to the transaction, hunt through…
Here’s How to Show Them.
You’re staring at the GL Impact screen on a transaction. You see accounts, debits, credits, names, memos. You want to know what item drove a specific line. You can’t see it. Of course you can’t — the column isn’t there.
So you bounce back to the transaction, hunt through the lines, try to match the dollar amount, give up, build a saved search, export to Excel, and lose twenty minutes you didn’t have.
There’s a better way, and it’s been sitting in the URL the whole time.
The Default Screen Is Just a Saved Search
When you click GL Impact on a transaction, NetSuite is running a saved search behind the scenes — a stock one shipped with the product. That stock search has a fixed set of columns: account, debit, credit, posting period, name, memo. None of which include things like Item, Item Type, Item Quantity or custom transaction line fields.
The columns are baked into the saved search, not into the screen. Which means if you point the screen at a different saved search, you control the columns. And NetSuite makes that swap embarrassingly easy.
The Trick
Pull up the GL Impact screen on any transaction. The URL looks like this:
/app/accounting/transactions/transaction.nl?id=12345&searchid=-36
That searchid=-36 is the stock GL Impact saved search. The -36 is its internal ID — negative IDs are reserved for system searches.
Build your own transaction-based saved search with the columns you actually want, and NetSuite will give it a positive ID — say 3688. Drop that ID into the URL in place of -36:
/app/accounting/transactions/transaction.nl?id=12345&searchid=3688
Hit Enter. The GL Impact screen now renders with your columns. Item, Quantity, whatever you put in the search.
searchid — now Document Number, Item, Quantity, Inventory Location, and more all surface inline.
A quick clarification: This trick works for the GL Impact screen you reach from Actions → GL Impact on a transaction (the standalone page that opens with debits, credits, and the toolbar with export icons). It does not apply to the newer GL Impact tab/subtab that appears inline on some transaction records — that view uses a different rendering path with no searchid to swap. If you’re working with the tabbed view, the column customization happens at the transaction form level instead, which is a different conversation.
Building the search is the easy part: new transaction saved search, no criteria (the screen scopes to the current transaction automatically), then add the standard GL Impact columns plus the ones you actually came for. Save it, grab the internal ID, plug it in the url. The whole thing takes about five minutes the first time and zero minutes every time after that — once you create a bookmarklet or build a Custom GL Impact button on your transaction form.
What This Unlocks
Inventory and COGS troubleshooting. Add Item, Item Type, and Quantity to the search. Now you can see exactly which item generated a $2,317.42 COGS hit without leaving the screen.
FX and intercompany variance hunts. Add Subsidiary, Currency, and Exchange Rate. Especially helpful when you’re chasing a few cents that won’t reconcile.
Custom field visibility. Approval status, project codes, internal tracking fields — if you’ve built it as a custom transaction field, it can show up here.
A Few Things Worth Knowing
Make the search public if multiple users need it, or share it with the appropriate roles. Don’t add criteria — the screen passes transaction context automatically, and any criteria you add will filter out lines you wanted to see. And to be clear, this isn’t a hack: the searchid parameter is a documented NetSuite mechanism used across the platform. You’re just pointing it somewhere new.
Why This Matters
On its own, this is a small thing. A column on a screen. But it’s representative of something bigger about NetSuite: the platform gives you significantly more control than the default UI suggests. Most users never look behind the curtain. The ones who do — or who hire people who do — end up with a system that bends to fit their work, instead of the other way around.
The GL Impact trick is one of dozens of similar small wins our team has accumulated over twenty-plus years inside the platform. Independently, each one saves a few minutes. Together, they reshape how your team uses NetSuite.
Wish your NetSuite did something it doesn’t appear to do? It probably can. Fourth Wave Consulting has been doing NetSuite consulting since 2003 — saved searches, scripting, integrations, custom forms, the works. If something in your daily workflow feels harder than it should, get in touch and we’ll take a look.
