Well, I found I can write into the inline HTML field with nlapiSetFieldValue and it will be displayed, but only if the default value of the inline HTML field was not empty. For example, if it contain a "-". But, this doesn't help because it won't store the value of an inline HTML field and the script won't run unless the…

Insert an inline HTML field with the "HOLD" content, then show/hide in a user event script based on the customer credit hold. Ok.. so how would one show/hide the field ? Or better yet, how would one write content into the inline html field?

Hi. I have a slightly different question, but I decided to post it here because the issues are related. I have a client script running in a sales order form that detects whether the customer is on credit hold, and changes the form to an "on-hold" form. This works fine, but the problem I have is that when I change the form,…

Does this approach apply when trying to stop triggers from running when the context is a RESTlet?

Just ran into this problem in one of my RESTlets... Have there been any changes that would help me in the three years since the original question?

having the same problem. Where does that "_case" come from in ecaceres' message?

Indeed. But the line Evan gave (3 1/2 years ago) will not, in fact, work. I want to detect whether the customer is on hold in a client script running in a sales order form, and then take actions based on that. I've been experimenting and it appears that I have to retrieve three fields from the customer record:…

Can someone clarify for me ? As far as I can see there is no field you can return called "oncredithold". There is a filter called that, but there is no field. Check for yourself. https://system.netsuite.com/help/helpcenter/en_US/RecordsBrowser/2009_2/records/customer.html

necro-posting but what if you want to add a line item at the end ?

Ok, I finally figured it out. Thanks!

Five years later they haven't bothered to do this. A conspiracy theorist would have to suspect they leave all these gaping holes in an effort to get more professional services contracts for data conversion. For what it's worth, it's possible with web services. I wrote a couple of (crude) command-line php scripts to do…

Attention Moderators! What about an EDI subforum?

We're doing EDI with major retail chains - we were SPS Commerce customers but have switched to B2B Gateway, and it's been an improvement.

Still using B2BGateway.net.. it works!

Hi. This message is directed to Jeff Grogan. I'm responding to your several-years-old message about EDI and SPS Commerce. We're also using SPS Commerce to receive EDI orders from our Retail customers, and have had the same problems with the cross-reference tables. What's happened in the years since then?

I was directed by support to turn off the work orders feature (which doesn't have any dependent features) and then turn it back on. Voila: all the missing non-posting accounts, including the Sales Orders account, were re-created. There's a defect report on this somewhere, they say.

Resurrecting another Ancient of Days thread here. I too am forced to run the "delete all" in a test sandbox so I can test importing data. I created (in my DEV instance) a bundle of all my customizations as well as a configuration bundle and then did the delete all operation, followed by installing the config bundle,…

This isn't static information - I will be both reading and writing and need to know at all times how current the information is. Is it really not going to be usable at all?

It does seem to be wasting a lot of time updating the WSDL thing.. I will investigate updating the WSDL-related parameters in php.ini as Lorne suggested. My "hu" is a wrapper class for one of my custom records. [CODE]root@heron:/var/www/netsuite/rolls# more getHu.php <?php require_once '../PHPToolkit/NetSuiteService.php';…

So with Lorne's help I got the search by external ID working. (see the next thread) To this I added a piece of SuiteScript that runs whenever one of these records is created: function userEventAfterSubmit(type){ var huIId = nlapiGetRecordId(); var huRec = nlapiLoadRecord('customrecord_sea_hunit', huIId); var huId =…

Thanks for the pointers... this is what finally worked for this list/record field: [CODE]function __construct($service, $zone = '0') { $this->service = $service; $custSearchField = new SearchMultiSelectCustomField(); $custSearchField->internalId = "custrecord_sea_hunit_zone"; $custSearchField->operator = "anyOf";…

You are correct!

Will do! Many thanks.

So far it looks like they're just firming up their "sorry it doesn't work". While they're finishing this up I"m starting to think about a workaround. I think I could attach a tiny script to the custom record that just copies the id to the external id. Then if I can just figure out how to search by the external id I'll have…

not really getting anywhere with my case... they couldn't find the attachments I made to the case until I filed another case complaining of that and now won't respect my request to communicate by email

This is pretty backwards, I think you'll agree. The ID is supposed to be the "Primary Key", the primary means of looking up the the record. How is it that I can't search by it? I already logged a case. I'm thinking if I could get it to keep the customRecordId in the external ID I could use that. Anyone know an easy way to…

Thanks, that's good to know.

That did the trick. I thought I'd tried every permutation. It's really important for me to know where this is documented.

A bit of a late followup here, but I have a saved location search that just returns the "name no hierarchy" for each location. When I run this through SuiteTalk (with PHP toolkit 2012.2) I get a ton more fields that I don't want. Is there any way to get just the columns I want ? I'm trying to cut down on how much data is…

That doesn't work well with PDF output. So I guess the answer is no, there is absolutely no rational way to report on any entity in Netsuite ? I'm going to have a real hard time selling this to people who've been using a real accounting system for decades.