Tom Dalton · Owner · Silver Medal

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…

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

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…

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

In 2008.1 you can set the font on a custom element to "Bar Code". Is it now possible to add a corresponding barcoded Fulfillment Record ID Number to a "Packing Slip" or to a "Picking Ticket"? It would show if the fulfillment record exists and it would just be blank if one doesn't exist. I realize that many people don't…

I thought I solved it becasue it previewed on the PDF form, but it didn't show on an actual packing slip form. It isn't possible to add the barcoded "Item Fulfillment Transaction Number" to a packing slip in NetSuite. I spent over a hour on the phone with NetSuite and they couldn't figure out a way to make this work. We…

The bar code # is always related to the transaction you're printing. In the case of a picking ticket, the form is based on the sales order so that is the # that is bar coded. OK, but there's more than one record that is related to a sales orders and there's more than one record that is related to a picking ticket. So, can…

So, the problem is that the fulfillment doesn’t exist ?!? ...or is the problem that changing what record type is referenced in a barecode isn't possible? I don't see the missing fulfillment record as a problem. If we told it to print the PDF pick ticket and the fulfillment record didn't exist ...it would put <null> at the…

OK, Elham. Forget my specific request. Assuming that both records exist. Can which record is barcoded on forms be specified or are we stuck with the defaults? -Tom

Similarly, packing slips are based on item fulfillments so they display a bar code of the fulfillment transaction #. You say that the packing slips should have the fulfillment transaction number. Both our "pick tickets" and "packing slips" only have the SO number barcoded at the bottom. In 2008.1 you can set the font on a…