User_KC8S1

We have a similar search requests - surely others do? We wish to find all those not having completed a survey record (custom record), so we can send them a reminder email. In another situation, we want to email all those not having read an email (part of a campaign) - this search too does not appear to work. Any help? CRM…

in Search for lack of child records Comment by User_KC8S1 Apr 7, 2008 6:12PM

I was curious so I tried to replicate this and was unable. Here's what I did: [LIST=1] [*]Added a Currency field to a custom record ("Currency 1") [*]Added another Currency field to a custom record ("Currency 2") [*]Added a third Currency field, cleared store value and used the formula {custrecord17}/{custrecord18} [/LIST]…

in Percent formula Field for CoGS Comment by User_KC8S1 May 24, 2011 11:33PM

Changed to Percentage and it still works as expected. I added a new Item field to test your exact situation and indeed it throws an error when pricelevel1 is >= 1000 I dumbed it down to a free-form text field and only included the {pricelevel1} tag and it still resulted in a INVALID EXPRESSION. This is no doubt a NetSuite…

in Percent formula Field for CoGS Comment by User_KC8S1 May 26, 2011 12:40PM

Angela... Is that you??

in Adding field to customer page Comment by User_KC8S1 Jan 22, 2011 4:35AM

We present data like this all over our account, across 20+ custom record types. The solution used for ALL of them is to deploy a UE BeforeLoad script and set the value. The field you are setting needs to have the "Store Value" UN-checked for this to work.

in Add Entity field to Customer record for count of subcustomers Comment by User_KC8S1 Dec 29, 2010 12:44PM

You should be able to deploy a client script to the fulfillment that would clear the qty fields on initialization. I don't believe there is a way to accomplish what you want without using script. SuiteFlow would be nice (although overkill for this) but it doesn't operate on sublists at this time.

in Fulfillment Form Comment by User_KC8S1 Nov 16, 2010 9:39AM

Use the tag: <NLID>

in Cant seem to find the ID field on a custom record to pull it into an email? Comment by User_KC8S1 Nov 16, 2010 9:36AM

So I have a role that can't edit anything on the vendor form. Is there a way to add a field that they can edit without giving them access to edit anything else on the form? Do they not have access because they have a View permissions for the Vendor record or can they not edit because you have created a custom form with…

in Edit only one field Comment by User_KC8S1 Oct 20, 2010 12:44AM

Alright, it appears that formulas are not evaluated when fields change. This actually isn't surprising now that I think about it. I think you will need to do this with a client script. It would be a very simple script to do.

in SQL statement for adding two fields using Formula Comment by User_KC8S1 Oct 14, 2010 12:55AM

Have you cleared the "Store Value" option on the custom column field? If not, clear it and try again.

in SQL statement for adding two fields using Formula Comment by User_KC8S1 Oct 13, 2010 9:01PM

From support: I did further testing using the settings you provided and verified that the requirement that you need is not possible given the current settings that we have in the system. We cannot source the fields of the record types you selected from Field A into a list in Field B If this is indeed the end of the story…

in List/Record(Field) field filtered by List/Record(Record Type) field Comment by User_KC8S1 Sep 27, 2010 11:35PM

Hi Banjamin, Thanks for the suggestion and code example! I had thought about dynamically building the child (field) list but wasn't sure if that was possible when list editing? The record that I'm trying to design (which is part of a bigger system I'm considering developing) would be edited in a sublist on a parent record.…

in List/Record(Field) field filtered by List/Record(Record Type) field Comment by User_KC8S1 Sep 28, 2010 2:37AM

It's because you are the Owner (I'm assuming) of the Custom List. When you are the owner regular permissions do not apply. Test with another user account or you can try clearing the Owner field.

in How to remove the "Plus" sign for a Custom Field (List) Comment by User_KC8S1 Dec 29, 2010 12:42PM

I'm not sure of the square brackets are actually in the formula but if they are that's no bueno. Try: CASE WHEN {quantity}-{custcolshipped}>0 THEN {quantity}-{custcolshipped} WHEN {quantity}-{custcolshipped}<=0 THEN “Completed” ELSE “Error” END Also, looks like you are mixing numbers and text which is fine if the…

in Formula For a Custom Field on an Estimate Transaction Comment by User_KC8S1 Feb 19, 2010 8:24PM

If you find that you still need to render a custom element using the BFO library you can use an existing PDF as a BG and then render over it. So you could use an Estimate "shell" as a BG, then render your data elements as well as the signature or whatever. It's still hacky but may be more attractive then generating the…

in How do I add a signature field to an estimate? Comment by User_KC8S1 Feb 12, 2010 1:56AM

OK guys, I'm feeling kind of stupid now, I think we need to destroy my response!!

in How Do I Create a Custom Field for CRM Task ID? Comment by User_KC8S1 Jul 13, 2009 1:31PM

No, it works but it's like using a sledgehammer to crack a nut :p

in How Do I Create a Custom Field for CRM Task ID? Comment by User_KC8S1 Jul 13, 2009 1:49PM

Any ideas on how to achieve this with the current system? I assume from your post that a non-saved formula field can't pull the internal id. If not, if that IS possible that would of course be better than a script solution. If no other way is possible then the following script will render the Id on the record. var…

in How Do I Create a Custom Field for CRM Task ID? Comment by User_KC8S1 Jul 6, 2009 8:56AM

The <%= %> syntax is used in web store templates in certion very specific ways (to call getAttribute(), e.g.). In the customized message body of email alerts, it can be used to embed SQL expressions within the text of the email alert, e.g. {name} has just entered a <%= case when {totalamount}>=1000 then 'large ' end…

in What is <%=%> called, where can we use and is it in the help? Comment by User_KC8S1 Jun 15, 2009 11:16AM

Hi Mathieu, I followed your suggestion and tried your expression in a transaction field and it worked. Encouraged, I then tried it (slightly modified) on my custom record and it ALSO worked! I then tried my original formula and it also worked. I really don't know what was happening, I know how to use the CASE statement and…

in What is <%=%> called, where can we use and is it in the help? Comment by User_KC8S1 Jun 15, 2009 10:47AM

OK, I learned that the <%=%> is not needed (good) I also learned that there wans't a problem with my formula, but rather that NetSuite just doesn't support some SQL functions in the formula field. It should, the help indicates that it should support CASE statements but it doesn't. It also doesn't support IF ELSE. Other Sql…

in What is <%=%> called, where can we use and is it in the help? Comment by User_KC8S1 Jun 12, 2009 12:31AM

While desperately seeking a counter point ( :p ) I realized that the formula is susceptible to breakage should 'NYC' be changed to 'New York City' or 'Buffalo', etc. The OP may want to consider using the handy new '.id' property of fields to do an id comparison instead of a string. DECODE({location.id},'3',1,0) ...that's…

in Formula-based Default Values for a 'Stored' Field Comment by User_KC8S1 May 27, 2009 12:39AM

The best I can suggest is two use both a stored and non-stored field, make the non-stored field hidden and copy it to the stored field in a before load script if type is create and the createdfrom field is not empty. Thanks, -e If you're going to script a solution why not ditch the formula and the 2-field solution and just…

in Formula-based Default Values for a 'Stored' Field Comment by User_KC8S1 May 22, 2009 10:56PM

Case has been entered, it's: 840124

in What am I supposed to do with this? Comment by User_KC8S1 Feb 13, 2009 11:33AM

If they are List/Record fields you could run a search for <field> noneof - None - (or whatever it is, basically "null") and that would turn up any late night test relationships you may have created and since forgotten about. ...that reminds me of high school! :rolleyes:

in Editing Custom Item Fields Comment by User_KC8S1 Oct 31, 2008 12:50AM

The inventory adjustment form columns are uncustomisable. You can click the customise button and it will let you make changes, but when you load the custom form it brings in all the default fields and none of the customised ones. I.E i tried removing some of the default columns, but they are still on the form when i load…

in Inventory Adjustment Form Uncustomisable Comment by User_KC8S1 Dec 12, 2008 8:07AM

Couple thoughts:[LIST] [*]What is the display type set to? (if it's not normal, make it normal and try it out) [*]What are the permissions for the custom field? 2008.2 brought a great new feature to allow us admins to set field-level permissions. I was surprised during my experimenting that unlike the rest of the…

in Custom Field Data eNTRY Comment by User_KC8S1 Oct 31, 2008 12:56AM

Yes, I think so... although it shouldn't matter IMO. The data should be loaded the same way for a merge as it for any other request. I have a record with 48 custom fields on it. I'm not kidding, the fields all represent fields on related records that I need for the merge. So I have all these fields then a nightmare script…

in Display date without year (ie birthday)? Comment by User_KC8S1 Nov 1, 2008 10:38PM

You can do a custom field (non-stored) with a formula to_char({custentity_birthday},'fmMonth DD'), substituting the id of your birthday custom field. Thanks, -e This is how I'd do it as well, but beware if you plan on merging this data into a letter merge (possibly even email or fax) it will not work. You will get a blank…

in Display date without year (ie birthday)? Comment by User_KC8S1 Oct 31, 2008 12:47AM

Hey- Is this the real code? If it is, there are many problems.... First of all, before I forget, for future reference use one of the "code formatting" options (I like PHP 'cause it uses colors) so that your code is easier to read. Here is a list of what I see wrong (quick scan): [LIST] [*]var…

in Linking two custom fields Comment by User_KC8S1 Nov 7, 2008 2:27AM

MFA for Oracle Community

User_KC8S1 Red Ribbon

Comments