Requirement We will be able to create a Sales report in NetSuite to understand the revenue, cost, gross profit and gross profit percentage from a transaction. Solution Create a Transaction Saved search Add the following filters to the Criteria section Type = Sales Order, Invoice Main line = true Add the following columns in the… Continue reading Sales Report which shows the Revenue, Cost and Gross Profit
Author: Aranya T R
Resolve Sublist Line Item not Committing via Client Script
Issue User is not able to commit a line item via SuiteScript 2.0 Client Script. Solution The reason why the line item is not committing on the script is because the forceSyncSourcing parameter is retains its default value as false. The forceSyncSourcing parameter indicates whether to perform field sourcing synchronously. If set to true, sources dependent field information for… Continue reading Resolve Sublist Line Item not Committing via Client Script
Moving Fields and Lists Between Subtabs
Requirement User is needed to move the terms field from the Billing tab to the Main Body fields. Solution To move fields and lists between subtabs: Edit the form to be customized. Click the button “Move Elements Between Subtabs“ Choose the subtab where the “Terms” field to be displayed. Click Save.
Add ‘Components’ Column in NetSuite View of the item record
Bill of Materials Member Control for Assembly Items When you use the Assembly Items feature, the components needed for assemblies are identified in the Bill of Materials (BOM). Components required for an assembly can change due to engineering changes, vendor supply, availability, or seasonal requirements. BOM member control helps you ensure that the right components… Continue reading Add ‘Components’ Column in NetSuite View of the item record
Difference between Purchase Requests and Purchase Requisitions
Key differences between Purchase Requests and Purchase Requisitions are: Purchase Requisitions are included in NetSuite’s Advanced Procurement module while purchase requests are included in the base product. Purchase Requests require identification of the vendor for each item/expense purchased, while the vendor is not required for a Purchase Requisition. Purchase Requests can only be entered against… Continue reading Difference between Purchase Requests and Purchase Requisitions
Cash 360 Dashboard Vs Item 360 Dashboard
Cash 360 Item 360 Definition Provides a real-time view of your cash position and generate fast and accurate near-term forecasts. Provides a real-time and concise overview of an item’s current status. Key Benefits Realtime visibility into your organization’s cash position An accurate and comprehensive process for cash forecasting using NetSuite transactional data as well as… Continue reading Cash 360 Dashboard Vs Item 360 Dashboard
Standard Shipping Cost calculation based on different Shipping methods in NetSuite
Navigate to Lists>Accounting>Shipping Items to view existing shipping options or create new ones. On the Shipping Item setup page, NetSuite gives you the choice of how you want to calculate your shipping. Each item can only have one option selected, but you can set up multiple shipping items to accommodate the needs of your business and its customers. Real-Time… Continue reading Standard Shipping Cost calculation based on different Shipping methods in NetSuite
Function to add GL Lines in a custom transaction
Saved Search Shows Identical Values in Multiple Formula (Numeric) Fields
Issue When using multiple formula fields with numeric values in a saved search, you may encounter an issue where the search results display the same value in all these fields, even if they should be different. Solution: Use Labels with Numeric Formulas To resolve this problem, use different labels for each of your numeric formula… Continue reading Saved Search Shows Identical Values in Multiple Formula (Numeric) Fields
Custom GL Plugin Script to reverse the GL posted to the Sales account.
Requirement Client would like to introduce a novel GL posting approach for its sales transactions, focusing on recognizing revenue exclusively after order fulfillment. Under this system, when generating the cash sale record, the GL impact posting into the sales account will undergo a reversal. Simultaneously, the equivalent amount will be redirected and posted into the… Continue reading Custom GL Plugin Script to reverse the GL posted to the Sales account.