Featured Articles
NetSuite Release 2024.2 - Release Preview
The Release Preview account enables you to become familiar with the new features in an upcoming release. You can verify that your existing business workflows function as expected before your production account is upgraded to the new NetSuite release. You can also use the Release Preview account to test and ensure your NetSuite account and any associated applications are not dependent on a specific data center to store data. The goal is to provide a smooth and seamless transition to a new release. By making this information available, and providing other needed guidance, you will avoid any major problems or surprises when you go live with the new version.
NetSuite Release 2024.2 - Pre-Release Tasks
As part of NetSuite’s commitment to continual product improvement, two software updates are scheduled for each year. This article contains important information regarding the Release Preview environment and how to prepare your account for the new release.
More Articles
Get Total Unbilled PO Amount on Vendor Record Using Client Side Script
The total unbilled amount which can be seen in theAmountfield on theVendorrecord is based on the items' total quantity multiplied by their respective amounts. Some use cases permits users to change the rate of each item on theVendor Billrecord which will sometime exceed the totalPurchase Orderamount set in thePurchase Orderrecord.
Set the Class Column on Item Sublist to Mandatory on Company Preferences via Script
User wants to set the Item Sublist columns mandatory to ensure that important information are set on the record (e.g., the Class field).
Dynamically Add Custom Button Using User Event Scripts
A user wants to dynamically add a button in a record using aUser Eventscript.
Use a Group of Approvers in a Workflow Utilizing a Workflow Action Script
User needs toincorporatea certain group ofApprovers,SupervisorsorEmployeesto aWorkflowto handle the approval process ofa record.
Call Client Scripts from Workflow
Scenario
Below is an example to demonstrate how this is done. This requires basic SuiteScript and Workflow knowledge.
Solution
- Create a JavaScript file with the following codes:
Note:The above function will be called by the Workflow on Step 5.4.functionsayHello(s){alert('Hello '+s);/* * return true|false line is required to allow/disallow the workflow action to execute. * Condition will treat the function returned false if this line is omitted. * Thus, Workflow Action (e.g. Set Field Value) will not execute */returntrue;} - Navigate toCustomization>Scripting>Scripts>New
- Click on the+logo beside theScript FilePopup List
- Select the JavaScript file on the File Popup Window and click onSave
- UnderDeploymentstab, add the record (Applies Tocolumn) script & workflow must be applied to (For this example,Customerrecord is used and click onSave)
- Navigate toCustomization>Workflows>Workflow>New
- Basic Information:
- Name:EnterName
Example:EnterCustomer Workflow - Record Type:SelectCustomer
- Sub Types:SelectCustomer
- Execute as Admin:EnterCheckmark
- Release Status:SelectReleased
- Name:EnterName
- Event Definition:
- On Create:EnterCheckmark
- On View or Update:EnterCheckmark
- ClickSave
- ClickState 1
- Bottom right corner:ClickNew Action
- ClickSet Field Value
- Basic Information:
- Trigger On:SelectBefore User Edit
- Event Types:SelectCreate
- Context:SelectUser Interface
- Triggering Client Fields:SelectMemo
- Condition:
- SelectFormula
- Formula:EntersayHello(nlapiGetFieldValue('companyname'))
- Triggering Client Fields:SelectMemo
- Parameters:
- Field: SelectAccount
- ClickSave
Search Item Next Count Date
To create a report with an empty Next Count Date, please follow the following:
Create an Item Saved Search to Show All Bin Numbers per Item
The user needs an Item Saved Search that shows all Bin numbers of Items.
Item Record > Set Item Defined Cost Value to a Null Value
Unable to setItem Defined Cost Valueto a Null Value.
Edit Quantity on Work Order with Partially Built Status
The user needs to edit the Quantity in the Work Order that already has an Assembly Build. However, upon doing so, the Quantity field cannot be edited.
Displaying Approved Time as Actual Costs in Advanced Project Profitability Report
When creating project profitability configurations, theTreat Tracked & Approved Timeas Actual Costpreference enables you to select approved time as actual costs without posting time. You can also display tracked and approved time as actual costs on the P&L subtab. Displaying approved time as actual costs ensures the estimate at completion and estimate to complete calculations are more accurate.
Creating Custom Project Profitability Reports
Advanced Project Profitability uses filters to map accounts and items to specific columns and rows within a custom project profitability report. The feature comes with a standard configuration of account and item mappings. You can edit and customize the standard configuration and create custom profitability reports to fit your business needs. You can create multiple configurations. All of your project profitability reports are located at Reports > Projects > Project Profitability Reports.
Display SKU for Inventory Items on Sales Order Printout
User needs to display SKU (Display Name/Code) on their Sales Order Advanced PDF/HTML Template but would only need to display the code for Inventory Items only.
EFT Payment Notification Displaying Huge Company Logo within the Email Body
The company logo is not rendering correctly specifically when the EFT Payment Notification is being sent as body of the email. The company logo thoughis being displayed at acceptable size if the EFT Payment Notification is being sent as an attachment.
Resolve Error: "SSS_MISSING_REQD_ARGUMENT: parse: Missing a required argument: value" in Asset Disposal
User processes Asset Disposal but it Failed with error:SSS_MISSING_REQD_ARGUMENT: parse: Missing a required argument: value.
Fixed Asset Disposal > INVALID_FLD_VALUE: You have entered an Invalid Field Value 1 for the following field: custrecord_deprhistaltmethod
The user is disposing fixed asset records by Write- Off, manually in Fixed Assets > Transactions > Asset Disposal page and encounters error message: "INVALID_FLD_VALUE: You have entered an Invalid Field Value 1 for the following field: custrecord_deprhistaltmethod"