Articles tagged #FIELD
Articles tagged
#FIELD
Missing Price Field in Generic Resource Page
Scenario
Solution
- Enable the Per-Employee Billing Rates Feature by navigating toSetup>Company>Enable Features
- ClickEmployeestab
- Time & Expenses:
- check the Per-Employee Billing Rates box
- ClickSave
Print Picking Ticket Status on Sales Order Changed from True to False
User wants to change thePrint Picking Ticket Statusunder theSystem InformationofSales Orderfrom T to F
Quantity-based Price Levels and Other Related Pricing Schedule fields are Not Available in Service Items for Sale and Resale
Quantity-based Price Levels and Other Related Pricing Schedule fields are not available in Service Items for Sale and Resale items.
Show the Internal ID and External ID of the Record in a Custom Field
The user needs to display the customer's Internal ID and External ID as fields on their customer forms.
Cannot Find the External ID on Chart of Accounts Record
The user is unable to locate the External ID of any Chart of Account.
Display Total Discount Field Using Advanced PDF if Amount Is Greater Than Zero
On the Advanced PDF/HTML templates of transaction records, the total discount amount is displayed using the variablerecord.discounttotal, but there are instances where the transactions do not have any discounts.
Round Off Custom Field to Nearest Hundredth
A user created a custom field that calculates a value to display the quotient between Quantity (standard line item field) and an Order Quantity (custom line field). However, it is rounding to infinity and they would like it to round to 2 decimal places.
Resolve Error: "INVALID_FLD_VALUE: You have entered an Invalid Field Value XX for the following field: custrecord_assetregister_src_asset"
Scenario
Solution
- Go toList>Search>Saved Searches>New
- ClickFAM Asset
- Search Title: Input title of your search
- Standard Tab>Filter> Search forInactive :clickYes,clickSet
- Results Tab: Make sure to check thatComponent Ofis added
- ClickSave & Run
In order to get rid of the error, you can inactivate the related component record, or you will have to activate the existing inactive component FAM record before running the report.
Script To Update Multi-Select Field on Save
The article applies to a very specific scenario, but it also demonstrates how to useSuiteScriptto set values on Multi-Select Fields in NetSuite.
Retrieve Values for Multi-Select Field Being Return by nlapiLookupField
Using nlapiLoadRecord then nlobjRecord.getFieldTexts function to retrieve multi-select field selected values will return an array. However this is not the case when you try to retrieve values using nlapiLookupField as it will return String values.
Transfer Values from a Multiselect Field to Another Custom Multi Select Field via Script
To be able to transfer values from a field to another field via script.
Retrieve Values from a Multi-Select Field via Scripting
If multi-select custom field exists on a sales order, the values should be retrieved that are present on an existing record.
Filter Values From a Multi-Select Item Field to a Transaction Line Field
In some business use case, it is needed to source values from a Multi-Select Field that would be displayed to a Custom Line Field. This can be done by creating a Custom List, Custom Multi-Select Field and then applying the result on a Custom Line Field.
Unselect or Deselect All Values to Make the Field Blank in Multi Select Field
Multi Select Field does not have a blank option. Users are unable to unselect/deselect all values to make the field blank.
Compare Values of Multi-Select Field and List/Record Field
User have an Employee saved search and wants to compare the values of a multi-select field to a list/record field and use it as a criteria to filter the saved search results.
Class per line item is not populating in a sales order transaction
Classper line item is not populating in aSales Ordertransaction.
Alternate way to edit a locked custom list/record field from a bundle
User needs to update a field however it is locked and can't be edited.
Return all Invoices of Sub-Customers based on its Parent Customer in Print Checks and Forms > Invoices
User needs to pull all invoices for a customer and its sub customer, however theCustomerfilter is not available in aOne World Account.