USE CASE The following steps will display a custom Total Weight column field on sales transactions. Total Weight is the product of Quantity and Weight columns per line item. This field can be used for shipping. 1.Navigate to Customization > Lists, Records, & Fields > Transaction Columns Fields > New. 2.Set the following: Label = Weight {placeholder} Type = Decimal Number Store… Continue reading Display Total Weight Per Line Item
Author: Karishma Krishnadas
State Fields in Workflow
tate fields apply to a single state in a workflow. Similar to a workflow field, use a state field to get and set data within a workflow. NetSuite populates the value of the field when the record in the workflow enters the state that contains the state field. You can use the state field in… Continue reading State Fields in Workflow
Partner Commissions & Royalties Feature
The NetSuite Partner Commissions/Royalties feature enables you to create commission plans that automatically calculate and pay commission to your partners. To begin using the Partner Commissions/Royalties feature, do the following: Have an administrator enable the Partner Commissions/Royalties feature at Setup > Company > Enable Features > CRM. Set your commissions preferences at Setup > Sales >… Continue reading Partner Commissions & Royalties Feature
Commission reports
Reports Associated with Commissions We can run following commission reports in NetSuite. Commission Overview Report The report shows commissions for each transaction, by sales people who are on commission plans, at every level of your sales staff hierarchy. This report includes all commissionable transactions including sales orders, cash sales, invoices, return authorizations, cash refunds, and… Continue reading Commission reports
Bulk order picking in the WMS
We can pick the bulk products using the “Bulk picking” picking type by creating the wave. To perform bulk order picking in the application From the Main Menu, tap Picking. On the Select Picking Type page, tap Multi-Order Picking.
Budget Vs Actual Report:
The Budget vs. Actual report combines an income statement with a budget income statement for the same set of criteria including both dollar and percentage comparisons between the two. This report enables you to analyze budgeted and actual financials to determine how closely your income and expenses compare to those you originally budgeted. The standard… Continue reading Budget Vs Actual Report:
Function used to sales order search for get the context value
function transactionSearch(orderID){ try{ var transactionSearchObj = search.create( { type: “salesorder”, filters: [ [“type”,”anyof”,”SalesOrd”], “AND”, [“systemnotes.context”,”anyof”,”WST”], “AND”, [“internalid”,”anyof”,orderID], “AND”, [ “mainline”, “is”, “T” ] ], columns: [ search.createColumn({ name: “context”, join: “systemNotes”, label: “Context” }) ] } ); var searchResultCount = transactionSearchObj.runPaged().count; log.debug( “transactionSearchObj result count”, searchResultCount ); transactionSearchObj.run().each( function ( result ) { contextValue =… Continue reading Function used to sales order search for get the context value
NetSuite’s Commission Features
Commissions The NetSuite sales compensation feature seamlessly integrates with accounting and payroll features. When we enter deals, NetSuite automatically calculates the commission. We do not have to work with complicated spreadsheets or import data between applications. The benefit of this integration because they will know how much commission they have earned before they receive their… Continue reading NetSuite’s Commission Features
Function of replace data in email body
function getHtmlBody(Template,htmlbody, replaceData) { try { let html = htmlbody; if (Template === sevenDaysTemplate) { html = html.replace(‘#close’, replaceData.closingdate); html=html.replace(‘#orders’,replaceData.orders) } else if (Template === fourteenDaysTemplate) { html=html.replace(‘#orders’,replaceData.orders); } else if(Template === fifteenDaysTemplate){ html=html.replace(‘#orders’,replaceData.orders); } return html } catch (e) { log.debug({ title: e.name, details: e }); log.error({ title: e.name, details: e }); }}
Proposal For Auto Generated Invoice Enabling for All Subsidiaries
Proposal summary This proposal describes the AMVOP would like to build an auto-invoicing process enabled for all subsidiaries with multiple users and roles and restrict the invoice view permission for a selected user and role in the system. Requirement The auto-invoicing process is enabled for all subsidiaries with multiple users and roles. When the selected… Continue reading Proposal For Auto Generated Invoice Enabling for All Subsidiaries