Use of ignoreFieldChange options in record.setCurrentSublistValue(options)

There is a no of scenarios where the field values are auto-populated on the field change of a sublist field. For example, when an item sublist field value has been set in the sales order item lines, then fields like rate, tax code, description, location, etc will be automatically populated in the item line. The… Continue reading Use of ignoreFieldChange options in record.setCurrentSublistValue(options)

PROPOSAL FOR REMOVE THE CORRESPONDING PO AND ETA COLUMN VALUES FROM SALES ORDERS.

Proposal summary This is a proposal for removing the corresponding PO and ETA column value from the sales order. Requirement  Determine which sales orders are included in the corresponding PO and make sure the committed quantity equals the order quantity. If the condition is met, remove the corresponding PO value and the estimated time of… Continue reading PROPOSAL FOR REMOVE THE CORRESPONDING PO AND ETA COLUMN VALUES FROM SALES ORDERS.

Excluding Inactive values from a list in a custom field

Scenario: We have a custom field ‘Asset type Department’, which is a list/record field. it lists departments. There are some inactive departments are there. We need to filter out these inactive departments from the list. This field is sourcing from Employee record. Solution: Open the custom field setup page 2. Go to Sourcing & Filtering… Continue reading Excluding Inactive values from a list in a custom field

Differentiate OneWorld and Mid-market accounts for Scripts

While creating scripts for NetSuite OneWorld and Mid-market accounts, we can make use of the feature runtime.isFeatureInEffect(‘SUBSIDIARIES’)) returns true if Subsidiary is present and thereby denoting One World account. returns false if Subsidiary is absent and thereby denoting Mid-market account. runtime.isFeatureInEffect(‘MULTISUBSIDIARYCUSTOMER’)) returns true if Subsidiary is present and thereby denoting One World account. returns false… Continue reading Differentiate OneWorld and Mid-market accounts for Scripts

Assign sales rep to sales order item line.

Automating the value of the sales rep in the sales order item line. The sales rep will be identified based on the customer territory and the item’s brand value setup in the custom record. Requirements Is there any way to automate this using sales rules? The scenario will be the customer is located in a… Continue reading Assign sales rep to sales order item line.

UPDATING PURCHASE ORDER ITEM QUANTITY ON THE BASIS OF THE SAVED SEARCH PENDING QUANTITY VALUE

This proposal covers the scope of updating the purchase order item quantity on the basis of the saved search pending QTYS column value. Requirement Create a script that takes that item and subtracts the quantity from the “Pending Qty” column. So, if the order is 5 and the pending qty is 1, You delete one… Continue reading UPDATING PURCHASE ORDER ITEM QUANTITY ON THE BASIS OF THE SAVED SEARCH PENDING QUANTITY VALUE

CRM – API Integration & customization

NFC-3 This proposal was submitted to the client to create a 3rd party API integration with the Netsuite. Project Goals  Get the estimation for CRM – API Integration and customization. Our Solution As per our best understanding, the task is to create an API integration with the 3rd party system OSCAR EMR.  INTEGRATION We have… Continue reading CRM – API Integration & customization

SALES REP CONTRIBUTION BASED ON THE BRAND.

This proposal covers the scope of displaying the sales rep contribution based on the brand. Requirement  The client sells many types of brands. The sales reps are responsible for selling these brands, the sales rep can sell more than one brand.  A customer can have multiple sales reps if they buy different brands. On a… Continue reading SALES REP CONTRIBUTION BASED ON THE BRAND.