Hello! For a Journal Entry, is it possibly to crea...
# generalb
Bobby Bukovec
01/10/2024, 9:11 PMHello! For a Journal Entry, is it possibly to create a workflow which will automatically fill in the line level "location" field depending on which line level "account" is chosen? If so, how does this work?
m
Marc
01/10/2024, 9:33 PMWF is not possible without scripting because the sublist line is not supported ( only sublist item )
b
Bobby Bukovec
01/10/2024, 9:38 PMThanks @Marc do you know what type of script that would be?
m
Marc
01/10/2024, 9:50 PMUser Event or Client script
y
yagyakumarnag
01/11/2024, 5:35 PMYou need to use a client script or user event script to take care of the location based on the JE account line.
b
Bobby Bukovec
01/11/2024, 6:47 PMHi @yagyakumarnag do you think a client script like below would work? I have tested this but it is not working how I would expect.
Bobby Bukovec
01/11/2024, 6:47 PM"/**
* @NApiVersion 2.x
* @NScriptType ClientScript
*/
define(['N/log', 'N/record'],
function(log, record) {
function pageInit(context) {
// Add any page initialization logic here
}
function fieldChanged(context) {
var currentRecord = context.currentRecord;
var sublistId = 'line';
var fieldIdAccount = 'account';
var fieldIdLocation = 'location';
if (context.fieldId === fieldIdAccount && context.sublistId === sublistId) {
var line = context.line;
var account = currentRecord.getCurrentSublistValue({
sublistId: sublistId,
fieldId: fieldIdAccount
});
// Filter locations based on account
var locations = getLocationsBasedOnAccount(account);
// Set the location field for the current line
currentRecord.setCurrentSublistValue({
sublistId: sublistId,
fieldId: fieldIdLocation,
value: locations
});
}
}
function getLocationsBasedOnAccount(account) {
// Add your custom logic to determine the location based on the account
// For simplicity, we'll return specific locations for account 612
if (account === '612') {
// Return the array of locations for account 612
return ['Nashville', 'Cleveland', 'Detroit'];
} else {
// Return default locations or handle other account scenarios
return [];
}
}
return {
pageInit: pageInit,
fieldChanged: fieldChanged
};
});
🤖 1
y
yagyakumarnag
01/12/2024, 1:36 AMI will suggestion would be to use field sourcing function.
Issue here is that getLoctionsBasedOnAccount return text value in array format so you need to changes it logic as below.
if(locations && locations.length>0)
currentRecord.setCurrentSublistText({
sublistId: sublistId,
fieldId: fieldIdLoction,
text: locations[0]
});
}
🙌 1
2 Views