Version: eXtendGrossProfit 1.0.8 and above

Audience: Administrator

Overview

eXtendGrossProfit enables the calculation of gross profit details on Estimates (Quotes) and Sales Orders. This can be done in real-time or through a scheduled update. eXtendGrossProfit offers configuration options to select which item cost and item price transaction column fields will be used.

Configuration

Setup Page

Go to eXtendTech → eXtendGrossProfit → Setup.
Configure the fields per the descriptions below:

Field Number	FIELDS	DESCRIPTIONS
1	SALES ORDER ITEM COST COLUMN FIELD ID	Specify the column field id for the Item Cost field to be used for gross profit calculations on the Sales Order.
2	SALES ORDER ITEM PRICE COLUMN FIELD ID	Specify the column field id for the Item Price to be used for gross profit calculations on the Sales Order.
3	ESTIMATE ITEM COST COLUMN FIELD ID	Specify the column field id for the Item Cost to be used for gross profit calculations on the Estimate.
4	ESTIMATE ITEM PRICE COLUMN FIELD ID	Specify the column field id for the Item Price to be used for gross profit calculations on the Estimate.
5	SALES ORDER SAVED SEARCH ID	Specify the saved search id to be used for pulling the Estimate (Quote) and/or Sales Order records which need to be processed for gross profit calculation on a scheduled basis. The search should not pull old Estimate or Sales Orders for performance considerations. Leave the default search selected if you are not sure.

In NetSuite OneWorld accounts, an additional field for "Base Currency" will be shown on the setup screen. This field is used to specify the Base Currency used in gross profit calculations.

Custom Forms

To show the elements from eXtendGrossProfit on your Estimate (Quote) and Sales Order records, the fields may need to be made visible.

Customize the custom transaction form where eXtendGrossProfit elements should be made visible.
To enable the fields for use, show the fields below on the form, and ensure that the fields are set as "Normal" for their display type.

eXtendTech Aggregate Sales Price
eXtendTech Aggregate Cost
eXtendTech Aggregate GP $
eXtendTech Aggregate GP%
eXtendTech Gross Profit Calculation
eXtendTech Gross Profit Run on Save

You can move the fields to whichever subtab / location that you prefer.

To run the calculations, create a new Estimate (Quote) or Sales Order or edit an existing one. After line items have been entered, navigate to where you placed the eXtendGrossProfit fields on the form and click the Calculate Gross Profit button.

Alternatively, the calculations can be run automatically upon record save by defaulting or checking the eXtendTech Gross Profit Run on Save field.

Script Deployments

For eXtendGrossProfit functionality to operate, script deployments need to be created so that the necessary scripts are available and running.

These deployments may already be in place, so check to see if they are already deployed in your environment prior to deploying them.

eXtendTech Gross Profit Calculation UE

Go to Customization → Scripting → Scripts.
Find the script titled eXtendTech Gross Profit Calculation UE and open it in view mode.
This script will need to be deployed on each record type where it will be used (Estimate and/or Sales Order).
Check the deployments list to confirm if the script deployment is already in place and released on your target record type.
Deploy the script on the Applies To record type, with a Status of Released, and for All Roles as the Audience. Repeat this step for the Estimate and/or Sales Order.

eXtendTech Gross Profit Calculation CS

Go to Customization → Scripting → Scripts.
Find the script titled eXtendTech Gross Profit Calculation CS and open it in view mode.
This script will need to be deployed on each record type where it will be used (Estimate and/or Sales Order).
Check the deployments list to confirm if the script deployment is already in place and released on your target record type.
Deploy the script on the Applies To record type, with a Status of Released, and for All Roles as the Audience. Repeat this step for the Estimate and/or Sales Order.

Batch Updates

The batch update feature allows updating all Sales Orders (meeting the criteria of an associated saved search) with eXtendGrossProfit.

On Demand Batch Update

To trigger the batch update, go to Setup → eXtendGrossProfit → Sales Order Job Runner.

Scheduled Batch Update

For the scheduled batch update, you will create a new script deployment for the eXtendTech Gross Profit Map/Reduce script. Then you will schedule this deployment according to the schedule you'd like to use.

Check that this hasn't already been created and scheduled prior to creating an additional script deployment.

Go to Customization → Scripting → Scripts and find and open the eXtendTech Gross Profit Map/Reduce script.
Create a new scheduled script deployment.

Currency Consideration Logic

NetSuite's Multiple Currencies feature must be enabled to utilize eXtendGrossProfit with multiple currencies.

When using eXtendGrossProfit in a Multiple Currencies account, users must have View access to the Lists → Currency permission to run gross profit calculations and perform exchange rate lookups.

OneWorld Accounts

a. The currency on the item line level will have the highest priority for GP calculation.

b. If the currency is not available at the line level, then the Base Currency of the Subsidiary of the Customer selected on the transaction will be considered for GP calculation.

c. If the line items have multiple currencies on them, then the currency exchange rate calculations will be done based on the Sales Order's transaction date (trandate) for performing an exchange rate API lookup.

d. The final GP calculation will be performed in the customer's subsidiary's Base Currency which is selected on the transaction.

When using eXtendGrossProfit in a OneWorld account, users must have View access to the Lists → Subsidiaries permission to run gross profit calculations.

Non-OneWorld Accounts