Heyo, what’s everyone using to generate non-weird ...
# generalj
jen
09/19/2023, 5:47 PMHeyo, what’s everyone using to generate non-weird Excel files from NetSuite? We have to generate Excel statements and send them to our customers via SuiteScript, and I’m pretty sure either receiving a file ending in
.xml.xlscorrupted or unsafes
Sam-I-Am
09/19/2023, 6:09 PMSpoke to my buddy Hasan (director -NetSuite ERP Platform group) while back about the .xml format of the excel import. He said they had thousands of complain about it, unfortunately fixing this would be a big challenge - it is baked into the system quite deeply so changing the format is quite a heavy lifting but they have been working on a solution.
j
jen
09/19/2023, 6:11 PMany smart hacky workarounds?
jen
09/19/2023, 6:12 PMit’s bad enough that I already had to write our own Statement Generator since the built-in one is such a POS
m
Mark C
09/19/2023, 8:06 PMI just export to CSV and let the users format as they want. But that's definitely the lazy way out.
s
Sam-I-Am
09/19/2023, 9:01 PMThat's what I have been telling my users all these years @Mark C I am darn lazy one
j
jen
09/19/2023, 9:30 PMthing is, it’s for customers
jen
09/19/2023, 9:30 PMwere it for employees I’d be less concerned
jen
09/19/2023, 9:30 PMI think I’ll just set up an option to email all three formats I’ve built (“excel” (xml), csv, and pdf)
4 Views