Either I just don't get the report customization links to various elements of the system or when it's all said and done, the reporting capabilities of NetSuite are quite limited.
Yes, I know there are a lot of reports, yet it seems I'm being asked to customize every single one of them and yet, can not get the data I need on a single report.
For one, you simply can't do customized reports around custom records. You need to work off of an existing built-in record that has it sourced as a parent-child relationship (and that has limitations such as who can see it and such). But if there is no relationship, you don't have any reporting capability (yet I can do searches - go figure).
Second, wouldn't it just be grand if you could do a rather "functional" report such as:
Show me all evals still underway and not returned with accompanying ship date and serial numbers.
We process evals the sames as sales orders (just zero dollars). We have a custom field that identifies it as either an order or an eval). Seems we should be able to run a sales order report and customize it to get the specific things we are interested in. Yet, we can't.
[LIST]
[*]Can't get ship date from fulfillment record (only from date set in the order which is not the field of record for this - the fulfillment/ship record is the correct).
[*]Can't get serial numbers. No matter how you slice it, this is a MAJOR malfunction of reporting. The values entered in the fulfillment record should be accessible across the order, yet from a sales order report it is not (even though there are several serial number fields accessible, none provide the serial numbers that actually shipped with the product)
[*]Can't get Days Open. We have not invoiced the customer because it is an eval. The sublist on the opportunity under 'Orders' accurately shows the Days Open value yet this only shows up on the report as 0.
[*]Can't remove an order that has an associated return that has been received. This is critical. I want to filter the order by only ones that have not been received through an RA (which would mean the eval is no longer in the field or being used by the customer). There is no way to filter this out of the list.
[/LIST]
You can get either/or of the above to some extent depending on whether you run inventory reports or sales reports. What confuses me is why you can't see all the way through. In other words, why can't I look at an order and see it all the way through to fulfillment (what was ordered, what was shipped and when, whether it has been billed or not, what the serial numbers were for each of the items shipped, and so on)?
With each new release from NetSuite identifying "new reporting features", I go in and try again. Frankly I have seen little to nothing relative to new capabilities in reporting (all looks same old way to me). Marketing needs to either provide some details on what was delivered, or back off the hype. I spend hours with reports and end up with nothing. A major waste of time and the ultimate go-nogo decision maker for executives.
IMO, NetSuite reporting is virtually useless for me.
Thanks.
-Steve