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
Chris Corcoran
09/25/2023, 5:30 PM
@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
Anas Jakwani
09/25/2023, 5:33 PM
How many columns is too many columns for a saved search result?
Anas Jakwani
09/25/2023, 5:33 PM
I created one with almost 50 columns and got the result
c
Chris Corcoran
09/25/2023, 6:21 PM
@Anas Jakwani I don't know the number off the top of my head? Something from a past life tells me 366 🙂