Hello, I have some JEs related to customers and ve...
# suiteanalytics
m
Hello, I have some JEs related to customers and vendors (field Name filled) booked on accounts other than Receivable and Payables. These JEs don’t appear in the standard A/R and A/P Aging. I’m trying to create a custom Saved Search to show these JEs. Has anyone tried to recreate an Aging Report through Saved Search or Workbook analytics? Or in any other suggestion? Thank you
t
@Matteo Colombo I've worked on projects where I've used SuiteQL to get data for A/R and A/P aging, and shared the queries in a few blog posts: • https://timdietrich.me/blog/netsuite-suiteql-accounts-receivable-aging/https://timdietrich.me/blog/netsuite-suiteql-accounts-payable-aging/ I'm not sure if those will help you. I guess it depends on what you're trying to do.
m
@tdietrich Thank you very much. Googling I had already found your interesting blog posts. And starting from those blog posts I was trying to do something similar in Workbook. But it’s the first time I’ve worked with Workbook, at the moment the results are not what I was hoping for. In particular I’m stucked trying to understand how to “group by” on dataset/workbook, which is why I tried to develop something on Saved Search as well.
@tdietrich regarding your posts. It’s not clear to me how to integrate SuiteSQL queries in NetSuite and how to show JSON results in NetSuite. Thank you