-
NetSuite Admin Tip: Automatic Location Assignment
As a NetSuite administrator, you know that keeping your customer, item, and transaction data organized is essential for maintaining accurate records and getting insights from your data. Luckily, NetSuite has many features to help you with this, one of which is Automatic Location Assignment. Automatically assigning a…
-
NetSuite Admin Tip | Best practice to inactivate a resigned employee
If the employee is no longer connected to your company, it is best practice to make the employee record inactive and remove the assigned roles from the user. Step I: Inactivate the Employee Record 1. Login to your Administrator role 2. Navigate to Lists > Employees > Employees NetSuite: NetSuite NEXT: 3. Click Edit on the…
-
Error: "Invalid tax calculation output: duplicate tax codes specified for line with key 'NEW1'.
Scenario: A user with an Administrator role encounters an error upon clicking the Preview Tax button on their Sales Order: "Invalid tax calculation output: duplicate tax codes specified for line with key 'NEW1'. The customer is using SuiteTax and has Avalara as their Tax Engine and the Nexus of the transaction is Ontario,…
-
NetSuite Admin Tip | Using External IDs for Seamless Integrations
In today’s fast-paced business environment, organizations are constantly seeking ways to enhance their operations, integrate diverse systems, and maintain data accuracy. One often overlooked but highly effective tool in achieving these goals is the use of External IDs. In NetSuite, External IDs serve as unique identifiers…
-
NetSuite Admin Tip | How to Avoid Slowness on Material Requirements Planning (MRP) run
Material Requirements Planning (MRP) is a critical process in the manufacturing industry that helps companies manage the materials needed for production. MRP involves determining what materials are needed, how much is needed, and when they are needed to meet production demands. It considers factors like lead times,…
-
NetSuite Tip - Uploading a file to an FTP server N/sftp
var connection = sftp.createConnection({ username: userName, passwordGuid: passGUID, url: URL, directory: '/', hostKey: hostKey }); //if you have a xml content or json content, create them as a file and upload to FTP //Module: N/file :> file var FileToUpload = file.create({ fileType: file.Type.PLAINTEXT, name: XMLfileName,…
-
Fetching Bill Credit details (Credits Applied) from a bill payment transaction
Hi All, There are a lot of requests to pull the bill credit details from a created related bill payment transaction. An enhancement was created for this functionality in Netsuite: "Enhancement 213645: Search to show all Bills and Bill Credits associated to a Bill Payment". Showing the information of the Bill Payment's…
-
NetSuite Admin Tips: Subsidiary Navigator: Selecting Parent/Subparent subsidiary only
Scenario: ABC company is using Subsidiary Navigator in their OneWorld account to restrict the information displayed on their dashboard, searches, and reports to a specific subsidiary as their company is composed of multiple subsidiaries operating across many regions and countries. In a scenario where Company ABC needs to…
-
NetSuite Admin Tip: SQL Formula to Count Days Left Until Month End
Welcome to another NetSuite Admin Tip, where we will explore a deceptively powerful SQL formula that revolutionizes monthly tasks. This formula may seem mundane at first, but its applications are far-reaching, offering a significant boost in efficiency and productivity. A Real-world Scenario: As an Accounts Payable (A/P)…
-
NetSuite Admin Tip: Unlocking Same-Day Sales Insights
In the fast-paced world of sales, keeping track of critical metrics and insights is essential for success. Have you ever wondered how many sales orders were created on the very same day a customer was added to your NetSuite account? This valuable metric can offer profound insights into your sales team's efficiency and…
-
NetSuite Admin Tip | Total Sales Orders per Day Using SuiteQL
In today's competitive business landscape, understanding the total sales orders per company is not merely a metric for tallying transactions; it is a comprehensive tool for assessing a company's overall health and trajectory. As markets become more saturated and consumer preferences evolve, businesses must have a clear…
-
NetSuite Admin Tips | How to resolve Payment Link “Payment Rejected: Card Authentication” Error?
Payment Link enables online Invoice payment through computers or mobile devices for Customers. It eliminates the need for payment discussion as Customers can receive an email with a direct link to the Payment portal. This provides payment options for various methods you have selected, including credit cards and PayPal. In…
-
NSC Admin Tips | Hide or Remove Links in the Customer Center
This article provides guidance on how to hide or remove specific links in the Customer Center, such as "Enter an Order," "Make a Payment," and "Request a Return." This can be useful when you want to direct customers to custom links or prevent them from using certain functionalities. Companies may need to hide or remove…
-
NetSuite Admin Tip | Best Practices of Manufacturing Work In Process (WIP)
As an administrator overseeing manufacturing operations, implementing Work in Process (WIP) tracking can be a game-changer for your organization's productivity and efficiency. Here's a comprehensive guide to help you master WIP and streamline your production processes: Understanding WIP's Role Work in Process tracking is a…
-
NetSuite Admin Tip: Effective Date Pricing SuiteApp
Are you a retailer or distributor? If so, you know that pricing is a key factor in your business. You may have sales or promotions scheduled, and you need to be able to change prices of items quickly and easily. The Effective Date Pricing SuiteApp (Bundle ID: 222420) is a great solution for you. This bundle allows you to…
-
NSC Admin Tip | Implement Inline Editing Where Possible
Inline Editing allows users to make quick updates to records directly from list views or saved searches without having to open each record individually. By enabling inline editing on custom fields and lists, you can streamline data entry and save time for users who need to manage multiple records efficiently. How Inline…
-
NetSuite Admin Tip | Create a Saved Search for total Allocated Hours vs Actual Hours
Tracking the balance between allocated hours and actual hours is crucial in the service industry, where tasks like client meetings, research, and report preparation require precise time management. Monitoring this comparison helps ensure projects stay within scope, timelines, and budgets. In NetSuite, a Project Task Saved…
-
NetSuite Admin Tips: Tracking the Construction in Progress (CIP) in Fixed Asset Management
A manufacturing company may be in need to track Capitalized Interest on each asset during the build of an asset and then once the asset is built and delivered to a customer the company can then accrue interest to the cost of the asset. NetSuite does not have a process specific to a Construction in Progress as of now. We…
-
NetSuite Admin Tips | Create a Search to Display Roles with No Users
Administrators from any industry may need to run a report to display roles with no users for various reasons, depending on the specific context of their organization and their responsibilities. Here are some common use cases: Security and Access Control - Roles without any users could mean that permissions are not…
-
custom segment not populate on FAM
hi expert, I have custom segment as "Project" list, and used in Make Journal Entry. When I create Fixed asset using "Manage asset Proposal" menu, Project value (custom segment) field on FA Code is missing is there any missing setup ? need advice
-
NSC Admin Tips | Adding Field-Level Help for Custom Fields
This article addresses how users can add helpful information or descriptions to their custom fields. Field-level help guides users on what type of information to enter in each field. You can also include details such as who typically fills out the field, who the end user is, and the field’s intended purpose. To add…
-
NetSuite Admin Tips | Deactivate an Administrator’s Access to NetSuite
Administrators from any industry may need to deactivate an administrator’s role for many reasons. A common scenario for deactivating an administrator role is shown below: · Employee Departure - To avoid unauthorized access to important data, an administrator's employee record should be deactivated when they depart the…
-
NetSuite Admin Tip | When to consider Auto Bank Statement Import (ABSI) SuiteApp?
Auto-Bank Statement Import (ABSI) SuiteApp is similar to the Bank Feeds application, allowing you to automatically import bank transactions into your system. This means you don’t have to manually download and upload transactions from your bank anymore – ABSI does that for you. What makes ABSI more reliable than Bank Feeds…
-
Profit and Loss Report > Add Column which shows Quantity
Customer wants to add Quantity as a column in the Profit and Loss Report. By design, the quantity field is not available for financial reports. This is currently a system limitation and is logged under Enhancement 165316. This detail is available on more granular reports like Transaction Detail Reports under Reports >…
-
Error When Running Balancing by Segments Process
When running Balancing by Segments Process, customer is encountering an error: Status: Failed. 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…
-
Shopify Connector Issues > Solving failed postings due to no nexus errors
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. To resolve our concern, we have to follow the steps below ======================== Login as Administrator ======================== I. Create a…
-
NetSuite Tip - Customized html alert popup
Scenario: Show a popup mentioning insufficient credit limit balance on SO. Refer the below code for reference. Here uses a html alert popup and embedded into a inlinehtml field. const PENDING_APPROVAL = 'A'; const beforeLoad = (scriptContext) => { if (scriptContext.type === scriptContext.UserEventType.DELETE) return; try {…
-
NetSuite Admin Tip | Retrieving Employee IP Addresses Using the Login Audit Trail via Saved Search
Monitoring the IP addresses used by employees during their login sessions is a crucial aspect of maintaining security, safeguarding sensitive company information, and ensuring compliance with regulatory requirements. By tracking IP addresses, organizations can detect unauthorized access attempts, identify unusual login…
-
NetSuite Admin Tips | How to Troubleshoot Bank Feeds Connection Issues
Bank Feeds SuiteApp is crucial for modern accountants because the automate the process of importing bank transactions directly into NetSuite, significantly streamlining the reconciliation process. Accountants benefit from using this SuiteApp as they are time-saver. Accountants no longer have to manually checked their bank…
-
NetSuite Admin Tip |"Please Enter a Value for Attach File" When attempting to use Drag & Drop a File
When users attempt to drag and drop files, an unexpected message appears: "Please Enter a Value for Attach File." This issue is caused by the Maximum Entries in Dropdowns field being set to a higher value than recommended. Adjusting this setting can help resolve the error and ensure the drag-and-drop functionality works as…