Robert Nedelkow-Oracle · Oracle NetSuite Community Manager · Admin

A similar topic was started here - https://usergroup.netsuite.com/users/forum/platform-areas/customization/custom-records/415108-record-is-parent-field-not-available-when-list-record-selected

This is possibly related to Defect 419500 Drop Ship Purchase Order > Customer with Default Ship To address > change Location > Ship To address changed to the Location address. Please contact Support to confirm and attach your case.

Defect 396034 was fixed and released on 5/28/2016.

You can create multiple layers of dependencies using custom records as well. See this SuiteAnswer for an example - https://netsuite.custhelp.com/app/answers/detail/a_id/10093/kw/dependent%20fields

Pessimistic Locking or preventing users from editing a record at the same time is currently an Enhancement Request. You can vote for 96103 in SuiteIdeas or submit an online case to be attached to it. There is a scripted solution documented in SuiteAnswers Answer Id: 25466 -…

An example for online case forms is provided in SuiteAnswers Answer Id: 11043 - https://netsuite.custhelp.com/app/answers/detail/a_id/11043/kw/upload%20file%20form

You could append the extension to the number as (123) 456-7890 x123 or create a separate custom field for it.

SuiteAnswers Answer Id: 21482 provides detailed steps to display the Item Image URL on Transaction Columns. There are a few related answers on the topic here: https://netsuite.custhelp.com/app/answers/detail/a_id/21482/kw/Display%20Item%20Image%20URL%20on%20Transaction%20Columns

Require Custom Record Entries Permission: Controlled by the access level set for Custom Record Entries permission under Permissions tab > Lists subtab of the user's role. Use Permission List: Controlled by the access level set on either the user's role Permissions tab > Custom Record subtab or the Custom record definition…

You as the field owner will always have permission to add new records.

It should work with the "location." prefix as in {location.quantityonorder}. You'll need to add the prefix to all the fields in your formula.

A few things will determine when a field is inline editable like the field’s display type or whether it's hidden on the preferred form. See SuiteAnswers Answer Id: 35598 and 11844 for details.

Can you try {locationquantityonorder} and {locationquantityavailable} instead?

This is controlled by the roles's List permissions. Try adding or removing the following: [LIST] [*]Letter Messages [*]PDF Messages [*]Track Messages [/LIST] If you're adding these permissions, set the Access Level to at least Create.

You could copy the form's url and display it as a shortcut.

This should be possible using the steps in SuiteAnswers Answer Id: 35064. You could create a custom sublist using a search with filter: Type is Invoice and display only transactions linked to the customer record being viewed.

Transaction column fields can apply to Store Items, Sales Items, Purchase Items etc. I'm not sure if this applies to your use case but here's the complete solution: A. Custom Transaction Column Field to source item base price 1. Customization > Lists, Records & Fields > Transaction Column Fields > New 2. Provide a name,…

Something like this should work with free form text - {custitem3} || ' : text'

You could try something like this in your formula: Replace({fieldid},'Francais','')

I wasn't able to get the item base price using {item.baseprice}. You should be able to source the item base price into a custom field using a formula. See SuiteAnswer Answer Id: 38678 for an example.

Enhancement 291005 Transaction Column field > Ability to use Item Base Price in formula was created for this.

Double pipes are used to concatenate a string value in the formula. You'll need to make sure the formula box is checked on the custom field.

Try inserting this tag in the body section of the template:

It looks like this is related to the Advanced Projects feature being enabled. The solution in Defect 299737 was to use a different custom form (e.g. Project Overview Form), Standard Project Form or customize a new Project Form. I would file a case to confirm whether this is related and to receive any updates.

Corey, do you have the Advanced Projects feature enabled?

I just turned on the 3rd Party Billing feature and manually entered the 3rd Party Billing Account Number as 123456789 on the customer record. When I created a sales order from that customer record, the custom body field pulled the 3rd Party Acct # as expected. Customer: [ATTACH=CONFIG]n308417[/ATTACH] Sales Order:…

SuiteAnswers Answer Id: 15058 includes a similar use case and example using WorkFlows titled "Setting Fields Dynamically Using Conditional FieldTriggers."

This worked for me. Does your custom body field look like this? [ATTACH=CONFIG]n308412[/ATTACH]

The following solution is from SuiteAnswers Answer Id: 35501: To source the 3rd Party Billing Account Number: [LIST=1] [*]Navigate to Setup > Customization > Transaction Body Fields > New. [*]Type = Free Form Text [*]Store Value = False [*]Applies To = Sale [*]Under Validation & Defaulting tab: [/LIST] Default Value =…

Hi Robert, It doesn't look like this is currently possible. We are tracking this request in Enhancement 190172: Transactions > Sales > Bill Sales Orders : Hide 'Credit Card Approved' box in the Bill Sales Orders screen.