Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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!