-
How Do I Access Detailed Pricing Changes from Item System Notes?
How Do I Access Detailed Pricing Changes from Item System Notes? I'm not sure when it happened, but I just recently noticed that NetSuite now records ALL Item Price changes in the Item System Notes using a field named "Pricing" [LIST] [*]Provides a "View" link to the entire list of prices PRIOR to the change [*]Provides a…
-
Custom Fields for Discount Item
Maybe I'm just not seeing it somewhere or a feature needs to be enabled, but can someone please explain to me how to add new fields to the Discount Item subtype? All I see in the Applies To tab is: Inventory Item, Non-inventory Item, Service, Other Charge, Group, Kit/Package, and Assembly/Bill of Materials. Thank you,…
-
Suitelet Erorr
I have a Suitelet built using NetSuite UI objects. I made the Suitelet available without login. When the Suitelet is submitted i get an error that says "Invalid Page Parameter. Unable to view page" anyone seen this before?
-
Dependent Field Display
Is there a way to only show a text box field based on what's selected in a drop down other than via a workflow or a script? We have a custom list/field that allows a CSA to choose whether the customer wants his or her invoice emailed, mailed, faxed, etc. We then have 3 separate text fields to enter the info. I want to hide…
-
NSC | How do I show the list of results even if there is one result only in Saved Searches?
When you run a Saved Search with one result only, you might encounter the behavior wherein it automatically redirects to the record instead of showing the list of results. In this article, we'll guide you on how to disable this feature and be able to view the list of results. Solution: Navigate to Home Icon > Set…
-
NSC | How do I remove the stock Internal ID field in Saved Searches?
Scenario: You have a Saved Search and you wanted to remove the Internal ID column as seen below: Solution: Navigate to Home Icon > Set Preferences On the Set Preferences page, make sure to set the field below: Show Internal IDs: Unchecked Results: Once done, the Internal ID column would not be visible anymore as seen…
-
NSC | Can I move the Approve button to the Action menu in Sales Orders?
In case you wanted the Approve button to be hidden within the action menu in your Sales Orders, this would possible by customizing the Custom Form. Scenario: On your Sales Orders, you want the Approve button to be inside the Actions dropdown: Solution: On the Custom Transaction Form page, navigate to the Actions subtab and…
-
NSC | Why is my Custom Record not available in my Quick Search portlet?
In NetSuite, you might be wondering why is your Custom Record not showing up in your Quick Search portlets. In this article, we'll show you on how to enable this. Scenario: You have a Custom Record called Actors. In the Quick Search portlet, the Actors record is not available in the Search For field: Solution: On…
-
NSC | Why is my Custom Record not following the Permission sublist?
When using Custom Records, you might encounter an issue wherein the permission sublist is not being followed. In this article, we'll guide you on how to fix this by changing the Custom Records' settings. Scenario: You have a Custom Record and you want it to be restricted depending on the Permission sublist as seen below:…
-
NSC | Unable to uninstall Shepherd CMMS Bundle ID:404758
When uninstalling the Shepherd CMMS Bundle, you might encounter an issue wherein it says 'Bundle Uninstall In Progress' and after reloading the Installed Bundles page, nothing happens. In this article, we will be guiding you on how to fix this issue by enabling an Accounting Preference. Solution: Navigate to Setup >…
-
NSC | Why are the Fields on my Forms aligned horizontally?
In NetSuite, you might encounter the issue wherein the fields are aligned horizontally. Which might confuse the users since they are used to the vertical alignment. In this article, we will guide you on how to revert back to the vertical alignment of the fields. Scenario: On your Sales Order forms, the fields are aligned…
-
NSC | NetSuite2.com: A Query to Determine the Context in Which Transaction Records are Created
For auditing or troubleshooting purposes, users might need to get a list of transactions that are created in specific contexts such as via REST API, CSV, or Webstore. This sample query would give you the list using the NetSuite2.com Schema. SELECT tranid, id AS internalid, number, source, trandate, type FROM transaction…
-
NSC | How do I make the To Be Printed field checked by default on my Bill Payment records?
When printing your Bill Payment records, you might want the ability to have the To Be Printed field to be checked by default so that the user won't have the issue of forgetting to enable this. In this article, we will guide you on how to do this by customizing the Custom Form. Scenario: You wanted to have the To Be Printed…
-
NSC | Resolve: Script not Appearing in Script Debugger > Debug Existing
Script Debugger is used to troubleshoot server-side scripts in NetSuite. If you cannot find your script in the options after clicking the Debug Existing, consider checking the following fields in the Script’s Deployment Record: Status: Must be Testing. Deployed Checkbox: Must be ticked. IMPORTANT: Any changes you make to…
-
NSC | NetSuite2.com: How to Get the List of Deleted Records via ODBC/JDBC
Some might not be aware that it is possible to check the list of deleted records in NetSuite, which can be done using SuiteAnalytics Connect or SuiteQL Query. This is important when auditing the changes in your NetSuite Account. The sample below shows a list of deleted custom records in a test account: SELECT * FROM…
-
NSC | Resolve Error: UNEXPECTED_ERROR When Running Test Connect on ODBC Driver
UNEXPECTED_ERROR messages are quite common as they can be triggered by a variety of factors. However, when it comes to SuiteAnalytics Connect, Two-Factor Authentication (2FA) is a possible culprit. Two-Factor Authentication is an important security feature that adds an extra layer of protection to your NetSuite account.…
-
NSC | How to add a dollar ($) sign to a Custom Field that is being sourced?
In NetSuite, some companies requires their custom currency fields to have a dollar ($) sign. In this article, we will guide you on how to achieve this by using a formula. Scenario: On your Customer record, you're sourcing the Deposit Balance and you wanted to have the Dollar (&) sign to be included. However, it's just…
-
NSC | How to Redirect Users to the SSO Provider’s Login Screen When Opening NetSuite Account URLs
By default, opening URLs linked to NetSuite Accounts redirects users to NetSuite’s login screen, where users can enter their user credentials. For some who are using SAML SSO, this could confuse users who do not know their passcodes. To redirect users to their SSO Provider’s login screen instead, NetSuite Accounts can be…
-
NSC | Why is the Credit Hold field not showing on my Customer Record?
In NetSuite, you might encounter the problem wherein the Credit Hold field is not showing up even though it's set to be shown in the Custom Form. In this article, we will guide you on how enable this field by changing your preferences. Scenario: In your Customer Record, the Credit Hold field is missing as seen below: Even…
-
NSC | Resolve Error: “The signing certificate does not match what's defined in the entity metadata.”
Upon logging into NetSuite via SSO, users are met with an error message: “Exception while processing SAML response. The signing certificate does not match what's defined in the entity metadata.” This could be caused by a change on the side of the SSO provider, or two or more NetSuite accounts are sharing the same SSO…
-
NSC | Resolve Error: INSUFFICIENT_PERMISSION on RESTlets that run Map/Reduce or Scheduled Scripts
RESTlet has been widely used by businesses serving either as a solution for out-of-the-box REST API functionalities or to streamline their operational workflows. Among its capabilities, RESTlet enables the scheduling and execution of Map/Reduce or Scheduled Scripts. However, sometimes integrations hit a snag with an error…
-
NSC | Resolve Error: “<enum> is not a legal value for Country”
As NetSuite continues to evolve and upgrade its features, some changes are applied to existing features. In the recent versions, some country enumerations have been updated. Thus resulting in some integrations failing when it goes unnoticed after upgrading to a more recent WSDL Version. The documentation from the…
-
Date Created not available to Filter with on Activity Saved Search
Hi All, We've recently noticed that on an Activity Saved Search we can't filter by Created Date. We can however filter on Created Date on an Event Saved Search. This is really odd as Events are included in Activities, so how can on Events (a sub set) work and not Activity? Is there something we need to "turn on" somewhere?…
-
NSC | How to hide the "Sales Order/Cash Sale/Invoice" buttons from processed Estimates?
In NetSuite, once an Estimate is processed, users have the ability to create a Sales Order, Cash Sale, and Invoice directly on the Estimate itself. However, some businesses wants to remove these options once the estimate is processed. In this article, we'll guide you on how to do this by using a Workflow. Scenario: The…
-
NSC | Is it possible to customize the Inventory Status Change Form?
Some companies requires their Inventory Status Change forms to be customized (hide/add custom fields etc.). Unfortunately, this is a system limitation of NetSuite. This is logged and being tracked under Enhancement: 591906 Transactions > Inventory > Inventory Status Change > Ability to Customize Inventory Status Change…
-
NSC | Password Expiration Notice Encountered by Users Who Use SAML SSO
Users might still encounter password expiration notices in NetSuite despite using SAML SSO for several reasons: Mixed Authentication Methods: Users who has roles that log in directly to NetSuite instead of through the SAML SSO portal and do not have SAML SSO Permissions. This includes standard NetSuite roles, and custom…
-
NSC | How to Modify Existing Lines in a Transaction
In NetSuite, REST APIs are used for integrating and interacting with NetSuite data and functionalities programmatically. REST APIs provide a flexible, lightweight way to connect external applications, services, and systems with NetSuite, enabling automation, data exchange, and extended capabilities. This includes processes…
-
NSC | Generate Signature for Token-Based Authentication
Token Based Authentication is widely used in NetSuite Integrations such as RESTlets, SOAP Web Services, and SuiteAnalytics Connect. As part of the TBA Authorization Flow, the Timestamp, Signature, and Nonce must be supplied to generate the signature. The sample code below must be ran using PowerShell: $nonce=''…
-
NSC | SAML SSO: Resolve Error: “Error while reactivating user <email>: To give this person login acc
SAML (Security Assertion Markup Language) SSO (Single Sign-On) is a protocol that allows users to authenticate once and gain access to multiple applications and services without needing to log in separately to each one. It is widely used in enterprise environments to simplify user authentication and improve security. While…
-
NSC | SAML SSO: SSO Not Working in Sandbox After Refresh
As stated in SuiteAnswers Data That is Not Copied from Production to Sandbox, SAML SSO configurations are not replicated from Production into Sandbox Environments and would have to be re-configured in Sandbox after the refresh by navigating to Note: SAML SSO Roles and Permissions are already carried over in the refresh and…