cctenergy - is your search a transaction search or an item search? Also, can you provide screenshots?

Instead of having Transaction : Type is Item Fulfillment in the Criteria tab, you would remove it. Then, instead of the Transaction : Date in the Results tab, you'd need a formula. Formula (Date) : CASE WHEN {transaction.type} = 'Item Fulfillment' THEN {transaction.trandate} ELSE NULL END That will include all items, and…

AlanW - we use Sisense. Right now, the best source of training seems to be NetSuite's training courses, which are pricey and you need to come in already knowing Javascript / general programming concepts (ideally, anyway). You may be best off hiring a freelance NS developer and paying them for a few hours of work to get…

AlanW - I can say with confidence that that sort of complex search/report is something that can be easily done within NetSuite. I would use BI software to do that sort of complex analysis, or else I would make several different saved searches, each one focusing on a different piece of data you wish to look at, and then…

AlanW - how do you define slow- or non-moving stock? Generally I think that most companies vary in this definition, so the best bet is, once you determine what it means to you for inventory to be slow-moving, then build a saved search identifying those items as Olivier Gagnon NC mentions. In the past I have come up with…

AlanW - using search joins to report on transaction detail when building an item search is problematic. This is mainly because of how NetSuite performs the searches - essentially, for each item you have (5,000), there are potentially multiple transaction lines every day - this could mean hundreds in a given accounting…

AlanW it is possible, however it sounds like you'll want to start creating some custom item fields that store some information like "last receipt or adjustment date" etc, so that you can leverage those in your searches and not have to use search joins all the time. The slow-moving stock report leveraging the ratio is a…

Not sure on this, but I'd set them to run at midnight on the 1st of a new month, and have the report generate numbers for the previous month (that way you get everything at month end). Does this make sense?

I would probably go the route you're thinking, as in using a saved search - I'd also think that the RANK() function might come in handy there...

farrago sounds like a nightmare!

Tom - could you elaborate? I haven't in particular used Celigo for their Amazon connector.

rnedelkow I tried submitting a case for this as well but just got a message I haven't seen before: "A problem occurred while submitting your case. Customer Support has received your case information and will submit it manually."

We weren't a NS store but we did transition from XCart to Magento, and though I wasn't here for it, from what I understand there was a HUGE SEO hit, amplified by the fact that we transitioned *right* before we went into our busiest season of the year, so the company suffered quite a bit from that. I've no idea what the…

We use Magento Enterprise and connect to it using Celigo. It has worked well for us.

Pretty much, farrago. The Magento extensions community is quite large. We use numerous, including TurnTo for ratings/reviews and Nextopia for site search.

We use Magento Enterprise and integrate using Celigo. The pair seem to work well.

Sure, that does make sense - unfortunately I'm not too sure whether you can do that with SuiteTalk or not as I haven't used it much; perhaps someone else can chime in on that.

I may be wrong, but I believe that the status only changes when a bank deposit is recorded / applied to that payment/cash sale - i.e. it's not a status you can change in the UI, so I would doubt that SuiteTalk could change it.

Nic - you will need a tool that allows you to connect via creating a "Generic ODBC" connection. I have had luck with a trial of Toad Data Point (free). There are others as well (though I haven't really tried many others), and these provide a GUI for interacting with and querying NetSuite via ODBC. You can also code your…

We have seen some over the weekend with our eBay orders, but it hasn't been anything out of the norm for us, and I believe we have been able to resolve them.

Yuuup. Good old kits. I inherited this issue here (first time using Kits) about a year and a half ago, and what it boils down to is that any reporting you do that needs to look at the Kit Member level essentially needs to look at inventory movement, not sales. So, I have a bunch of reports that look at Item Fulfillments…

You likely need the Criteria filter for Main Line = True. Without this, the search will return a result for each line item (including tax and shipping) of the transaction.

Hi Michoel, ID, Name, Company Name, State, email, Transaction Number (count), Amount (sum), Promotion, and two custom fields for customer types. The records are grouped by customer name, and all others are Maximum summaries except number and account. Thanks for any hints. Like POwen my first thought is to addresses. I…

sum(case when {item.custitem_year}='2015' then {amount} else 0 end)/NULLIF(sum(case when {item.custitem_year}='2015' then {quantity} else 0 end),0) That should do it

This doesn't solve your issue directly, but those links won't display if you group your results. Might get you what you are after.

You saved me a lot of trouble by posting this radioblaster - thank you so much!

Yeah I found that one rnedelkow - was hoping there was one a little less ridiculous.

Looks like that article doesn't exist anymore. Does anyone have the formula itself or a copy of the article?

Update: I found it. It's the ITEM_COUNT field. D'oh!

How do you pull the quantity of a transaction line on something like an Invoice? All the referenced fields in the schema seem to contain null (qty picked ,qty packed, qty committed, qty received). There doesn't appear to simply be a "quantity" field. Am I missing something?