NetSuite offers a comprehensive suite of SQL Functions, catering to various data manipulation and analysis needs. Here’s a list of some of the common functions used: Note: The links to the function explanations will be updated as new articles about SQL Functions are posted. Numeric Functions ABS ROUND FLOOR CEIL MOD REMAINDER MOD vs. REMAINDER Character… Continue reading List of SQL Functions
Author: Divya Unnikrishnan
The custom segment shows but not under classifications group, it is displayed at the end of the list in the setup tab > company.
The recommended solution as suggested by SuiteAnswers #1013645 is: Navigate to Customization> Lists, Records, & Fields > Custom Segments Preferred Custom Segment: Click Edit Custom Record Type: Click on Custom Record Type Click Edit Click Links Insert Before: Select Segment Note: Select Preferred Segment where Custom Segment should be placed. Click Save Based on your requirement, the following setup would solve the issue: Section – Setup Category – Company Link… Continue reading The custom segment shows but not under classifications group, it is displayed at the end of the list in the setup tab > company.
Reconciliation Detail Report
The Reconciliation Detail Report provides the user with a comprehensive list of transactions that have been either cleared or remain uncleared for a specific bank account during the selected statement period. This report is organized by the statement date, and includes both categorized and itemized details of the transactions. This report becomes available only after the user has… Continue reading Reconciliation Detail Report
Key considerations before Bank Feeds SuiteApp installation
To set up your Bank Feeds, you must first connect your NetSuite account to your Financial Institution using an authorized Account Information Service Provider (AISP). After a successful connection is established, all bank and credit card accounts associated with your Financial Institution are automatically connected to your NetSuite account. To configure Bank Feeds in NetSuite, the user must begin by establishing a secure… Continue reading Key considerations before Bank Feeds SuiteApp installation
Applying Functions to Search Results Columns
Applying Functions to Search Results Columns For each search results column, you have the option of applying a function to transform its data value into a format most useful for your purposes. To apply a function to a field’s values on the results page: Reference article – NetSuite Applications Suite – Applying Functions to Search… Continue reading Applying Functions to Search Results Columns
Resolving the Error: “Elimination settings for the Journal line, accounts, and name do not match”
Overview This error typically occurs in NetSuite when an intercompany account is used in a standard journal entry instead of an intercompany journal, and the elimination settings are not properly configured. Root Cause The error arises due to a mismatch between: ~ The account’s configuration (marked for intercompany elimination) ~ The journal entry type (standard vs. intercompany) ~ The entity involved (whether it’s an intercompany entity or not) Resolution Options… Continue reading Resolving the Error: “Elimination settings for the Journal line, accounts, and name do not match”
Prevent Auto-Matching of Imported Bank Data to Older NetSuite Transactions
Scenario: If imported bank data is being auto-matched to older NetSuite transactions (e.g., April transactions instead of May), it’s likely due to the bank data being imported before the corresponding NetSuite transaction was posted. Solution: To prevent this, you can create a Reconciliation Rule that limits matching to transactions within a specific date range. Go… Continue reading Prevent Auto-Matching of Imported Bank Data to Older NetSuite Transactions
Imported Bank statement deletion
How do you know if the imported bank statement can be deleted? Here are the criteria that must be met: 1. The import was successful, 2. The account statement is unreconciled, and 3. The import was manual To elaborate on the third criteria: The bank statement should have been imported manually through Transactions > Bank >… Continue reading Imported Bank statement deletion
Pakistan Tax setup in SuiteTax – FAQ
1) Where does the tax rate on transaction come from? How to set tax codes for Pakistan? In SuiteTax, we need to create tax codes and tax types for Pakistan manually as there is no localization bundle. These tax codes need to be set in Nexus for default tax codes for purchase, sales, import, and… Continue reading Pakistan Tax setup in SuiteTax – FAQ
Fixed Asset bundle provisioned but not available for installation
Scenario: FAM bundle has been provisioned to the NetSuite account based on the Billing information. However, the bundle is not available for installation. Findings: Based on SuiteAnswers #103553, the FAM bundle will be available only in selective timings. Important: The availability schedule during phased upgrades applies only to customers who will be installing the Fixed… Continue reading Fixed Asset bundle provisioned but not available for installation