In order to generate invoice from sales order only for the fulfilled items, set the following preference: Goto Setup>Accounting>Accounting Preferences Click on the order management tab, Under the ‘invoicing’ section, uncheck the Invoice in Advance of Fulfillment checkbox. Making this adjustment will ensure that invoice is generated only for fulfilled items
Author: Georlit George
Elimination of P&L account in Adjustment Period
According to standard NetSuite process, the P&L accounts in the adjustment period will not be considered when executing the intercompany elimination of the base period. #553390 Intercompany Transaction posted on Adjustment Period > Run the Eliminate Intercompany Transactions task in a Non-adjustment Period > Transaction Not Eliminated. This enhancement offers the solution of Creating manual… Continue reading Elimination of P&L account in Adjustment Period
VLOOKUP function explained with example
The VLOOKUP function is used to search for a value in the first column of a range and return a value in the same row from another column. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Parameters: lookup_value: The value you want to search for. table_array: The range of cells containing the data. col_index_num: The column number in… Continue reading VLOOKUP function explained with example
Steps for Configuring GST Under Reverse Charge:
1. Identify Scenarios for Reverse Charge Reverse charge applies to specific goods/services as per GST law, including: Unregistered vendors supplying services or goods. Import of services or goods notified under reverse charge. 2. Configure Tax Codes and Rates 3. Set Up Tax Types 4. Define Tax Rate Rules Navigate to: Setup > India Localization >… Continue reading Steps for Configuring GST Under Reverse Charge:
What is Xignite ?
Xignite is a financial data provider that offers a range of market data services, including real-time and historical data on stock prices, currency exchange rates, commodities, and more. In the context of NetSuite, Xignite can be integrated to enhance financial management by providing access to this critical financial information directly within the NetSuite platform. Key… Continue reading What is Xignite ?
Step-by-Step Guide to Create a Saved Search to view CSV Imported records
Here is a step-by-step guide to create a saved search to view imported files with example: 1.Start a New Saved Search: Go to Reports > Saved Searches > All Saved Searches > New. Select the type of record you imported, such as Customer, Item, Transaction, or other relevant record types. 2. Define Filter Criteria: In… Continue reading Step-by-Step Guide to Create a Saved Search to view CSV Imported records
Key Points to Consider for a Successful CSV Import in NetSuite
1.Understand the Data Requirements Before starting, understand what data you need to import and how it aligns with NetSuite’s data structure. Check the fields, field types, and any required fields in the record you’re importing (e.g., Customer, Vendor, Item). Ensure you have matching fields in your CSV file. 2. Field Mapping and File Preparation The… Continue reading Key Points to Consider for a Successful CSV Import in NetSuite
Enabling inline editing in Transaction saved search
Inline editing in transaction saved searches in NetSuite is limited and can be restricted due to several factors. Here are the key reasons and how to resolve them: Key Limitations: Transaction Type Restriction: Inline editing only works if a single transaction type is selected. If multiple types (e.g., Sales Orders, Invoices) are included, it won’t… Continue reading Enabling inline editing in Transaction saved search
Exploring Service items
Service items in NetSuite are crucial for businesses that offer services rather than tangible products, such as consulting, maintenance, and training. These items allow companies to track and bill for the services provided, facilitating efficient revenue management. Definition and Purpose Service items are non-inventory items that represent the intangible services a business offers. They differ… Continue reading Exploring Service items
Vendor Credits
Vendor credits are a way for businesses to manage and record returns or adjustments related to purchases from suppliers. They help maintain accurate accounts payable and inventory records. Here’s a closer look at what vendor credits are, when to use them, and how to process them in NetSuite. What is a Vendor Credit? A vendor… Continue reading Vendor Credits