PO and IR Rate Sync

Typically, when there’s a change in the rate specified in purchase orders, the corresponding rates in previously generated item receipts won’t be automatically adjusted to the updated rate. To address this, we can employ the provided script to ensure that the rates in item receipts are synchronized with any changes made to the rate in… Continue reading PO and IR Rate Sync

Correlated item in the Website

Correlated and related items create up-sell opportunities by displaying additional items to shoppers in your web store. Correlated items are dynamically created from the site statistics based on the shopper’s buying behavior, such as the ratio of items added to the shopping cart versus those that were ultimately purchased. The list of correlated items is… Continue reading Correlated item in the Website

How to get a contact from a contact search by editing the phone number in the url

Changing the phone number in the saved search link(URL), provides the accurate result as per the Contact(s) with the corresponding Phone number. This can be done by adding phone number as an available filter while creating the saved search. Then we can fetch the required contact information just by changing the phone number in the… Continue reading How to get a contact from a contact search by editing the phone number in the url

Currency changing in Profit and Loss Report

We have checked the possibility to change the OX Group Global (Consolidated) currency from AUD to GBP by keeping OX Group Global subsidiary currency as AUD in the income statement/Profit and Loss Report. As per the standard limits of NetSuite the said requirement is not possible. As an alternative solution we can try by creating… Continue reading Currency changing in Profit and Loss Report

Cash Sale to Invoice

To replace references to “Cash Sale” with “Invoice” in customer-facing documents (email, pdf forms, etc). Select the transaction form that corresponds to the Cash Sale. Under Printing Fields, select Form Tile and tick the checkbox next to it. Name the label as Invoice and save it. Now Email and PDF template associated with Cash Sale… Continue reading Cash Sale to Invoice

Custom Segments

The Custom Segments feature lets you create custom classification fields similar to class and department. You can create an unlimited number of custom segments, define possible values for each segment, and add the segments to specific record types. People working in NetSuite can then use the segments to classify records appropriately. You can configure segments… Continue reading Custom Segments

Tip to handle zero prefixed values, when converting an array to CSV.

Suppose we have an item with the name “00328ac“, and we want to add this information to a CSV file as a column value. By default, when we open this CSV file in Excel, the leading zeros in the item name will be removed, and the value will be displayed as “328ac“. To ensure that… Continue reading Tip to handle zero prefixed values, when converting an array to CSV.