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!
How to download transaction details that ties to the P&L and change of Balance sheet?
I want to download these transactions for the auditor. But I have a tough time getting anything tied. The logic is straightforward. I need to download all transactions with GL debit/(credit) with GL Account and vendor information for YTD. The total amount should be 0. If I run the pivot table by account by month, it should tie to the monthly P&L and monthly change of BS account by account. I did this exercise in Workday, PeopleSoft, Sage with ease. But it is such a painful process in NetSuite.
Here are the different ways I did it.
- Use the financial report builder -> Custom Income Statement Detail, But it keeps adding a header row and subtotal line. I can not change financial row 1, or financial row 0 to a different column.
0