Hi! I would like to build an A/P Aging report usin...
# general
j
Hi! I would like to build an A/P Aging report using a saved search...this seems like it would be pretty straight forward, however I'm having a few issues. Are there any templates, examples, guides I can follow as my logic seems to be producing incorrect results. Also, I know there is a native A/P Aging report in NS already. Are native reports in NS accessible using either the REST or SOAP api? If they are not, is it possible to access a suiteAnalytics workbook via one of the APIs?
m
If you search this in suireanswers there are numerous articles about it
j
ok, thank you - will take a look
You can use SuiteQL via the REST API
j
great - thank you @michoel!
l
I have been looking for this as well but I have not found a way to replicate the snapshot feature of the standard report where I can run the saved search as of a specific past date and get the aging as of that day too instead of as of the day I run the saved search. Or maybe you don't need it and just need real time data?
j
Im trying to get real time data for an integration
m
Sorry not sure why this didn’t send originally https://suiteanswers.custhelp.com/app/answers/detail/a_id/85341/loc/en_US
But maybe you found it already
j
Thank you!