Dext3r Bronze Trophy

The Default Text Field Filter needs to be 'Has Keywords', not 'Contains'. At least, that' what worked for me.

I dunno if this is possible with the default fields. I think you would need to build your own field that references and links to the contact list so you have more control over the data type.

Ok, it looks like it might also depend on if the the field is custom or not. Could be something else but here's what I achieved: I was originally testing this on Driver which is a custom Text field to no avail. I only managed to get it to work on Document Number/ID which I'm pretty sure is also a Text field but not custom.…

Mm.. yea I can't figure it out either. Apparently a prerequisite is that you need to set the filter to be a 'Contains' type, but I tested this and still couldn't get it to work.

My first instinct would be to try , or OR or AND as separators instead of |. This Stack Overflow thread also suggests it should be a comma. I otherwise do not have a definite answer for you. What SuiteAnswer were you looking at?

I dunno, from the way the checkbox setting reads it does seem to just be one option or the other. If you submit the return with -Empty- does that constitute as a No? But yea, certainly looks like room for improvement for this on NetSuite's side. It shouldn't be a list value, it should be a checkbox. And the setting should…

Thanks Angela, I'll give it some further thought. Glad to know there isn't anything glaringly obvious about my workflows being incorrect in some way.

Hey Angela, I'm not sure your approach suits my use case, or otherwise I'm not sure I understand your idea. To clarify, what I'm looking for are changes to the customer records item pricing. For when prices here are removed, which ones, hopefully why and by who.

Thank you both. Yea, if the system notes of a customer record already don't show item price changes, then would a System Note Search be able to yield different results? I'm already stuck in that Customer doesn't appear to be an available Record Type criterion in a System Note Search

Thanks both, just came back from a long weekend. I'm going to attempt scripting and let you know if I have any success. The Preferences of the User Role are good but lack a lot of the options, even Language doesn't appear to be an available option.

Changing the users Language settings from English (International) to English (U.K) has solved the issue. To apply this to all users without having them change their language settings, I have to reset the labels of my fields for one language, then change my language settings and do it again. So irritating...

Oops, I feel like I've asked this before. 'Ship Via' is the correct field. Perhaps I changed the label from 'Ship Via' to 'Shipping Method' at some point.

It's been a while since I used a One World account, but I hope this helps you. From my understanding, an intercompany transaction would have the Subsidiary as Subsidiary A and the customer would be a customer record representing Subsidiary B, is that right? In which case, you could use a numerical formula criterion like…

B 😊

Hiya, I'm not familiar with this field. Is it simply a checkbox? I'd start by including intercompany as one of your results and letting us know what results that returns. Chances are that since you haven't set Main Line to False as a criterion that intercompany is appearing on lines and not being handled properly. We could…

Thanks Richard, that helps clarify my understanding.

Thanks Jervin. Just gotta be extra careful then. 😅

Solved! There is an undocumented option you can use for submitFields() called disableTriggers record.submitFields({ type: so.type, id: so.id, values, options: { enableSourcing: false, ignoreMandatoryFields: true, disableTriggers: true } });

Hi Jervin, this is for future use cases. Is there a guide somewhere on how to use nlapiYieldScript?

Hiya, I believe you can do this by setting a criterion of 'Applied to Transaction' is 'Empty' And of course it also needs to be a Transaction type search with a Type criterion of is Journal.

This SuiteAnswer lead me to the answer. Creating Inventory Adjustments via SuiteScript Returns Unexpected Error One possible cause for this is because there are customizations that is trying to set the main body Location field on the Inventory Adjustment. The body location field on the Inventory Adjustment record…

Never mind, she just had the field group minimized. 😂 Since it was the last field group in the subtab, and the fields below it hadn't been assigned to a field group, it made it look like the fields had disappeared, not that the field group was minimized.

Thanks both, sorry for the late reply, just got back from holiday. I appreciate your suggestions and will work on scripting this functionality.

Thank you Todd, appreciate the insight. I'll still be taking answers if other people would like to contribute.

Thanks Alex, doing so did not reveal a NetSuite 360 role option on my employee record roles, but it did give me access into the NetSuite 360 dashboard through the support page that was my main goal.

Thanks Alex.

False statement, I can actually edit the Inline HTML fields with a Client Script. So now on a fieldChanged function and if the field is entity I do the following: try { var specialInstructions = currentRecord.getValue({ fieldId: 'custbody_special_instructions' }); if (specialInstructions) { var html1 = '<div…

Thanks Trixie. Yea I think it's similar that in my case because it was outsourced I just need to close the Purchase Order instead. Frustrating there doesn't seem to be a direct way to edit the quantity. Thanks for the additional info.

Thanks Jervin, it means a lot to know you think my approach is correct. Unfortunately I don't have much way to reduce the number of operations. Generally it is unlikely to be editing the same record at the same time, these updates come in large batches where moving 1 task in the route order then affects 20 other orders in…

Dumb workaround = CASE WHEN LENGTH({custbody5}) > 0 THEN '<div style="background-color:yellow; color:black; font-weight:bold;">' || {custbody5} || '</div>' ELSE 'Empty' END