I was thinking the same also but when investigating the Dept field on the Employee record, the Field ID = department (and the same for Location & Class respectively); not "custentity_".

Defect #206795 for those interested.

Case #1571551 has been submitted to NetSuite Support.

Support response: "use {systemnotes.name} to display Set By"

Mike - I am curious to know after you installed the SuiteBundle, how it worked and whether you encountered any issues along the way? I am looking for the same functionality from your initial post. Thanks in advance for any feedback!

Good point khultquist. However we will want to refer to the transaction on a saved search, displaying the "modified internal id". Therefore if 'store value' = F then we lose search result visibility. I hope by scripting the "modified internal id" field I will then have the ability to reference this field for future…

Hi brettg, Let's say your preffix is SO- : function afterSubmit(){ var rec = nlapiGetNewRecord(); var rec_id = rec.getId(); var rec_customid = "SO-" + rec_id ; var rec_type = rec.getRecordType(); nlapiSubmitField(rec_type,rec_id,'custbody_alt_tra n_num',rec_customid); } Cheers This worked perfectly. Thank you Felix!!

I created a custom free-form test field (to match my "modified internal id" field type) with 'store value' = F and am unable to select this test field within the search criteria and cannot select the field to display within the results. Even calling the field via Formula (text) doesn't work either. This may be incorrect…

Evan - Were you ever able to figure this out? I have the same question and also could not find the solution within the NetSuitePermissionsUsage 13.2 or the Help Center.

Thanks for the reply Oz. The tag is a custom field: <NLCUSTBODY_ACVT_SO_DELAY_REASON_CODE> The field is a multi-select field with 5 list options. The custom list that populates this field have internal id's 1 through 5. When the email is generated, only the internal id(s) 1 through 5 display.

Update to previous posts: When emailing directly from the transaction using the email template, the CRMSDK tag referenced in the template populates the value(s) of the custom field as expected. However, if the email is generated via Workflow (triggered by a scheduled mass update) then the value populated within the email…

Case #1571544 has been filed to NetSuite Support.

This option is very helpful however it only is taking into consideration the Amount Remaining on an Invoice and does not tie-out with the A/R Aging Report. How could I incorporate Payment transaction types (unapplied) that are included within the standard A/R Aging report? If I am able to set the criteria to include the…

Thanks Evan, I appreciate your response. This worked however if a customer did not have any invoices within the last 12 months then that customer record obviously does not show on the search results. I am trying to display a list of all active customers and their last 12 months of revenue, even if it is 0. My approach now…

This appears to still be a problem, and especially with OpenAir integration where through the OA integration manager we are unable to generate invoices because the due date is being set to 'blank'. I have logged a defect case (1621871) and referenced Steve's case (1620728).

Hi Jennifer - We will be starting our trial with FLODocs in our Sandbox account this September. Although we do not use Matrix item types I have the same curiosities as you. Our immediate focus will be to use FLODocs to document customizations and assist with account management and account clean up with a future goal of…

Thanks for the reply Daniel. I have created a workflow with the Record Type = Item, Sub-Types = All (I have selected all values). The Event Definition is On Create and On Update, in Testing status, Trigger Type = All, w/ logging enabled. State 1 of my workflow displays a button on the item record. When clicked, the…

Daniel - I opened case # 2035721, hoping that I can get this resolved.

For those interested, support responded stating that the workflow action Set Display Type is not applicable to Custom Help Field because this type of field has inline text display by default.

Evan - thanks for the reply. My workflow is triggered by a Saved Seach, and the Workflow itself is setup with the following criteria: -Record Type = Transition -Sub-type = Sales Order -Release Status = Testing (sandbox) -Initiation = Event Based; On Update -Trigger Type = All -Condition = Saved Search --Saved Search…

Still no luck, so I must be missing something. I currently have the Action trigger type set at Before User Submit, but I also tested the only other selection of Before Field Edit with the Client Field set (for individual tests) at 'Approval Status' then 'Approved'. The Event Type (assuming for the Main Workflow Definition)…