I just wasted over an hour trying to make a very simple report. My report started with "reports->Sales->Sales by item summary>customize". I needed a column displaying the income account field so i could group sales totals by income account.
So, I try to find the income account field using the "search tool" displayed in the NetSuite report builder. I search for "income".
Results = "No results fond".
OK, that is odd. So, I search for "account". I only get a few matches. I find one that seems close after much head scratching. It is just labeled "account type", along side about 50 other fields that are also just named "account type". I hover over each one and I find one that has notes that say "Item Type > Income Account > Account Type". I add it to my report. I think I'm done at that point. I view my report and "no luck". That field only shows the word "Income" and not the full account name that I was looking for. I needed that full name like "Income -> Widget Sales" and "Income -> Sprocket Sales" etc etc.
I try all resulting fields that match the search for "account" and none of them are right.
OK, so maybe each item's income account isn't available in the reports. So, I go as far as creating a custom item field that uses a formula to source its value from the item income field. I still cant find that custom field in the list of fields available for my report columns (always using the little search tool and never just browsing through the 500+ field names which to me seems like it would be the slower way to find a field).
Over an hour into it and I just start manually browsing through every field and I ignore the now deemed worthless "field search tool". BINGO. I find the field and I find the arcane secret to the NetSuite field search interface.
<sarcasm> It was so obvious. HOW could I have missed it. </sarcasm>
One must search for the word "Name" (and "Name" only) if they want to use the "field search tool" to find and add an item's "income account name" field to a report. Sure it is technically the "income account name", but the word "Name" is also the least descriptive term there and yet it is also the ONLY term that is searchable in NetSuite. So, to use the search tool to find this field ...search for "Name" and a list of 150+ fields all generically titled "Name" will appear (150+ in our NS account anyway). Then, hover over all 150+ matching "Name" fields. Eventually you'll find a field with notes below that reads "Name -> Income Account -> Name".
That is how NS designed it.
Really?
If I explained this process to people from other systems, they simply wouldn't believe me. Why does it have to be like this?
-Tom