Hello everyone, I began developing a script in sandbox that would assign a commission percentage to each line item of a sales order and quote. I created a transaction line field, COMM % and have it set to a list record. The values range from 0 - 10. I am reading into SAID 94464 for inspiration. However, this script is doing things different. My process is going to be much different than that. What I want to do is assign the options based on the line item's EST. GROSS PROFIT PERCENT If the GP is within a certain percentage range, then the COMM % will select whichever option there is. Examples: * If a line items gp% is between 10% - 15%, then select option 1 * If a line items gp% is over 50%, then select option 10 The script I am reading through, provides a general gross profit to the entire order. How can I do this for every line item? I was thinking it can go like this. At first, I was considering EST. GROSS PROFIT PERCENT, but this field only appears when viewing the record and not during the edit process. I would need to calculate the GP by acquiring the EST. EXTENDED COST and Amount values, once I get the GP % from that, then I can run it through the conditions of which to assign the COMM % option. It would work the same way with the aftersubmit function.

Hello @Joahnna Given Uy-Oracle I was able to get my script to work, I had to add different events in order to get it to work, /** * @NApiVersion 2.1 * @NScriptType ClientScript * @NModuleScope SameAccount */ define(['N/currentRecord','N/record'], (currentRecord,record)=>{ const CommLoad = (context)=>{ var currRecord = context.currentRecord, lines = currRecord.getLineCount({ sublistId: 'item' }); for(let i=0; i<lines; i++){ const lineNum = currRecord.selectLine({ sublistId: 'item', line: i }); var lAmnt = currRecord.getCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'amount'}); var lCost = currRecord.getCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'costestimate'}); var GP = Math.trunc(((lAmnt-lCost)/lAmnt)*100); GP = GP.toFixed(2); //console.log('line: '+i,'Amount: '+lAmnt,'Cost: '+lCost,'Gross Profit: '+GP); if (GP = 10.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 2 }); } if (GP >= 15.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 3 }); } if (GP >= 20.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 4 }); } if (GP >= 25.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 5 }); } if (GP >= 30.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 6 }); } if (GP >= 35.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 7 }); } if (GP >= 40.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 8 }); } if (GP >= 45.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: i, fieldId: 'custcol3', value: 9 }); } } //end for } const CommValidate = (context) =>{ var currRecord = context.currentRecord, lineNum = currRecord.getCurrentSublistValue({ sublistId: 'item', fieldId: 'line' }), lAmnt = currRecord.getCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'amount'}), lCost = currRecord.getCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'costestimate'}), GP = Math.trunc(((lAmnt-lCost)/lAmnt)*100); GP = GP.toFixed(2); //console.log('line: '+lineNum,'Amount: '+lAmnt,'Cost: '+lCost,'Gross Profit: '+GP); if (GP = 10.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 2 }); } if (GP >= 15.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 3 }); } if (GP >= 20.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 4 }); } if (GP >= 25.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 5 }); } if (GP >= 30.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 6 }); } if (GP >= 35.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 7 }); } if (GP >= 40.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 8 }); } if (GP >= 45.00) { currRecord.setCurrentSublistValue({ sublistId: 'item', line: lineNum, fieldId: 'custcol3', value: 9 }); } return true; } const CommFChange = (context) =>{ } return { pageInit: CommLoad, validateLine: CommValidate, fieldChanged: CommFChange }; });

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Child Item

Accounting / ERP

Child Item

Assigning a commission to each line item of a sales order / quote

JPrice

Hello everyone,

I began developing a script in sandbox that would assign a commission percentage to each line item of a sales order and quote.

I created a transaction line field, COMM % and have it set to a list record. The values range from 0 - 10.

I am reading into SAID 94464 for inspiration. However, this script is doing things different. My process is going to be much different than that.

What I want to do is assign the options based on the line item's EST. GROSS PROFIT PERCENT

If the GP is within a certain percentage range, then the COMM % will select whichever option there is.

Examples:

If a line items gp% is between 10% - 15%, then select option 1
If a line items gp% is over 50%, then select option 10

The script I am reading through, provides a general gross profit to the entire order.

How can I do this for every line item? I was thinking it can go like this.

At first, I was considering EST. GROSS PROFIT PERCENT, but this field only appears when viewing the record and not during the edit process.

I would need to calculate the GP by acquiring the EST. EXTENDED COST and Amount values, once I get the GP % from that, then I can run it through the conditions of which to assign the COMM % option.

It would work the same way with the aftersubmit function.

Find more posts tagged with

javascript

suitescript

suitescript 2.0

Component react.asset.answerThread had an error.

You are not allowed to view comments.

Child Item

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
Big ideas. No travel required. SuiteWorld On Air brings the best of SuiteWorld directly to you. Stream keynotes live, access exclusive virtual content, and connect with the NetSuite community from wherever you are. Explore what's next for NetSuite, see AI innovation in action, and discover practical insights designed to…
Learning Lab | DC
Drive better outcomes with AI built into NetSuite Next Capital Hilton,1001 16th St NW, Washington, DC 20036 Join NetSuite experts for a free half-day event where you'll get a tour of NetSuite Next, explore AI-powered capabilities built into the platform, and learn practical ways to optimize NetSuite for your business. At…
Inside the Suite | DC
Take NetSuite Next for a hands-on test drive Capital Hilton, 1001 16th St NW, Washington, DC 20036 What to expect: Inside the Suite is designed for companies exploring modern ERP solutions. This event gives you the opportunity to experience NetSuite Next - the next evolution of NetSuite that brings AI directly into how…
What's Next for Product Companies with NetSuite
WEBINAR What's Next for Product Companies with NetSuite See how NetSuite Next uses AI to improve accuracy and protect margins Ask. Understand. Act. Use Ask Oracle to search, navigate, analyze business data, surface insights, get guidance, and take action using natural language—all through a single conversational…

More events