Tom Dalton · Owner · Gold Medal

the idea is to delete the min/max values in the location in question. Leaving it at "0" will have it auto calculating again. We set it to ZERO and we also tried deleting (or setting to Null) as you suggested. in either case, it recalculated the need for more items at the old location. Turning off auto-calculations for…

same issue here...we disabled a location completely and we can see the min/max levels are still seeing the values from the inactive location. A lot of manual work to zero them out. We found we had to delete any entry in the min/max (not just zero) because if you uncheck the auto min/max boxes and then come back later and…

I feel your pain. The "Auto-calculate reorder point" feature also doesn't do anything to help our business because of another NS inventory bug. We moved a bunch of our inventory, but NS has no way of recognizing the move. We aren't closing the old location, we just don't want to stock a particular group of items at that…

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…

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

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.

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

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

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

Thank You!

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.

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

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

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…

No, we didn't.

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…

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')

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

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…

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

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

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

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

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

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…

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…

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…

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…

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"…

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…