Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Journal Entry Summary by GL Account
I am new to NetSuite and doing my first run at financials in a new system. I am trying to find out how to get a Summary by GL account for a Journal Entry that's nearly 1000 lines long. There is no link to click to get a total GL impact by account for the entry, which is 998 rows long (rev rec JE for the month) but posting to only 5 GL accounts.
As a workaround, I clicked on Actions/GL Impact, exported to Excel, and then created a pivot table to sum the lines by Account. But this seems like a long process if I'm going to have to do this on every Journal Entry I want a net GL impact for. Can someone please tell me if NetSuite has a simple way to get this information? Thanks in advance!
Tagged:
0