[dan.aronson@safemart.com]

Anyone found a great reporting tool that plugs into NetSuite? I am looking to create very custom reports based on very complicated searches and reports that pull from multiple searches at one time.
This is a cached copy. Click here to see the original post.

[JCirocco]

RE: Custom Reporting Tool

I would suggest ODBC and Crystal Reports. The ODBC driver gives access to most (but not all) of NetSuite and Crystal will give you almost unlimited flexibility.

[savethepennies]

We are using the ODBC connector and SQL Server Reporting Services (SSRS). As John stated above, the ODBC connector gives access to most information. We have found two challenges with the connector, both of which can be worked with but it is nice to know about them.

1 – There are some odd limitations in constructing queries. Some are documented, many are not. For example, sub-selects and joins can not coexist. Supported functions are also limited.

2 – Performance of the connector goes downhill fast with multiple joins. It is not uncommon for queries joining 3 or 4 tables to take 4-8 minutes.

It would be interesting to hear if others have found the same things or have been able to work around. I have created a utility that keeps a local cache up to date. Not ideal but makes it possible to use the data as we need to.

[khultquist]

RE: Custom Reporting Tool

We use ODBC with Excel for MRP reports, it works really well with a couple of small issues:

It can be slow for large joins, as noted above.

There are a few tables that are not accessible (the one that comes to mind is Unit of Measure).

[rnedelkow]

RE: Custom Reporting Tool

Originally posted by khultquist

View Post

We use ODBC with Excel for MRP reports, it works really well with a couple of small issues:

It can be slow for large joins, as noted above.

There are a few tables that are not accessible (the one that comes to mind is Unit of Measure).

Version 2011 Release 2 provides the following enhancements to ODBC views:

Landed Cost Fields Exposed to ODBC

ODBC Views for Units of Measure

Thanks,

[eileensagabaen]

RE: Custom Reporting Tool

Originally posted by dan.aronson@safemart.com

View Post

Anyone found a great reporting tool that plugs into NetSuite? I am looking to create very custom reports based on very complicated searches and reports that pull from multiple searches at one time.

For reporting tool, you can try:

http://daft.sourceforge.net/ or

http://www.winsql.com/

[Author]

Posts