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!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
Search Exporting Automation
I am analysing the data in my company for operational purposes which uses NetSuite, besides the other tools’ exports, I export 3 searches and 1 report from NetSuite on daily basis to connect them with the other data sources and prepare the insights for our stakeholders.
The mentioned NetSuite exports are for all the transactions data on the company level, so, they are CSV files with thousands of rows. Exporting such big files takes good time from my work day, hence, I was chasing an automation solution enabling me to connect the Power Bi to the NetSuite data sources.
I found out about the possibility of subscribing to these 3 searches and 1 report so I receive them in my mailbox on daily basis, this was an optimal solution as Power Bi could be connected to my mailbox and get the sent subscription from there every day, however, I discovered that I receive CSVs with fixed limit of 10,000 rows only, well, one of the searches here is generated in +141,000 rows CSV (for the billable items).