Tom Dalton · Owner · Silver Medal

In case anyone wants this feature... Enhancement 127767 - Add the ability to report Sales by Item per Web Site Category.

Evan, How can I filter a sales by item detail report by the criteria of item's "display name/code" contains X? ...or if that isn't possible, then how can I filter the same report by item's "Store Display Name" contains X? Thanks, Tom

I found ONE of the needed filters. I added "Sales Transactions->item->preferred vendor" to my filters but it appeared to be broken. I put in "vendor X" and it says no match. I then picked the option to show a list of possible vendors and it just has a bunch of random numbers. After further investigation, it seems as though…

http://support.microsoft.com/kb/274787

Evan, is there a way that we can store the number of orders in a custom formula field? We need the data held in the customer record. Thanks, Tom

Thanks for the input. In our formula, switching from {paymentmethod} to {paymentevent.paymentmethod} worked.

Was there a solution found for getting {paymentmethod} to work in a formula field in a saved transaction search?

<bump> I just noticed this bug our reports. Then I found this six year old thread on the issue. What is the current consciences on the best work-around? -T NOTE: In 2007, mhuffman (NetSuite Employee) said: this is something we will look at for future releases

NetSuite just gave me the enhancement number (if anyone is interested in accurate trend graphs). Vote for Enhancement 138535 Trend Graphs: make every point on the "TREND LINE" represent the average of 10 units before that point even if those units that it is averaging fall off of the displayed time frame (assuming the…

Has the inaccuracy of the trend graphs been addressed with v2009.2?

Thanks Brett, NetSuite's response thus far has been that their system is too slow to generate a true trend line that actually has each point representing an average of the previous X units. I don't buy it. I think it is just a regular old design flaw and they don't see it as a an important oversight. T

Evan, the problem isn't just where the trend line starts. I don't want a trend graph that mirrors my "raw data graph", so I keep my "averaging units" turned as high as possible (10). So, theoretically every point in the "TREND LINE" on the trend graph SHOULD REPRESENT an average of the previous 10 units. If the graph is…

Thanks Julian, Now we need about 50 more votes before this problem is officially recognized. I sat through a web seminar this week about v2008.1. The presenter was thrilled about the drag and drop KPIs and trend graphs. They called it the best new feature in v2008.1. So, it is now even easier to display distorted…

I realize that I deleted an image used earlier in this post, so I added a new one that illustrates the problem. If your "averaging units" are set to to "TEN UNITS", then, points 1 through 12 (in the image above) should be plotted like this... Point #1. Average of column #1's sales and the 9 months prior to column #1 Point…

I was looking at trend graphs and noticed that they are still inaccurate. I clicked on the netSuite instructions that are available explaining what the trend line represents. See attached image. Notice that it says "EACH data point on your Y-axis represents a 3 month average" (assuming that you select 3 as your averaging…

NS, this error was pointed out 6 years ago. Any progress?

Why is it more expensive? Isn't it just a change in the programming? Why did they ever think that the current way was accurate or was the way NS customers would prefer it? They should maybe ask more users for input when building a new feature. The same type of bad choices made the "image sizing" feature unusable for us. T

NS, have you given any more consideration to improving the accuracy of the "trend line" in these graphs?

2. The trend graph data is generated based on the actual numbers for the given period represented on the x-axis. We do not make the first point a "trend average" of data in the preceding time span. However, I don't believe that answers your question. Can you please clarify so that I can provide more detail? Yes, I am…

Has the inaccuracy of the trend graphs been addressed with v2007?

2. The trend graph data is generated based on the actual numbers for the given period represented on the x-axis. We do not make the first point a "trend average" of data in the preceding time span. However, I don't believe that answers your question. Can you please clarify so that I can provide more detail? See "A" and "B"…

Keep in mind that we don't put a location on our sales order records. We only put a location on our fulfillment records. -Tom

On this same topic, can someone advise how we can take the "Inventory Activity Detail Report" and alter it so that it only shows the total number shipped (for of each item)? We want to see which items we are shipping the most of (per-location). The standard "Inventory Activity Detail Report" shows the starting inventory…

I need any kind of shipping report as long as it only shows monthly s/h totals that our customers paid (on a cash basis). I just talked with NS and they said that you can NOT make a report to show shipping information. So, if you also need this report before you can pay your sales tax (or for whatever reason), vote for…

The report was multiplying every invoice by the number of addresses that the customer had and drastically throwing off our totals. Your instructions (which I do appreciate) should have said to filter "report A,1" by "Shipping Address : State" does not equal Illinois and not by "Address Book:State". -T

Can someone from NetSuite respond?

When we ran a "Yahoo Store", we used to export all of our sales data (quarterly) and then import all of the sales date into a FileMaker-PRO database. We would then use filemaker to generate all of the reports that we needed. I suppose I could export all sales data OUT of NetSuite and import it into File-Maker to get the…

Actually, if it makes things easier for NS, the deductions could also be done slightly differently. Like this... A. Total sales from outside of Illinois (this total DOESN'T include shipping & handling costs on those orders) B. Total sales from "inside Illinois orders" that were sold to non-taxable in-state organizations…

We are getting there, but I need some more information. When i ran the first report for out of state customers, I was confused by the results. What does it mean when it says... Customer XYZ 9/25/2006...Invoice123...Brass Widget...$20 9/25/2006...Invoice123...Brass Widget...$20 9/25/2006...Invoice123...Brass Widget...$20…

It is silly that we have to pay for this data (given what we already pay for NS), but How much would it cost to pay someone (anyone) to make the report that we need? The State is really hounding us... probably because we haven't paid sales tax in 2006 and they want to receive it monthly. Email me if you are a proficient…