I've been asked to create a page that shows our US...
# suitescript
b
I've been asked to create a page that shows our US chart of accounts and under each US account, any global account that is mapped to that US account should be listed by subsidiary (we do multibook accounting). I tried just using the new SuiteAnalytics workbook to create a pivot table, because that's basically what I'm trying to create (US account name > legal entity > global account name), but I can't find a way to publish the pivot table with the correct format so I'm trying to create a suitelet to do this. We have something like 200 US accounts. What's the best way to go about this? I'm new to SuiteScript, though not new to programming.