Q: My NetSuite saved search should have 32,000 rows, but I’m only getting 7000?
A: If you’re using the Insert or Update query type, depending on how your search is set up, you could be getting the sum of all LINES on all transactions (in this case, 32,000), but the number of actual transactions is only 7000.
To export all lines from NetSuite, the Group rows checkbox should be unchecked, so the configuration in IO looks correct. If Group rows is checked, this will export the 7000 transactions as records. If unchecked, the 32,000 lines will each be exported as separate records.
