Is there any way to compile multiple reports into ...
# general
b
Is there any way to compile multiple reports into one Excel doc on different tabs systematically? Via scripting or anything. We schedule something like 15 different Budget vs Actual reports monthly that he now wants to see in one Excel document with each report's results on a different tab. I think the answer is likely no, but just confirming before I tell my CFO once again I can't produce what he wants.
k
You could use a tool like Solution 7 for this.
b
Yeah that's what I figured was going to be the answer. We are stuck at an impasse about NS reporting. Very frustrating to deal with, especially on a Monday. Thank you so much!!
k
I mean, if it's that big a deal - send them to a cheap employee and have that employee stitch them into one document for 40 minutes a month.
b
That's what's been happening. The exec assistant is the one doing it. They will likely just use this as another thing that NetSuite "can't" do, which is so frustrating because it's so stupid. I spent an entire meeting a few weeks ago explaining how ridiculous it was that they are upset that the excel exports don't preserve the column width and they have to format the columns within Excel. So I'm just trying to pick my battles lightly these days.