Author: Ann Maria Wilson

1.Requirement from Knot & co    The Client have requested the below requirements through the meeting:    Inventory Item Migration: The client wanted to ensure that inventory items, including on-hand quantities, were included in the migration, and they discussed the importance of maintaining consistency with the trial balance and chart of accounts during this process.  … Continue reading Proposal for Item Migration and customizations

To schedule a report in NetSuite, follow these steps: 1. Navigate to the Report: Go to Reports > Saved Reports. Select the report you want to schedule. 2. Customize the Report (Optional): If you need to customize the report before scheduling, click Customize. Make the necessary adjustments to filters, columns, and other report settings. Save… Continue reading Automate report sending by Scheduling the Report

1.Requirement from Corp Design-USA-NS/SCA    The client has encountered a problem where sales orders continue to reflect promotional rates even after the associated promotion has ended. The promotion was managed through a Quantity Pricing Schedule, which was set to inactive after the promotion period concluded. However, sales orders still pull the outdated promotional rates, and… Continue reading Proposal for Automated Management and Application of Promotion in NetSuite

If standalone quotes (quotes not associated with any subsequent transactions) are not showing in the quotes report, you can enable the option to “Show Zeroes”. This ensures that quotes with no subsequent transactions (like sales orders or invoices) are displayed. More Options: In the report customization settings, look for the More Options button. This is… Continue reading To Display Stand Alone Quotes in Report

In the Results tab, configure the fields you want to display in the search results. To include the invoice number using a formula, follow these steps: Add a New Column: Click on New Column and select Formula (Text) as the field type. Set Summary Type: Set the Summary Type to Maximum. This helps in aggregating… Continue reading To Display one or more Invoice Number in saved search in single line with no item fulfillment lines

1. Navigate to Saved Searches Go to Reports > Saved Searches > All Saved Searches > New. Select Transaction as the search type. 2. Set Basic Criteria In the Criteria tab, add filters to narrow down the search to journal entries. For example: Type is Journal. Main Line is True (to include only the main… Continue reading Removing Voiding and reversal Journal entries for importing

In NetSuite, voiding and reversal journals do not need to be manually imported because they are system-generated. This automation simplifies the process and ensures accuracy. Here’s a detailed explanation of how it works: Voiding Journals Voiding journals are used to nullify or cancel out previous journal entries. In NetSuite, these journals are automatically created by… Continue reading Importing Voiding Journals and reversal Journals

NetSuite offers two ways for vendors to be warned when reaching their credit limit: 1. User Preferences: This approach allows individual users or the entire company to receive warnings. For Individual Users: Users navigate to Home > Set Preferences. Under General, check the box for Credit Limit Warnings. For Company-wide warnings: Go to Setup >… Continue reading Credit limit warnings in NetSuite

There are two main ways to pay vendor bills in NetSuite: 1. Paying a Single Vendor: This method is suitable when you want to pay an invoice for a specific vendor at a time. Here’s how to do it: Go to Transactions > Payables > Pay Single Vendor. In the Vendor field, select the vendor… Continue reading Vendor Bill Payment

The main difference between cash-based reporting and accrual-based reporting lies in when revenue and expenses are recognized. Here’s a breakdown: Cash-Basis Reporting: Revenue: Recognized only when cash is received from the customer. Expenses: Recognized only when cash is paid out. Focuses on: The actual flow of cash in and out of the business. Simpler: Easier… Continue reading Difference between Cash Based Reporting and Accrual Based Reporting