This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, has anyone used the "Export Web Query" checkbox on Finance related Reports?

You have to work your way through the general ledger report, which allows you to do webquery

from there you can create any financial report

try using these fields here and you'll be able to shape a P&L or BS entries

there is a data volume limit you can download via webquery if you want to play around with Excel Power Query, so if you want to do it you'll have to break down the extraction in smaller pieces to be able to download it all