I just encountered a query on how to set the field “Customer Category” not to select any values from the list but to None while creating a saved search. Option 1 Was to set in the criteria tab “Customer Category” is None Option 2 Is to set the formula {Custtype} IS NULL The formula used… Continue reading How to set the “Customer Category” field to “None” in the result tab instead of the Criteria tab in a Saved Search
Month: January 2022
Locking a script from edit or viewing.
Question How we can lock a script for editing or view?. Solution There is no direct way for locking a script in Netsuite.We can restrict the script from editing or view by creating a bundle for that script. Even the administrator could not edit/view it.
Highlighting a part in particular field -PDF
Customer field’s internal id is entity, here we can highlight one of the entity field that is separated by colon.
Restrict line-level field change based on Condition
Disable Line level fields based on condition
We have the user event script serverWidget method to disable the entire column specifically. But if we need to disable/change the visibility of a specific cell in a row and column of a line it is not possible to use the user event script. Proposed Solution: Using DOM element in Script to disable the particular… Continue reading Disable Line level fields based on condition
Open Email Message Popup Window using a custom button and set default values
The following User Event Script deployed to Sales Order record places a button on the sales order page named Email CS. Once this button is clicked, an email message window popup will be opened with predefined values of recipient and template category. We could pass many field values through the URL parameters. For those values… Continue reading Open Email Message Popup Window using a custom button and set default values
Dynamically update copyright date in SCA footer
The copyright date in the footer of SCA will be having the default value of the suitecommerce release year. The year needs to update manually each year. The below code can be used to set the value dynamic. Copyright © document.write(new Date().getFullYear()), All Right Reserved Based on the version, can use extension or custom module.
SCIS with Inventory Feature error: Please configure the inventory details for this line
when the Inventory status feature is enabled, you’ll encounter ‘Please configure the inventory details for this line’ error message in SCIS and will not be able to process the transaction when: Item has no quantity in the location where the sales rep is logged in Item is using Bins At the moment, Inventory Status is… Continue reading SCIS with Inventory Feature error: Please configure the inventory details for this line
VALID_PRD_REQD – Insert Transaction failed: no valid open tax period for date x/xx/xxxx. Please visit Setup->Manage Tax Periods to setup a new tax period.
The above error may get when you try to save a transaction and there is no Tax Period for the same. You may get as below. {“status”:”FAILURE”,”reason”:{“type”:”error.SuiteScriptError”,”name”:”VALID_PRD_REQD”,”message”:”Insert Transaction Failure: No valid, open, tax period for date – 2022-01-03. Please visit Setup > Manage Tax Periods to set up a new tax period.”,”stack”:[“Error\n at RecordInvoker.save … Solution… Continue reading VALID_PRD_REQD – Insert Transaction failed: no valid open tax period for date x/xx/xxxx. Please visit Setup->Manage Tax Periods to setup a new tax period.
PROPOSAL FOR UPDATING THE AUTOMATIC PURCHASE ORDER CREATION FUNCTIONALITY BASED ON THE ITEM’S PREFERRED VENDORS.
Proposal summary This proposal addresses the creation of automated purchase orders from sales orders based on the preferred vendor for the corresponding items. Requirement Change the CREATE PO to create POs based on preferred vendor instead of just ZT RMB vendor by default. So if SO has items for 3 different preferred vendors, it will… Continue reading PROPOSAL FOR UPDATING THE AUTOMATIC PURCHASE ORDER CREATION FUNCTIONALITY BASED ON THE ITEM’S PREFERRED VENDORS.