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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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