Tom Dalton

How do you filter out matrix parent items from inventory reports? Matrix parent items aren't "real" items and can't be ordered or counted as inventory, so why are they in there? I called NS and they said they can't be removed from inventory reports ...by design. I can filter them out when doing a "saved search", but the…

で Need Inventory valuation report Tom Daltonによるコメント Mar 16, 2009 1:10PM

Enhancement #146229 - Ability to Search items by the Item Drilldown Template field. Has anyone found a work-around? -Tom

で Item Drilldown Template search Tom Daltonによるコメント Nov 17, 2010 3:16PM

I've always thought there should be an item dashboard linked from every item with such information plus sales graphs/ kpi's/ best customer ... etc.

で Show Quantity sold on Item Record Tom Daltonによるコメント Jun 23, 2016 12:38AM

Is the change in the shipping cost or in the cost of the merchandise? T

で Cost of sales randomly changes for closed periods Tom Daltonによるコメント Oct 26, 2006 4:13PM

Thanks JCirocco. I'll try it. I've done lots of CSV imports of items and such, but I didn't even know one could CSV import a quote/estimates. So, if we have 5000 SKUs, we'd end up with 5000 estimates. Interesting. -Tom

で Pulling web-store shipping cost into a saved search - is it possible? Tom Daltonによるコメント Oct 22, 2018 3:30PM

oh. got it: Use the formula: median({XXX}) /* avg() */ 2. Set the Summary type to Average

で Is there a way to calculate the median for a group of numbers? Tom Daltonによるコメント Oct 9, 2018 12:23PM

Thank You!

で Filter transaction search by the number of line items? Tom Daltonによるコメント Jan 9, 2018 1:08PM

This didn't work by the way. Ug. I wish NS just had a field called "Count of Lines" that worked and only counted the number of line items on any transaction record.

で Filter transaction search by the number of line items? Tom Daltonによるコメント Feb 8, 2018 12:16PM

Using totalquantityonhand was the ticket. How do you find out about these undocumented fields? In here... I guess!

で SQL Case When statement Tom Daltonによるコメント Jun 19, 2018 11:55AM

formula: "{thumbnailurl}" = ERROR: Field Not Found

で information item saved search - can't access thumbnail URL Tom Daltonによるコメント Feb 3, 2017 4:46PM

I need a text "availability flag" for a feed. I need it in a custom text item field. Any reason why this isn't working.... [INDENT]CASE WHEN {isdropshipitem} = 'T' THEN 'in stock' WHEN type = 'Kit/Package' THEN 'in stock' WHEN {quantityonhand} > 1 THEN 'in stock' ELSE 'out of stock' END[/INDENT] It always says ERROR: Field…

で SQL Case When statement Tom Daltonによるコメント Jun 18, 2018 6:28PM

No, we didn't.

で KPI scorecard for the average number of sales orders per customer / per date range Tom Daltonによるコメント Jun 1, 2015 2:09PM

For CONCAT of more than two fields you can not do this (from my experience anyhow)..... CONCAT(data1, data2, data2) You start with CONCAT(data1, data2) then, if you need a third variable added, you replace data2 with CONCAT(data2, data3) like this... CONCAT(data1, CONCAT(data2, data3) ) The same goes for data4 and data 5…

で CONCAT within DECODE Tom Daltonによるコメント Jan 10, 2013 6:17PM

Is it possible to use decode to determine if an item is a matrix child and set fields accordingly? Something like... DECODE({matrixType},'_child','this item is a matrix child','is item is not a matrix child')

で CONCAT within DECODE Tom Daltonによるコメント Mar 29, 2013 5:26PM

Shouldn't or couldn't this be easier? -Tom

で Drip Marketing - send emails after 30, 60 & 90 days Tom Daltonによるコメント Sep 22, 2009 12:42PM

Thanks. It worked. Used... CASE WHEN {createdfrom.paymentmethod} like 'Amazon%' THEN 'Amazon' WHEN {createdfrom.paymentmethod} like 'Walmart%' THEN 'Walmart' WHEN {createdfrom.paymentmethod} like 'eBay%' THEN 'eBay' ELSE 'our web site' END Lets say the custom filed ID was {custbodysales_channel}, then when adding this…

で Can we access {paymentmethod} in a fulfillment record? If so, how? Tom Daltonによるコメント Feb 27, 2017 2:41PM

Found the convoluted workaround to adding the custom field to the fulfillment email in SuiteAnswers (Answer Id: 31505).

で Can we access {paymentmethod} in a fulfillment record? If so, how? Tom Daltonによるコメント Feb 27, 2017 3:12PM

I hate to say it, but we don't know enough about deploying scripts to take your script and make it part of our forms. PM me if you want to do it for us (and ear a little extra $) or post a step-by-step how-to if you have the time. Thank YOU, Tom

で Restrict the types of characters used in a NetSuite field (like item Name/Number) Tom Daltonによるコメント Feb 5, 2015 5:57PM

Yes, I did try that one. It didn't work. Do you have any more ideas? ${item.item} appears to be a combined field of "{ItemID} + Item {displayname}". We just want ItemID. I'm sure others would also want a column just for the part number on their sales orders and such. -Tom

で How to add part number (item id) to a sales order using Advanced PDF/HTML templates Tom Daltonによるコメント Dec 10, 2014 12:21AM

ALSO, while we're at it, this field ${item.saleunit} doesn't work and was a column on our standard or legacy Sales Orders. -Tom

で How to add part number (item id) to a sales order using Advanced PDF/HTML templates Tom Daltonによるコメント Dec 10, 2014 12:50AM

That is what I thought. Thats a bummer as we don't have people in-house that write js

で Does NetSuite offer global transaction fields? Tom Daltonによるコメント Oct 8, 2013 5:39PM

another way to approach this is to add a non-inventory item (named 'catalog') to the order. You could have a really simple script or workflow that would add the item to the SO if the customer has no previous sales. That wouldn't work for us. We've never had printed a catalog. We want our old customers to get a catalog when…

で Does NetSuite offer global transaction fields? Tom Daltonによるコメント Oct 8, 2013 4:40PM

You must have come from a Yahoo store. I remember that you could default and then hide a number of item variables that would remain the same for your typical item use. I always liked that feature. It made for a clean interface. You could also easily override something that you previously "defaulted & hide" when a unique…

で How to set default value for standard field Tom Daltonによるコメント Aug 28, 2010 2:45AM

The most important effect of this setting is if you are sourcing in information using the sourcing and filtering tab. If it is checked, that information will be sourced in once and will "stick" to whatever was initially saved. If unchecked, the sourcing will happen each time the record is viewed or edited so the…

で Impack of Store Value Tom Daltonによるコメント Feb 21, 2013 1:27PM

I don't mind loosing the data. The data is not unique. It is extrapolated via formula from other fields that will not be erased. I just want to refresh the contents to equal the current results of our formula. My bigger question is... if we have a default value (via formula) for this custom item field ..is the defalut ONLT…

で Impack of Store Value Tom Daltonによるコメント Feb 21, 2013 3:47PM

I suppose the same holds true when a field can't be found when creating a custom report and it isn't found because it is named something different that what it is called elsewhere. I'm not smart enough to understand what you mean, but neither is your support person who couldn't help me with the "fulfillment number"…

で sourcing a field to them print as an embedded barcode Tom Daltonによるコメント Apr 30, 2008 12:51PM

Thanks for looking into that Evan. Any comment on the need for NetSuite to have such inconsistent variable names? These are all names for the Item Fulfillment Transaction Number... 1. When you go to edit a standard "Item fulfillment form", it is called "Ref. No." 2. Click the help for "Ref. No.", NetSuite calls it the…

で sourcing a field to them print as an embedded barcode Tom Daltonによるコメント Apr 28, 2008 10:22PM

Why does it have to be that way? If they have to change the name because of some limitation in the database, then I wish they would keep it the same NAME and just and a number on the end. T

で sourcing a field to them print as an embedded barcode Tom Daltonによるコメント Apr 24, 2008 1:51PM

Evan, your support person wasn't aware of that one (after a hour of WebEx). It also doesn't show up in the pull-down list of available elements. It worked when I copied and pasted "{shipid}" into the element. What is "{shipid}" called in the list of elements that you can click on? It isn't titled "Shipping ID" or ""Ship…

で sourcing a field to them print as an embedded barcode Tom Daltonによるコメント Apr 22, 2008 11:03PM

I solved this one. I was tricked by NetSuite's constantly changing field names. I was looking to add the "Fulfillment Number" or "Fulfillment Reference number" as a custom barcode element to our Packing slips. Well, the field was simply called "Ref No" in the long list of available fields. The proceeding word "Fulfillment"…

で sourcing a field to them print as an embedded barcode Tom Daltonによるコメント Apr 21, 2008 3:54PM

Tom Dalton · Owner · Gold Medal

コメント