Track Transaction Age from Creation in NetSuite (Days & Hours) vs Current Date

Administrators may require information regarding the duration of time since the creation of a transaction. For instance, if a journal entry or any other transaction has not been processed within a specified timeframe, it may require attention. Administrators can promptly identify delays and guarantee that all operations are proceeding smoothly by monitoring the age of… Continue reading Track Transaction Age from Creation in NetSuite (Days & Hours) vs Current Date

Resolve Error:“Clear Failed. One Or More Account Transact…” in Match Bank Data

Clearing NetSuite account transactions is a valuable feature provided by Match Bank Data, enabling users to manage transactions that lack corresponding imported bank data. Users have the option to mark these account transactions as cleared, bypassing the matching process. Similar to matched transactions, user-cleared transactions are directed to the Review tab for verification before proceeding… Continue reading Resolve Error:“Clear Failed. One Or More Account Transact…” in Match Bank Data

SOAP Web Services: InvalidVersionFault Error

When integrating with NetSuite SOAP Web Services, you may encounter the InvalidVersionFault error. This error occurs when the request message specifies an unsupported or outdated version of the NetSuite schema. NetSuite regularly updates its Web Services versions, and older versions may become deprecated, requiring integrations to be updated accordingly. Using an incorrect version can lead… Continue reading SOAP Web Services: InvalidVersionFault Error

Essential syntax requirements of SuiteQL

Essential syntax requirements that must be followed when writing SuiteQL queries, particularly when using the Connect Service. Understanding these rules will help ensure that your queries execute correctly and efficiently within NetSuite. When writing queries using SuiteQL with the Connect Service, follow these important syntax rules to avoid errors: String Concatenation The + operator cannot… Continue reading Essential syntax requirements of SuiteQL

Failure to post tax due to no nexus setup

Issue Statement: A common error faced by customers recently is the failure to post tax due to no nexus setup. Here is a quick guide on resolving these posting errors and setting it up correctly. Solution: To resolve our concern, we have to follow the steps below ======================== Login as Administrator ======================== I. Create a… Continue reading Failure to post tax due to no nexus setup

Error on Balancing by Segments Process

Issue statement: When running the Balancing by Segments Process, the customer is encountering an error: Status: Failed. Solution: To resolve the error, re-toggle the feature and run the Balance Transactions by Segments process again: Navigate to Setup > Company > Enable Features > Accounting Tab In the Accounting Tab > Advanced Features: Disable the Balancing Segments Hit… Continue reading Error on Balancing by Segments Process

Add Quantity as a column in the Profit and Loss Report

Requirement: The Customer wants to add Quantity as a column in the Profit and Loss Report. Solution: By design, the quantity field is not available for financial reports. This is currently as system limitation is logged under Enhancement 165316. This detail is available on more granular reports like Transaction Detail Reports under Reports > Financial… Continue reading Add Quantity as a column in the Profit and Loss Report

New Specialized Users

CRM Role : The Specialized User: CRM role is a standard role with predefined permissions that enables you to manage sales, CPQ, marketing, support, and other CRM activities in NetSuite. Use this role to work with Campaigns, Opportunities, Quotes, Sales Orders, Cases, and other customer-related records, and CPQ functionality. You can customize this role to… Continue reading New Specialized Users

Change to which Users can Create Events on a Calendar

As of 2024.2, users can create events only on their own calendars. However, users can manage events on other people’s calendars if the owner of the calendar has granted them permission to do so. Similarly, only users who are members of a group can create events for that group

Saved search with SOAP Web Services

Problem Statement: It is possible to create a saved search with SOAP Web Services. Solution We can run an existing saved search with additional filters by simply adding a few more lines in the SOAP HTTP Request. Find the sample request and response below where the search operation’s TransactionSearchAdvanced to load an existing transaction saved… Continue reading Saved search with SOAP Web Services