Hello People, Is there any way to export all trans...
# general
a
Hello People, Is there any way to export all transactions from Netsuite in Excel or CSV form with their body and line fields? I tried creating a saved search for all items and all fields but I got an error (It is a very big saved search). we have almost 26k transactions.
c
@Anas Jakwani there might be too many columns (26K rows should not be an issue). Could you chunk it up and create a few searches keeping one common field between all 3 and reassemble in Excel using Power Query (best option) or VLOOKUPS)?
a
How many columns is too many columns for a saved search result?
I created one with almost 50 columns and got the result
c
@Anas Jakwani I don't know the number off the top of my head? Something from a past life tells me 366 🙂
a
Great, Thanks