Hey Can anyone help me with this requirement plz? ...
# suitescriptd
Devyani Jain
07/10/2023, 6:56 AMHey Can anyone help me with this requirement plz? (User event script I want )
Need to show an error message when transaction going to save with the sub total amount greater than 100 bucks and also if transaction total amount is exceed the customer credit limit.
Alert Messages :
a. Confirm transaction amount greater than 100 bucks.
b. Order amount exceeds credit limit.
b
battk
07/10/2023, 7:09 AMuser event is a pretty bad choice for those requirements
battk
07/10/2023, 7:10 AMthe record has already been submitted, there is no chance to make any changes, you can only throw an error and prevent the record from being saved
d
Devyani Jain
07/10/2023, 7:10 AMBut my trainer told me to use user event script here
Devyani Jain
07/10/2023, 7:11 AMCan you help me with the code please, m' beginner just learning NS
b
battk
07/10/2023, 7:12 AMfirst step is making a user event script
battk
07/10/2023, 7:13 AMin this case, probably by implementing the beforeSubmit entry point
d
Devyani Jain
07/10/2023, 7:13 AMYes i used beforeSubmit function
Devyani Jain
07/10/2023, 7:14 AMcan you check my code please ?
Devyani Jain
07/10/2023, 7:14 AM Copy code
/**
* @NApiVersion 2.1
* @NScriptType UserEventScript
* @NmoduleScope SameAccount
*/
define(['N/record'], function (record) {
function myBeforeSubmit(scriptContext) {
var newRecord = scriptContext.newRecord;
//check if subtotal is greater than 100
var subtotal = newRecord.getValue({
fieldId: 'subtotal',
});
if (subtotal > 100) {
throw 'Confirm transaction amount greater than 100 bucks'; //throw the explicit error
log.debug({
title:'transaction subtotal',
details: 'transaction subtotal exceeds 100 bucks'
});
return false; // prevent the transaction from being saved
}
var customerId = newRecord.getValue({
fieldId: 'entity'
});
var customerObj = record.load({ //lookup , credit limit column
type: newRecord.Type.CUSTOMER,
id: customerId
});
var customerCreditLimit = customerObj.getValue({
fieldId: 'creditlimit'
});
var transactionTotal = newRecord.getValue({ // it should be transaction total or only total ? or customer balance ?
fieldId: 'total'
});
if (transactionTotal > customerCreditLimit) {
throw 'Order amount exceeds credit limit';
log.debug({
title:'order total',
details: 'Transaction total ('+ transactionTotal+') exceeds credit limit('+ customerCreditLimit +')'
});
return false; //prevent the transactionfrom being saved
}
return true;
}
return {
beforeSubmit: myBeforeSubmit
};
});b
battk
07/10/2023, 7:16 AMall the code related to the credit limit is mostly useless, its reimplementing functionality that already exists in netsuite
battk
07/10/2023, 7:17 AMand in this case, probably implemented incorrectly, you arent usually interested if the transaction is larger than the credit limit
battk
07/10/2023, 7:18 AMa credit limit usually goes into effect when the customer's balance plus the current transaction goes over the limit
battk
07/10/2023, 7:21 AM Copy code
var subtotal = newRecord.getValue({
fieldId: 'subtotal',
});
if (subtotal > 100) {
throw 'Confirm transaction amount greater than 100 bucks'; //throw the explicit error
log.debug({
title:'transaction subtotal',
details: 'transaction subtotal exceeds 100 bucks'
});
return false; // prevent the transaction from being saved
}battk
07/10/2023, 7:22 AMbut
Copy code
log.debug({
title:'transaction subtotal',
details: 'transaction subtotal exceeds 100 bucks'
});
return false; // prevent the transaction from being savedbattk
07/10/2023, 7:22 AMthrowing an error stops those lines from running
battk
07/10/2023, 7:22 AMalthough in this case, you are throwing a string, which is generally frowned upon
battk
07/10/2023, 7:22 AMthough will give a prettier error message for the user
d
Devyani Jain
07/10/2023, 7:23 AMlike i am asking where do I write the code again or correct it ?
b
battk
07/10/2023, 7:26 AMim not writing any code for you
battk
07/10/2023, 7:27 AMyou will have to go through what i wrote and see if it applies or doesnt
d
Devyani Jain
07/10/2023, 7:28 AM🥲okay, I will try , If still i face any error , can you help me out ?
b
battk
07/10/2023, 7:37 AMok
3 Views