Yes, 100% correct. If only there were a way to be able to search on that field, it would be even better. Since it is not storing any value, etc, you can't add it to a saved search result. We wanted to see this information in other searches as well as other information - for example, item on order as opposed to item on…

The sublist we have thus far is actually comprised of but one field that shows: Red, Yellow, Green The search is based on what we determine to be good, ok or low stock on items, and we then insert an html element <img src=".........."/> where we predetermine based on the above calculation that we show green, red or yellow…

Thanks It is a good idea Something else we thought of is before load figuring out the stock level and usage, then displaying green, yellow or red...

So, there's no other way besides sublists? It is a workaround, but there's no way to just stick one field on there instead of creating a sublist to accomplish this? Let's say one wanted to display a sublist of transaction history, or the pricing, or any other sublist - we would not be able to display the availability…

I think that Netsute is planning on upgrading the customer/contract pricing module, but as of now you will probably have to create your own via scripts. As far as I know...

Well, that's reassuring!

Thanks, Evan! You are sure on top of the community... is that where most of your time is spent??

Administrator - does that make a difference?

No, I am not expecting it to show it on existing transactions - on new transactions only, I want to basically show the created by field as the current user. It is not populating, not sure why... I am thinking of changing this field to free form text anyway, but this still bothers me...

This is a very useful post. However, is this field available on Item Fulfillments? The truth is, I am looking for an easy way to compare the # of lines on a Pick Ticket and the # of items on the fulfillment. The workaround was to display the total number of lines, but I get an ERROR: Field Not Found on the fulfillment. We…

Rand(seed)? I'll try that out and let you know what I come across. . . I had wanted to do something like this for quite some time now; since the data is exported to CSV/Excel files, this would let you create formulas for use in Excel, and as long as you have the row number you can reference other data in that row! I'll let…

Olivier, Isn't there a way to randomly generate sequential numbers in a formula of some sort? That gets around some of the issues you mentioned. . . For example, an autonumber/I forget the syntax - in SQL Server. . . and I never knew the syntax for Oracle.

Thanks, Evan - looking forward to the release! The good news is that there is the temporary workaround, which seems to do the trick for now... (adding a simple "Or" to the CASE). -E

Evan, Thanks for the response. I get the following in the results of the search now: ERROR: Invalid Expression I even added a formula (text) in the results tab of the search, and set the formula equal to: {field.id} Same error, though.

I even added a formula (text) in the results tab of the search, and set the formula equal to: {field.id} Same error, though. Actually, that was a mistake. I had put the wrong field in the results. However, the search is still not working as expected when simply adding that Custom Item Field to the results. . .

Yes, that works fine (I had made a mistake with the field I was referencing). However, I have something a bit more complicated: Field1 = Checkbox, representing a T/F value that will drive several other fields for various uses on the item. Field2 = Free-form-text, which stores no value and looks at the Field1 value and…

I was able to pinpoint the cause for such behavior. Basically, the value stored in the Checkbox field yields different results depending on whether you are viewing the item itself or in a result set. I created a free-text formula field on the item, and set the value equal to the Checkbox field value: {custitem_field} On…

The above worked for me, but the formatting of the page was a bit funky. You can try the following as well: document.getElementById("pricinglnk").style.display = "none";

I've been using it and it's working nice so far. I'm running into an issue though. Whenever I try to print to a sales order that has been attached to a project record, I'm getting the error "Problem saving template: The entity name must immediately follow the '&' in the entity reference." when it prints out. When I print a…

I do the same thing in Suitelets, except there is a built-in helper method for that, FYI. It is called nlapiEscapeXML(string). If you try your way, what happens if there are other special characters? You'd have to think of all possible characters to replace, and continually replace or run a routine that does it. Instead,…

Also, I didn't realize that function existed until I was done :o That's the same time I came across it!

We are getting this error... but in the sandbox for the very same record we aren't... ??? Correction: We did notice just now that there is a difference in the records (from Production to Sandbox account). The Production version, which is receiving the error, does have an ampersand (&) in one of the description fields in…

Gotcha. Funny, the other day I was building a search using the GUI and I ended up seeing two records / results for the item I was testing with, one with the real count for the Inventory Location and one null. But, I didn't save that search and now when I went back to it, it works as expected. I guess I can write the search…

Brett, Thanks. I am actually looking to do something on a custom record within Netsuite, but can't seem to pull the current location available for a particular warehouse. How would I get at that information? via SuiteScript? I don't see an API for this like there is for the pricing matrix. And to be honest, I was even…

What about saved searches and calls to look up inventory counts based on location? ie Is there any way to build an accurate saved search displaying location available quantities? If so, then you just have to use the Search APIs to pull up the desired info...

Great news, good job. You should probably post your code for the sake of others who stumble upon this...

Yes, I think you should change this call to not reference the name of the field: "getValue" mysublist.setLineItemValue('formulanumeric',p,searchresult.getValue('formulanumeric'));

Looks like it is just in the last three addField calls. You can't add three fields that are all named the same (even though the error doesn't quite state that(: list.addField('formulanumeric','text', 'Bins A-M'); list.addField('formulanumeric', 'text','Bins Q-T'); list.addField('formulanumeric', 'text','XDOCK');

I second what Olivier wrote, especially given the changes that are happening this year with 2014.2 - major changes to UI, which could very possibly break any DOM or similar calls (like this one)... so, I'd be careful and look into a redesign. I didn't get the details on what you are trying to accomplish, but perhaps…

Actually, it looks like it was a timeout issue, just it wasn't alerting me to it. I am not sure why it wasn't caught in the script, but I removed everything and ran just the search itself in the Debugger, and it timed out. Fixed the search to run quicker, and it now works. Thanks!