SWSearcy Blue Ribbon

Is there anyway to augment the dataset to include this standard field?

Thank you Red. I would be happy to have the field displayed just not editable. However, I've tried versions of the form with Name/ID set to Disabled or Inline Text, and in both cases the field remains editable. Is that expected?

Thank you @Tigran Shahnazaryan . Based on your comment, I assume that just using the form and role settings can't get the desired result. I may look into the workflow option but want to keep the solution simple and not add complexity where it shouldn't be needed.

Thank you Francesca. I don't need an answer, I was just trying to pass along something I learned from a case with NetSuite Support regarding differences in system behavior when using a custom transaction link field and a native transaction link field. Is there a better method for posting helpful information for others?

There is a known issue when using TO_DATE on some Free-Form Text type fields, but that issue was closed by NetSuite Engineering as a "fact of life". It was originally encountered with the following formula: TO_DATE(CONCAT('01', SUBSTR({custom field ID}, -9)), 'DD Mon YYYY'). I guess closing it as a "fact of life" simply…

Thanks @Angelica Mae Segador-Oracle. I submitted a support case this morning and will provide an update on what is found.

Thank you @Tigran Shahnazaryan. I'll reach out to NetSuite support.

That did not work. I also tried that with Formula (Text) which is what I would expect should be used with a TO_CHAR() formula. This boils down to something very simple. I've confirmed the contents of the field and created a literal string that exactly matches those contents, as proven by a formula comparing the field with…

Angelica, Tigran's response does not address the problem. For some unknown reason, I cannot use the custom field in the TO_DATE() function, even though (1) it can be used in other functions, and (2) the TO_DATE() function works if the custom field is replaced with a literal string that exactly matches the contents of the…

Thanks Tigran. Formula (Text) with TO_DATE({custrecord_ctc_cw_contacts_lastupdated}, 'YYYY-MM-DD"T"HH24:MI:SS"Z"') also generates and error, but Formula (Text) with TO_DATE('2023-04-13T22:04:12Z', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') does not.

Yes. That was in the original post. Here is a summary of all of the formula tests done and the results. 1 - Reference to the field 2 - Reference using the field id 3 - Shows that the field value is equal to the literal string '2023-04-13T22:04:12Z' 4 - Shows that the TO_DATE() call with the literal string and format works…

Yes, I attempted the formula you provided as Formula(Text) because the outermost function was TO_CHAR(). Since that didn't work, it was necessary to figure out if the issue was with the inner portion of the formula. That's why I tried the different variations of TO_DATE() in my last comment as Formula(Date/Time). Those…

Thank you @Tigran Shahnazaryan. That also generates an error, but I believe it's because TO_DATE() requires a format when the string is not in a local format. For example, here are the results using literal strings. TO_DATE('2023-04-13T22:04:12Z') —> error TO_DATE('2023-04-13') —> error TO_DATE('04-13-2023') —> 4/13/2023…

OK. You can close the post. Since NetSuite knows that a script file in our system uses the call, I was hoping it would be possible to find out which one it was without having to reach out to everyone.

Thank you Richard. Is there anyway to find out which bundle is using the API call?

Thank you Richard. I know none of our internally developed scripts use the call. I am wondering if there is a way to find out what 3rd party scripts that are parts of bundles that have been installed could be using the call. That code can't be viewed or inspected. NetSuite sent an email saying that scripts in our instance…

Thanks Michelle. It's still confusing what is preventing the emails since without first turning on Marketing Automation the employees have no Soft Opt-Out setting. At this point though it doesn't matter. I'll just be sure to check the Opt-Out Override as I did with this last email. You may close the ticket.

Good morning Michelle. I first went to Lists > Relationships > Groups and defined a dynamic group of employees. To send an email, I open the group and choose the Bulk Merge subtab. However, when I then click email, the list of recipients is empty. However, If I click the Opt-Out Override, the recipient list is correct,…

Marketing Automation is not enabled, but there is no mention that the Mail Merge feature requires Marketing Automation. I don't want to enable that feature until we choose to use it. So the question now is, what Employee field is preventing me from sending emails from NetSuite to Employees using Mail Merge without having…

Thank you Michelle. We don't have a Marketing tab on employee records. The lack of the {globalsubscriptionstatus} field was found by creating a Employee saved search with a Formula (Text) result field that simply references the {globalsubscriptionstatus} field in the formula. The search results contained "ERROR: Field Not…

The issue was with using the Script Debugger with a script entered in the New Script pane. I took the exact same code, created script and deployment records, ran the script and no errors occurred. I then used the Script Debugger with Debug Existing and that also worked. You can close the post.

Thank you Clarisa. I will vote on those. What I'm wondering though is what is causing the behavior? What is causing the difference in behavior of running the saved search vs. as the sublist view? Is there scripting that is processing the results of the search before it's presented in the sublist?

Thank you Richard. I should have looked in SuiteAnswers first. Hopefully the developer resolves the issue.

Grace, I only provided one screenshot of an entity entry form (the first screenshot) and it does not include any references to Main, Accounting, … I'm not sure what you are looking at. You can close the discussion. Thank you, Scott

Grace, My question was why can't I modify the sublist content under the Custom subtab for transaction records while I can for entity records. The two screenshots in the original email show the difference. The top screenshot is while editing an entity form and the bottom screenshot is while editing a transaction form.

Grace, I don't think this has anything to do with how the custom sublists are created. And, this is not a custom subtab. I believe this is a standard NetSuite subtab named "Custom". It is not listed in our list of custom subtabs. What's interesting is that this Custom subtab is where sublists appear if they have no Tab…

I'm sorry to be a bit confused. Maybe the issue is with the word Custom. In our case, we have a subtab named "Custom". Here's where it exists on an invoice form. It currently has some screen fields and (2) sublist under it. However, when I go to customize the form, the "Custom" does not appear in the list of subtabs under…

Thank you Grace. The issue is that while editing any kind of transaction form, the Sublist subtab does not include Custom as a subtab. That is what the second screenshot was intended to show. If you are asking how many Screen Fields are displayed under the Custom subtab, that depends on the form.

Thanks again Richard. Providing a screenshot isn't going to help in this situation. The API vendor has since confirmed they don't recognize X-HTTP-Method-Override:PATCH in the header. For updating specific fields in records, they expect requests to be sent with the PATCH method. So, until the HTTP and HTTPS modules support…

That is the workaround I tried, but unfortunately the API I am trying to call doesn't recognize the X-HTTP-Method-Override:PATCH in the header. Instead, they expect the API request to be made directly with the PATCH method. The information in the Body is structured differently for PUT and PATCH methods. When I call the API…