YASSER
01/19/2025, 11:36 AMCeligo AI
01/19/2025, 11:37 AMAI generated answer (using internal Slack threads):Based on the conversations, you can achieve this by using a User Event (UE) script in SuiteScript. The script should be deployed on the Invoice record and it should validate the discount rate whenever a user tries to save the invoice. If the discount rate is more than 20%, the script should prevent the record from being saved and display an error message to the user. Here is a sample code snippet that you can use as a starting point:
javascript
/**
* @NApiVersion 2.x
* @NScriptType UserEventScript
*/
define(['N/record', 'N/ui/serverWidget'], function(record, serverWidget) {
function beforeSubmit(context) {
if (context.type !== context.UserEventType.CREATE && context.type !== context.UserEventType.EDIT)
return;
var newRecord = context.newRecord;
var lineCount = newRecord.getLineCount({sublistId: 'item'});
for (var i = 0; i < lineCount; i++) {
var discountRate = newRecord.getSublistValue({
sublistId: 'item',
fieldId: 'discountrate',
line: i
});
if (discountRate > 20) {
throw new Error('Discount rate cannot be more than 20%. Please edit the rate to be less than or equal to 20%');
}
}
}
return {
beforeSubmit: beforeSubmit
};
});
This script checks the 'discountrate' field on each line item of the invoice. If the discount rate is more than 20%, it throws an error and prevents the record from being saved.
Please note that you need to deploy this script on the Invoice record type in NetSuite.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
01/19/2025, 11:37 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818739772
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.811456
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.80829668
Celigo AI
01/19/2025, 11:37 AM