[nzaleski@usatcorp.com]

I have tried a lot of combination on getting the reps email into a custom field on the item fulfillment. The one that seems like the best combination to me would Source List -> created from (i.e. the sales order), Source From -> Rep E-email.

I am wondering do you need the permissions for sourcing to be able to work? Because I have not been able to get anything to work. Example, I created a custom field on the sales order that was sourced in the following manner.. Source List -> Employee, Source From -> Sales Rep. And nothing showed up. I tried several different tests just to get something up and I cannot get anything to appear in reference to employee/sales rep/email. I know I don’t have Lists->Employee permission. I am doing this sourced field as a work around from using nlapiLookupField

Thanks.
This is a cached copy. Click here to see the original post.

[richard.la]

As long you do not have permission to see any employee, the list will appear empty. Have you tried to global search an employee just to be sure that you do not have access?

[nzaleski@usatcorp.com]

Thanks Richard. I though that might be the case. So is there no way for employee to access email address of other employees without having this permission? With Lists>Employees everyone can see everyone information including salary.

[richard.la]

You can create an employee directory. It’s like a phone book on the intranet of NetSuite. Look up “Employee Directory” in the help.

But quickly, go to Lists > Web Site > Employee Directories.

From there you can create it without giving permissions. Try it out.

[richard.la]

But it’s not the best solution. If not, another way that you can try, but I’m going on a limb here, is the create a custom field that sources the value of the email, and that you but a granular permission on that field.

[nzaleski@usatcorp.com]

I think setting up an employee directory might work. Hopefully it will prove beneficial in the future. As for setting up the graduation of email only, I do not believe that is possible to do. I have an administrator role and I see nothing like that. On the NetSuite Permission Usage spreadsheet it appears like there are graduation, but when you go to set the permissions it does not offer it. For example Lists>Employees may have this in the spreadsheet

Lists
> Employees>
Allows usage of Employee record.

Lists>
Employees>
Allows usage of the Assign Reps task.

Lists>
Employees>
Allows usage of the Author field on the Employee System Notes report component.

Lists>
Employees>
Allows usage of the Employee bulk operation.

Lists>
Employees>
Allows usage of the Employee Change History report definition.

Lists>
Employees>
Allows usage of the Employee Change History task.

Lists>
Employees>
Allows usage of the Employee field on the Employee System Notes report component.

Lists>
Employees>
Allows usage of the Employee search.

Lists>
Employees>
Allows usage of the Employee System Notes report component.

Lists>
Employees>
Allows usage of the Employees snapshot.

Lists>
Employees>
Allows usage of the Employees task.

Lists>
Employees>
Allows usage of the New Assign Support Reps task.

Lists>
Employees>
Allows usage of the New Employees task.

Lists>
Employees>
Allows usage of the Reformat Employees Using First Name First bulk operation.

Lists>
Employees>
Allows usage of the Reformat Employees Using Last Name First bulk operation.

Lists>
Employees>
Allows usage of the Search Employee task.

Lists>
Employees>
Allows viewing and editing of the Employee record.

Lists>
Employees>
Allows viewing of the Employee Change History Report report.

But when you go to NetSuite all there is is Lists>Employees.

Am I incorrect about that? Is there somewhere where you can set the graduation of the permissions in NetSuite? That would be great if there was.

[richard.la]

Sorry for not understanding the word “graduation” (because I’m french canadian), but what does it mean on the employee record?

[nzaleski@usatcorp.com]

Haha, I actually misspoke maybe that is why you didn’t understand. I meant to say gradation. As in you can set different levels on a specific permission. But I do not think that is possible, there are some restriction you can apply in reference to employee permissions though.

At any rate, I did get my script working. It turns out that you can use the search APIs without having the permission.

HTML Code:
function pageInit_trackingEmailAddress() {
var salesOrder = nlapiGetFieldValue(‘createdfrom’);
var filters = new Array();
filters[0] = new nlobjSearchFilter(‘internalidnumber’, null ,’equalto’, salesOrder)
var columns = new Array();
columns[0] = new nlobjSearchColumn(’email’,’salesrep’);
var searchResults = nlapiSearchRecord(‘salesorder’, null, filters, columns);

var repEmail = new Array();
repEmail.push(searchResults[0].getValue(columns[0]));

var trackingEmail = nlapiGetFieldValue(‘custbody30’);
nlapiSetFieldValue(‘sendbackupemailups’,’T’);
nlapiSetFieldValue(‘sendshipnotifyemailups’,’T’);
nlapiSetFieldValue(‘shipnotifyemailaddressups’, trackingEmail);
nlapiSetFieldValue(‘shipnotifyemailaddress2ups’,repEmail);
nlapiSetFieldValue(‘backupemailaddressups’,”shipping@”);
}

Thanks Richard

[richard.la]

My pleasure! Ça me fait plaisir!

[Author]

Posts