Custom Sales by Customer Detailed Report > Amount is Compounding when Address Book is used as a filter.

It is standard system behavior when running a custom Sales report – Detail (and Address Book is added as a filter) that if the customer record has more than one address book row, the report will generate multiple results. Example, invoice amount is $500, then customer has three addresses listed in the address book, the report would show the invoice amount… Continue reading Custom Sales by Customer Detailed Report > Amount is Compounding when Address Book is used as a filter.

Enabling Intercompany Cross-Subsidiary Fulfillment

to use Intercompany Cross-Subsidiary Fulfillment, we must enable the feature in NetSuite Account. To enable Intercompany Cross-Subsidiary Fulfillment: Go to Setup > Company > Enable Features. Check the Items & Inventory subtab. Check the Multi-Location Inventory and Intercompany Cross-Subsidiary Fulfillment boxes. In the Transactions subtab, check the Advanced Shipping and Multiple Shipping Route s boxes.To enable Multiple Shipping Routes, you first need to enable. Click Save. To create a… Continue reading Enabling Intercompany Cross-Subsidiary Fulfillment

Trigger Map/Reduce Script Using Task Module via SuiteScript 2.0

A user requires a sample snippet to trigger a Map/Reduce script with Task module with custom script parameters. let mapReduceData = new Object;mapReduceData[“dataArray”] = dataArray let mrTask = task.create({‌taskType : task.TaskType.MAP_REDUCE});var scriptParams = {‌};scriptParams.custscript_datastring = JSON.stringify(mapReduceData); mrTask.scriptId = “customscript_generate_coupon_mr”;mrTask.deploymentId = “customdeploy_generate_coupon_mr”;mrTask.params = scriptParams; mrTask.submit();.

How do we add a new role access in NetSuite?

Create Employee Records: Go to Lists > Employees > Employees. Click the New Employee button. Fill in the employee’s information, such as name, email address, contact details, and other relevant information. Set the Access role to “Employee” or other applicable roles based on their responsibilities. Assign User Role: After saving the employee record, you can… Continue reading How do we add a new role access in NetSuite?

Cost Centre in NetSuite

In NetSuite, a cost center structure is a way to organize and track expenses and costs within your organization. It helps you allocate and manage costs to specific departments, locations, or projects, allowing for better financial management and reporting. Here’s how you can set up a cost center structure in NetSuite: Create Departments: In NetSuite,… Continue reading Cost Centre in NetSuite

Display Text or Images on the Order Confirmation Page Only in Site Builder

Display the Text or Images on the Order Confirmation Page only. Follow the steps below to render a text or an image on the Order Confirmation page. Solution Create a Custom TagNote: Tag substitution is required to accomplish this.  Navigate to Commerce > Site Builder > Tags > New Tag: Enter TagExample: CHECKTAG Description: Enter Description Default Value: Enter Default Value Click Save Add a <div> Tag in the ThemeNote: This is the location of… Continue reading Display Text or Images on the Order Confirmation Page Only in Site Builder

How to hide the Script ID field on a custom record form?

There are cases where Users need to hide the Script/ID field of a Custom Record. If SuiteCloud Development Framework feature is enabled, this may result for the Script ID field to be present on Forms that are made from Custom Records. Solution Navigate to Home > Set Preferences Click General SuiteCloud Development Framework:  Show ID Field on Sublists: Remove Checkmark Click Save

Saved Search to Calculate for On Time Delivery Percentage on Orders Placed by Customers

Currently, there is no standard report that provides this information but the above data can be calculated by creating a custom Transaction Saved Search. Here are the steps: 1. Navigate to Reports>Saved Searches>All Saved Searches>New 2. Select Search Type: Transaction -Navigate to Criteria tab>Standard subtab>Filter column and add: Type = is Sales Order -Navigate to Criteria tab>Summary subtab and add the details below: Summary Type: Sum | Formula (Numeric) | Formula:… Continue reading Saved Search to Calculate for On Time Delivery Percentage on Orders Placed by Customers

Google Fonts API

How to use the Google Fonts API to add fonts to your web pages. You don’t need to do any programming; all you have to do is add a special stylesheet link to your HTML document, then refer to the font in a CSS style. A quick example Here’s an example. Copy and paste the… Continue reading Google Fonts API