Forums › Cached › Customization › Reporting › SuiteAnalytics Connect (ODBC)

This topic contains 2 replies, has 0 voices, and was last updated by al3xicon 7 years, 6 months ago.

  • Author
    Posts
  • June 13, 2016 at 12:22 pm #8314 Score: 0

    jdelaney
    • Contributions: 0
    • Level 1
    • ☆

    Hi, has anyone figured out how to get an Aging report in SuiteAnalytics?
    This is a cached copy. Click here to see the original post.

  • October 27, 2016 at 11:43 pm #8315 Score: 0

    chanarbon
    • Contributions: 0
    • Level 1
    • ☆

    Once you know the account and the transaction types to deal with, you can perform a query joining Accounts and Transactions table but somehow will take time to generate the formula given that you can directly pull the report out of ODBC

  • October 28, 2016 at 7:17 am #8316 Score: 0

    al3xicon
    • Contributions: 0
    • Level 1
    • ☆

    jdelaney – I ended up created a custom record, and then using a scheduled script to log the results of an AR Aging by Sales Rep search I created, into the custom record once per week. I then pull that custom record table into my BI Application via ODBC/SuiteAnalytics, and I’m able to model the data that way. This gives me historical aging amounts by rep, which is helpful.

  • Author
    Posts

You must be logged in to reply to this topic.