Anybody know if it is possible to pull the info in...
# suiteanalytics
r
Anybody know if it is possible to pull the info in the image below via saved search or analytics. It is billing schecules.
r
Not as far as ik. Have to load the schedule to fetch the sublist data in suitescript. If it's for reporting purposes you could create a MR which creates a CSV and send it as an attachment in a mail.
r
Yeah SuiteScript is my last resort. Just wanted to make sure there is no other option
Will you be able to share your code?
r
Will have to check, don't have one single code for this but have played around billing schedules to know this. But the basic steps for your requirement will be: In getInput stage, to fetch the list of billing schedule internal IDs meeting your criteria. In the map stage, load the billing schedule record, iterate through the sublist and pass it over to the summary stage. In summary the stage iterates over the Conext, Create the CSV and send the email. Do note: it will be slightly time consuming for even MapReduce to process and send it over. Specifically if there are too many billing schedules.
r
So the sublist has the date and amount information?
m
I believe you can pull this via reports