Domain Setup: Separate domains will be configured for each subsidiary, sample format for domains; AU: .com.au UK: .co.uk NZ: .co.nz USA: .com CA: .ca NL: .nl Website Configuration: We will configure NetSuite to link each domain to its corresponding subsidiary. Each domain will have region-specific products, categories, and pricing, and the user experience will be… Continue reading Proposal for multi-site setup
Month: February 2025
Limits for Display of Transaction Lists and Sublists
When working with transactions in NetSuite, the number of records, transactions, or rows of data that can be accessed at one time is limited to 10,000. This limit applies to all transaction types unless otherwise stated. For example, the maximum number of lines that can appear on a transaction record’s sublist is 10,000. Warning Transactions… Continue reading Limits for Display of Transaction Lists and Sublists
Identify the Memorized Transaction Associated with the Template Created
Scenario A user has a Memorized Transaction Template created and wants to know the source of the Template from the List of Memorized Transactions. Solution The URL of the Memorized Transaction Template shows the internal ID of the associated Memorized Transaction. Navigate to Transactions > Management > Enter Memorized Transactions > List Set the following Filter: – Has Remaining: All Show Inactive: Put Checkmark Match… Continue reading Identify the Memorized Transaction Associated with the Template Created
Resolve Error on Deleting Sales Order Memorized Transaction
Scenario Deleting a Sales Order Memorized Transaction returns an error: “This Memorized Transaction Cannot be Deleted Because it is Referenced in Transactions.” Solution Navigate to Transactions > Management > Enter Memorized Transactions > List Memorized Transaction: Click Enter Items tab: Click Clear All Lines Add a new line by selecting any random Item Click Add Shipping tab: Set the Shipping Cost to 0 Hover your mouse over Actions Click Memorize Note: A warning message… Continue reading Resolve Error on Deleting Sales Order Memorized Transaction
Journal Entry Record > Unable to Delete > Memorized Transaction
Scenario User created a Saved Search report and found a Journal Entry record with Entry No. = To Be Generated and shows Memorized Transaction. User is not able to Delete or Approve the Journal Entry. Solution This Journal Entry record is actually the ‘template’ for the Memorized Transaction. Upon creation of the Journal Entry and saving it as Memorized Transaction, the… Continue reading Journal Entry Record > Unable to Delete > Memorized Transaction
NetSuite Saved Searches vs. SuiteQL: When to Use Which for Reporting
What Are Saved Searches? Saved Searches are NetSuite’s built-in reporting tool that allows users to create, filter, and export data without writing code. They can be accessed via the UI, SuiteScript, and REST API. Advantages of Saved Searches ✅ User-Friendly – No coding required; accessible via UI. ✅ Built-in Features – Offers aggregation (SUM, COUNT),… Continue reading NetSuite Saved Searches vs. SuiteQL: When to Use Which for Reporting
Editing Memorized Transactions
You can make name, type, and schedule changes to a memorized transaction. You can also specify posting options and update addresses to ensure that your information is accurate. However, if the field that you want to edit on the memorized transaction is dimmed or not included on the page, you must create a new original transaction and then memorize that… Continue reading Editing Memorized Transactions
Submitting Memorized Transactions
After you have set up memorized transactions you can submit all transactions due to be posted at one time. To submit memorized transactions: Go to Transactions > Management > Enter Memorized Transactions. On the Enter Memorized Transactions page, use the following filters to show transactions in the list: Date Enter or select the date you want… Continue reading Submitting Memorized Transactions
How to Resolve SFTP Connection Timeout Issues
When connecting to an SFTP server from NetSuite, you may encounter connection timeout errors, preventing successful file transfers. These issues can arise due to network restrictions, incorrect configurations, or authentication problems. This article outlines common causes and solutions to resolve SFTP connection timeout issues in NetSuite. Common Causes of SFTP Connection Timeout Issues Incorrect Hostname… Continue reading How to Resolve SFTP Connection Timeout Issues
Memorizing a Transaction
When you create a memorized transaction, the update is tracked on the system notes of the memorized transaction. To memorize a transaction: Automatic Memorized Transactions To memorize a transaction: Edit the transaction you want to memorize, and make sure the appropriate information is filled in. Posting transactions that contain serial or lot numbers cannot be… Continue reading Memorizing a Transaction